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 - Which of the following transaction can be used to adjust an infoset after making changes

A - RSISET

B - RSKC

C - RRBS

D - none of the above

Answer : A

Explanation

RSISET transaction can be used to adjust changes in an infoset.

Q 2 - Which of the following component in BW architecture can be used for detailed storage of data and used for BEx reporting?

A - PSA

B - Operational Data Store

C - InfoCubes

D - Infoarea

Answer : B

Explanation

In SAP BW architecture, ODS can be used for detailed storage of data and used for BEx reporting. It exists between PSA and InfoCubes.

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 - In SAP BW, which of the following transaction can be used to display tables in Star schema?

Answer : C

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 - In Process Chain Maintenance, which of the following collector is used to send atleast one predecessor process to an event?

A - AND

B - OR

C - EXOR

D - None of the above

Answer : B

Q 8 - Which of the following is used to perform preliminary calculations and is used to store these in global data structure in a table?

A - Start Routine

B - End routine

C - Expert Routine

D - None of the above

Answer : A

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