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 - 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 - When you upload the same data again in an Operational data store in overwrite mode, it creates new entries in change log.

A - True

B - False

Answer : B

Q 4 - Which of the following can be used for reporting in SAP BW?

A - BEx Analyzer

B - Lumira

C - BICS

D - BEx query

Answer : A

Explanation

BEx Analyzer is one of reporting environment in SAP BW and is integrated with MS Excel.

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 - In a Log view under process change management, a yellow mark shows that a process chain

A - Not Yet Run

B - Completed with no errors

C - Running

D - Failed

Answer : C

Explanation

  • Grey: Not Yet Run
  • Green: Completed with no errors
  • Yellow: Running
  • Red: Failed

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