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

Answer : B

Explanation

To build MultiProvider, you have to use InfoCubes, info objects and info sets

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 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 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 - An attribute of an InfoObject which is displayed with InfoObject and can't be used on its own is known as?

A - Navigation Attribute

B - Display Attribute

C - Detailed Attribute

D - Key Attribute

Answer : B

Explanation

A display attribute is an attribute of an InfoObject that can be displayed together with InfoObject and cannot be used on its own.

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 authorization object is used to protect RSA1?

A - S_RS_COMP

B - S_RS_ADMWB

C - S_RS_Query

D - None of these

Answer : B

Explanation

S_RS_ADMWB −

This authorization object is used to protect many administration tasks including RSA1 administration workbench.


sap_bw_questions_answers.htm

Advertisements