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 - Which of the following transaction can be used to adjust an infoset after making changes

A - RSISET

B - RSKC

C - RRBS

D - none of the above

Answer : A

Explanation

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

Q 2 - Which of the following component in BW architecture can be used for detailed storage of data and used for BEx reporting?

A - PSA

B - Operational Data Store

C - InfoCubes

D - Infoarea

Answer : B

Explanation

In SAP BW architecture, ODS can be used for detailed storage of data and used for BEx reporting. It exists between PSA and InfoCubes.

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 - 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 is used to connect to SAP BW using a BEx query?

A - BICS

B - Relational

C - ODBC

D - JDBC

Answer : A

Explanation

Business Intelligence Consumer Service BICS is used for connectivity to BI tools to connect to BEx queries on SAP BW system.

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

Explanation

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

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 - Which of the following defines the use of InfoSet?

A - When a Join is required

B - When a Union is required

C - Both

D - None of the above

Answer : A

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 - In order to execute query, which of the following authorization object access is mandate in BW?

A - S_RS_COMP

B - S_RS_ADMWB

C - S_RS_Query

D - None of these

Answer : A

Explanation

S_RS_COMP: this object is very important for reporting and is used for authorization for using different components for query definition.

sap_bw_questions_answers.htm
Advertisements