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.
Q 1 - In SAP BW, which of the following is incorrect about flat file upload?
A - Table to store flat file upload parameters is RSADMINC
C - To set parameters for flat file load, use transaction RSCUSTV7
Answer : C
Explanation
To set flat file parameters, you can use transaction RSCUSTV7
Q 2 - Which of the following is/are incorrect about Infocubes?
A - InfoCubes doesn't contain a key.
B - InfoCubes contain flat file structure & An Infocube normally contains detailed level data..
C - An Infocube can contain data from two or more Operational data stores.
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 - Which of the following uses J2EE connectivity to enable reporting on Relational and multidimensional data sources?
Answer : B
Explanation
UD connect uses application server J2EE connectivity to allow reporting on both SAP and non SAP data sources.
Q 4 - Which of the following is not a valid object in Operational data store?
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 - In SAP BW, which of the following transaction can be used to display tables in Star schema?
Answer : C
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
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 - A company wants to set up BI reporting on Sales data from source system without extraction. Which of the following SAP BW feature support this?
Answer : C
Explanation
You can access BI data from source system without extraction using Virtual Providers.
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
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.
