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

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 transactions can be used for maintaining data sources in BW?

A - RSA1

B - RSA3

C - RSA5

D - RSA6

Answer : D

Explanation

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

Explanation

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

Q 4 - To save in progress query so that it is not accessible to other users. It should be saved as?

A - Public

B - Network Drive

C - Local System

D - Favorites

Answer : D

Explanation

You can store all the under development queries to Favorites to prevent them accessible to other users.

Q 5 - Which of the following are part of Dimension tables in BW?

A - Pointers to text values

B - SID's & Pointers to Fact table

C - Transfer Rules

D - None

Answer : B

Explanation

Dimension tables in SAP BW contains SID and pointers to fact table.

Q 6 - An attribute of an InfoObject which is displayed with InfoObject and can't be used on its own is known as?

A - Navigation Attribute

B - Display Attribute

C - Detailed Attribute

D - Key Attribute

Answer : B

Explanation

A display attribute is an attribute of an InfoObject that can be displayed together with InfoObject and cannot be used on its own.

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 is used to perform preliminary calculations and is used to store these in global data structure in a table?

A - Start Routine

B - End routine

C - Expert Routine

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 - Which of the following authorization object is used to protect RSA1?

A - S_RS_COMP

B - S_RS_ADMWB

C - S_RS_Query

D - None of these

Answer : B

Explanation

S_RS_ADMWB −

This authorization object is used to protect many administration tasks including RSA1 administration workbench.

sap_bw_questions_answers.htm
Advertisements