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 - DB connect relies on ABAP stack and Universal Data connector is based on Java stack?

A - True

B - False

Answer : A

Explanation

Both UD connect and DB connect are used for connection to any database system which is able to provide data for BI system. DB Connect relies on ABAP Stack of WAS and UD Connect is built on JAVA Stack of WAS.

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 - In SAP BW, which of the following transaction can be used to display tables in Star schema?

A - DISPLAYSCHEMA

B - VIEWSCHEMA

C - LISTSCHEMA

D - All of the above

Answer : C

Q 6 - Which of the following is a type of UD connect in SAP BW?

A - HTML5

B - XMLA

C - Angular.js

D - None of these

Answer : B

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 - 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 - Virtual Providers only allow read access to data in source system?

A - True

B - False

Answer : A

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