- SAP BW Tutorial
- SAP BW - Home
- SAP BW - Overview of SAP BI
- SAP BW - Data Warehousing
- SAP BW - Data Flow
- SAP BW - Transformation
- SAP BW - InfoArea, Object & Catalog
- SAP BW - DataStore Objects & Types
- SAP BW - Write Optimized DSO
- SAP BW - Infoset
- SAP BW - InfoCube
- SAP BW - Virtual InfoProvider
- SAP BW - MultiProvider
- SAP BW - Flat File Data Transfer
- SAP BW - DB Connect
- SAP BW - Universal Data Connect
- SAP BW - Process Chain
- SAP BW - Reporting
- SAP BW Useful Resources
- SAP BW - Questions Answers
- SAP BW - Quick Guide
- SAP BW - Useful Resources
- SAP BW - Discussion
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 - When you create a dimension as line item dimension in an infocube, ID's and SID's are same in this case?
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 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 - DB connect relies on ABAP stack and Universal Data connector is based on Java stack?
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 - In SAP BW, which of the following is not an available option to perform data load from flat file?
Answer : B
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 following in BEx suite is used to create BI queries?
Answer : A
Explanation
Query Designer in BEx suite is used to create BI queries and is user friendly tool.
Q 10 - In order to execute query, which of the following authorization object access is mandate in BW?
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.
To Continue Learning Please Login