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 - When you create a dimension as line item dimension in an infocube, ID's and SID's are same in this case?

A - True

B - False

Answer : A


SID's of dimension are stored in fact tables and can be used as dimension id's.

Q 2 - Which of the following transactions can be used for maintaining data sources in BW?

A - RSA1

B - RSA3

C - RSA5

D - RSA6

Answer : D


RSA1 is used to open administration workbench.

RSA3 is used for checking data sources for extraction

RSA6 is used for mainting data sources

RSA5 is used for installing buisness content data sources

Q 3 - Which of the following uses J2EE connectivity to enable reporting on Relational and multidimensional data sources?

A - DB Connect

B - UD Connect

C - Both of the above

D - None of the above

Answer : B


UD connect uses application server J2EE connectivity to allow reporting on both SAP and non SAP data sources.

Q 4 - Which of the following can be used for reporting in SAP BW?

A - BEx Analyzer

B - Lumira


D - BEx query

Answer : A


BEx Analyzer is one of reporting environment in SAP BW and is integrated with MS Excel.

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


Useful Video Courses


SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas


SAP Webi Online Training

Most Popular

26 Lectures 2 hours

Neha Gupta


SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal


SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal


SAP MM Online Training

14 Lectures 1.5 hours

Neha Malik


SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik