SAP BW Online Quiz

Following quiz provides Multiple Choice Questions (MCQs) related to SAP BW. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Q 1 - To use special characters in BW, which of the following transaction can be used?

Answer : C

Explanation

RSKC is used to enter special characters in BW.

Q 2 - Which of the following transactions can be used for maintaining data sources in BW?

Answer : D

Explanation

RSA1 is used to open administration workbench.

RSA3 is used for checking data sources for extraction

RSA6 is used for mainting data sources

RSA5 is used for installing buisness content data sources

Q 3 - DB connect relies on ABAP stack and Universal Data connector is based on Java stack?

A - True

B - False

Answer : A

Explanation

Both UD connect and DB connect are used for connection to any database system which is able to provide data for BI system. DB Connect relies on ABAP Stack of WAS and UD Connect is built on JAVA Stack of WAS.

Q 4 - Which of the following is not a valid object in Operational data store?

Answer : D

Explanation

When new data comes in ODS, it gets store in New table. When it is activated it is written in Active tables and all changes has been recorded to change log.

Q 5 - Which of the following represent key figures in SAP BW?

A - None

B - Total Revenue & Amount

C - Product ID

D - Calendar Year

E - Customer Name

Answer : B

Explanation

Key figures represent the measurable values on which you perform the analysis.

Q 6 - In SAP BW system, we perform ETL process to load the data to Persistent Storage area. Which of the following is true?

A - Transformation are used for data load

B - DTP is used for data load to PSA

C - DB connect is used to load the data to PSA

D - InfoPackage are used for data load to PSA

Answer : D

Explanation

To perform data load to persistence storage area, InfoPackage are used.

Q 7 - A Virtual Provider can be created to read the data from an external SAP system or from an external non SAP system?

A - True

B - False

Answer : A

Explanation

You can perform reporting on external SAP or non SAP data source using Virtual provider without storing data physically.

Q 8 - Criteria for selecting PSA and IDOC methods transfer data depends on?

A - Load Performance

B - Query Performance

C - Volume of Data

D - Frequency of Data

Answer : C

Q 9 - Which of the Virtual provider is recommended when you need upto date and small amount of data from time to time and only few users query on data simultaneously?

A - VirtualProvider based on BAPI's

B - VirtualProvider with function modules

C - Virtual Providers with DTP

D - All of the above