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 - To use special characters in BW, which of the following transaction can be used?

A - RSA1

B - RSA15



Answer : C


RSKC is used to enter special characters in BW.

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 - Which of the following is not a valid object in Operational data store?

A - New

B - Active

C - Change

D - Update

Answer : D


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


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

Q 6 - In SAP BW, to create new InfoObjects to store data, which of the following tab is used in Administration workbench?

A - Administration

B - Data Source

C - Modeling

D - Translation

Answer : C


In RSA1, you use Modeling tab to create new objects to store BI data.

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


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

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 is component of Business Explorer suite?

A - Web Analyzer

B - Report Designer


D - BEx Query Designer


Answer : E


BEx suite is reporting environment in SAP BW and it doesn't contain Persistent Staging Area of SAP BW

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.