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 is used for dividing table on row or column based and is used for report performance enhancement?

A - Partitioning

B - Reconstruction

C - Indexing

D - Roll up

Answer : A

Explanation

Partioning is defined as dividing table based on available fields and it is easier to perform a search in smaller tables and hence reporting performance is enhanced.

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 - 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 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 - 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 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 - Which of the following transaction is used in SAP BW to manage authorization objects?

A - SU12

B - SU21

C - SM59

D - SM56

Answer : B

sap_bw_questions_answers.htm
Advertisements