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

Answer : C

Explanation

To set flat file parameters, you can use transaction RSCUSTV7

Answer : B

Explanation

InfoCubes doesn't contain a key.

InfoCubes contain star schema structure.

Infocube contains refined data and not detailed data.

An InfoCube can contain two or more operational data stores.

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

Explanation

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

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

Explanation

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

Explanation

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

C - BICS

D - BEx Query Designer

E - PSA

Answer : E

Explanation

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

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