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 transactions can be used for maintaining data sources in BW?

A - RSA1

B - RSA3

C - RSA5

D - RSA6

Answer : D

Explanation

RSA1 is used to open administration workbench.

RSA3 is used for checking data sources for extraction

RSA6 is used for mainting data sources

RSA5 is used for installing buisness content data sources

Q 3 - Which of the following uses J2EE connectivity to enable reporting on Relational and multidimensional data sources?

A - DB Connect

B - UD Connect

C - Both of the above

D - None of the above

Answer : B

Explanation

UD connect uses application server J2EE connectivity to allow reporting on both SAP and non SAP data sources.

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 - 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 - A Virtual Provider can be created to read the data from an external SAP system or from an external non SAP system?

A - True

B - False

Answer : A

Explanation

You can perform reporting on external SAP or non SAP data source using Virtual provider without storing data physically.

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 is a valid transformation rule in BW?

A - Count

B - Extract

C - routine

D - Overwrite

Answer : C

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
E-Books Store