SAP BW Online Quiz


Advertisements


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

Explanation

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

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

Explanation

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 - DB connect relies on ABAP stack and Universal Data connector is based on Java stack?

A - True

B - False

Answer : A

Explanation

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

A - New

B - Active

C - Change

D - Update

Answer : D

Explanation

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

Explanation

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

Q 6 - In SAP BW system, we perform ETL process to load the data to Persistent Storage area. Which of the following is true?

A - Transformation are used for data load

B - DTP is used for data load to PSA

C - DB connect is used to load the data to PSA

D - InfoPackage are used for data load to PSA

Answer : D

Explanation

To perform data load to persistence storage area, InfoPackage are used.

Q 7 - In Process Chain Maintenance, which of the following collector is used to send atleast one predecessor process to an event?

A - AND

B - OR

C - EXOR

D - None of the above

Answer : B

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

Explanation

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 - An authorization object S_RS_HIER is used for creating InfoCubes?

A - True

B - False

Answer : B

Explanation

S_RS_HIER: is related to hierarchies.


sap_bw_questions_answers.htm

Advertisements