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 - To use special characters in BW, which of the following transaction can be used?

A - RSA1

B - RSA15

C - RSKC

D - RRBS

Answer : C

Explanation

RSKC is used to enter special characters in BW.

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

Explanation

Query Designer in BEx suite is used to create BI queries and is user friendly tool.

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