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.

Questions and Answers

Answer : C


To set flat file parameters, you can use transaction RSCUSTV7

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


B - Operational Data Store

C - InfoCubes

D - Infoarea

Answer : B


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


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 - In SAP BW, which of the following is not an available option to perform data load from flat file?

A - Full Load

B - Half Load

C - New Status for changed records

D - Additive Delta

Answer : B

Q 5 - Which of the following are part of Dimension tables in BW?

A - Pointers to text values

B - SID's & Pointers to Fact table

C - Transfer Rules

D - None

Answer : B


Dimension tables in SAP BW contains SID and pointers to fact table.

Q 6 - Which of the following source system you can connect to SAP BW?

A - Printers

B - Video Conferencing based on VOIP

C - Fax machines

D - Source systems based on XML

Answer : D

Q 7 - In a Log view under process change management, a yellow mark shows that a process chain

A - Not Yet Run

B - Completed with no errors

C - Running

D - Failed

Answer : C


  • Grey: Not Yet Run
  • Green: Completed with no errors
  • Yellow: Running
  • Red: Failed

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 following in BEx suite is used to create BI queries?

A - Query Designer

B - Report Designer

C - Web Application Designer

D - Web Analyzer

Answer : A


Query Designer in BEx suite is used to create BI queries and is user friendly tool.

Q 10 - Which of the following class contains majority of authorization objects in BI?

A - AS

B - DS

C - RS

D - ZS

Answer : C


Authorization objects are grouped according to authorization object classes and majority of objects are in class RS in BI.


E-Books Store