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.

Q 2 - Which of the following component in BW architecture can be used for detailed storage of data and used for BEx reporting?

A - PSA

B - Operational Data Store

C - InfoCubes

D - Infoarea

Answer : B

Explanation

In SAP BW architecture, ODS can be used for detailed storage of data and used for BEx reporting. It exists between PSA and InfoCubes.

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 - 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 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 - Which of the following source system you can connect to SAP BW?

A - Printers

B - Video Conferencing based on VOIP

C - Fax machines

D - Source systems based on XML

Answer : D

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 transfer method doesn't support hierarchy upload?

A - IDoc

B - PSA

C - Full Load

D - All of the above

Answer : B

Explanation

In Persistent Staging area data transfer, there is restricted use of hierarchy upload.

Q 9 - Which of the following is component of Business Explorer suite?

A - Web Analyzer

B - Report Designer

C - BICS

D - BEx Query Designer

E - PSA

Answer : E

Explanation

BEx suite is reporting environment in SAP BW and it doesn't contain Persistent Staging Area of SAP BW

Q 10 - In order to execute query, which of the following authorization object access is mandate in BW?

A - S_RS_COMP

B - S_RS_ADMWB

C - S_RS_Query

D - None of these

Answer : A

Explanation

S_RS_COMP: this object is very important for reporting and is used for authorization for using different components for query definition.

sap_bw_questions_answers.htm
Advertisements