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 is used for dividing table on row or column based and is used for report performance enhancement?

A - Partitioning

B - Reconstruction

C - Indexing

D - Roll up

Answer : A


Partioning is defined as dividing table based on available fields and it is easier to perform a search in smaller tables and hence reporting performance is enhanced.

Q 3 - In an Operational Data store, how many number of maximum keys an object can have?

A - 8

B - 16

C - 24

D - 32

Answer : B

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 - In SAP BW, InfoObjects in dimension tables are called?

A - Key Figures

B - Characteristics

C - Delta Load

D - Attributes

Answer : B


InfoObjects in Dimension tables are called characteristics and InfoObject in fact tables are called key figures.

Q 6 - An attribute of an InfoObject which is displayed with InfoObject and can't be used on its own is known as?

A - Navigation Attribute

B - Display Attribute

C - Detailed Attribute

D - Key Attribute

Answer : B


A display attribute is an attribute of an InfoObject that can be displayed together with InfoObject and cannot be used on its own.

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 - Which of the following transfer method doesn't support hierarchy upload?

A - IDoc


C - Full Load

D - All of the above

Answer : B


In Persistent Staging area data transfer, there is restricted use of hierarchy upload.

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

Answer : C


Virtual Providers with DTP is recommended for −

Up to date data from SAP system

Small amount of data is accessed from time to time

Few user execute queries simultaneously

Q 10 - Which of the following transaction is used in SAP BW to manage authorization objects?

A - SU12

B - SU21

C - SM59

D - SM56

Answer : B