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 - When you create a dimension as line item dimension in an infocube, ID's and SID's are same in this case?

A - True

B - False

Answer : A

Explanation

SID's of dimension are stored in fact tables and can be used as dimension id's.

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 - In SAP BW, which of the following is not an available option to perform data load from flat file?

A - Full Load

B - Half Load

C - New Status for changed records

D - Additive Delta

Answer : B

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 - 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 - Which of the following is not a view type while managing process chains in BW system?

A - Planning View

B - Checking View

C - Log View

D - Status View

Answer : D

Explanation

There are three main views in icon bar while managing process chains −

  • Planning View
  • Checking View
  • Log View

Q 8 - Which of the following is used to perform preliminary calculations and is used to store these in global data structure in a table?

A - Start Routine

B - End routine

C - Expert Routine

D - None of the above

Answer : A

Q 9 - Virtual Providers only allow read access to data in source system?

A - True

B - False

Answer : A

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