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 - Which of the following transaction can be used to adjust an infoset after making changes

A - RSISET

B - RSKC

C - RRBS

D - none of the above

Answer : A

Explanation

RSISET transaction can be used to adjust changes in an infoset.

Answer : B

Explanation

InfoCubes doesn't contain a key.

InfoCubes contain star schema structure.

Infocube contains refined data and not detailed data.

An InfoCube can contain two or more operational data stores.

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