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

D - none of the above

Answer : A

Explanation

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

Q 2 - What do you understand by data integrity in database?

A - Eliminating incorrect data

B - Eliminating duplicate data

C - Eliminating errors in data transformation

D - All of the above

Answer : A

Explanation

Data integrity deals with removing duplicate data in database.

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

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?

C - New Status for changed records

D - Additive Delta

Answer : B

Q 5 - In SAP BW, InfoObjects in dimension tables are called?

A - Key Figures

B - Characteristics

Answer : B

Explanation

InfoObjects in Dimension tables are called characteristics and InfoObject in fact tables are called key figures.

Q 6 - In SAP BW system, we perform ETL process to load the data to Persistent Storage area. Which of the following is true?

A - Transformation are used for data load

B - DTP is used for data load to PSA

C - DB connect is used to load the data to PSA

D - InfoPackage are used for data load to PSA

Answer : D

Explanation

To perform data load to persistence storage area, InfoPackage are used.

Q 7 - A Virtual Provider can be created to read the data from an external SAP system or from an external non SAP system?

Answer : A

Explanation

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

Q 8 - Criteria for selecting PSA and IDOC methods transfer data depends on?

A - Load Performance

B - Query Performance

C - Volume of Data

D - Frequency of Data

Answer : C

Q 9 - Which of the Virtual provider is recommended when you need upto date and small amount of data from time to time and only few users query on data simultaneously?

A - VirtualProvider based on BAPI's

B - VirtualProvider with function modules

C - Virtual Providers with DTP

D - All of the above

Answer : C

Explanation

Virtual Providers with DTP is recommended for −

Up to date data from SAP system

Small amount of data is accessed from time to time

Few user execute queries simultaneously

Q 10 - Which of the following class contains majority of authorization objects in BI?

Answer : C

Explanation

Authorization objects are grouped according to authorization object classes and majority of objects are in class RS in BI.

sap_bw_questions_answers.htm

Previous Page Print Page

Advertisements