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

Q 1 - Which of the following transaction can be used to adjust an infoset after making changes




D - none of the above

Answer : A


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

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 SAP BW, table that consists of master data are kept in separate tables and this structure is known as

A - Star Schema

B - Extended Star Schema

C - InfoCubes

D - InfoArea

Answer : B


When the table consists of master data are kept in separate tables, this structure is known as extended star schema.

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 - 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

Answer : C


A query against a MultiProvider is divided into subqueries so more overhead of split queries and manage them.

Q 8 - A company wants to set up BI reporting on Sales data from source system without extraction. Which of the following SAP BW feature support this?

A - MultiProvider

B - Delta Load

C - Virtual Provider

D - InfoSets

Answer : C


You can access BI data from source system without extraction using Virtual Providers.

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.