- 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 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 transactions can be used for maintaining data sources in BW?
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 - In SAP BW, table that consists of master data are kept in separate tables and this structure is known as
Answer : B
Explanation
When the table consists of master data are kept in separate tables, this structure is known as extended star schema.
Q 4 - Which of the following can be used for reporting in SAP BW?
Answer : A
Explanation
BEx Analyzer is one of reporting environment in SAP BW and is integrated with MS Excel.
Q 5 - Which of the following is used to connect to SAP BW using a BEx query?
Answer : A
Explanation
Business Intelligence Consumer Service BICS is used for connectivity to BI tools to connect to BEx queries on SAP BW system.
Q 6 - Which of the following source system you can connect to SAP BW?
Answer : D
Q 7 - Which of the following is incorrect about using MultiProvider in SAP BW?
A - Break Reporting scenarios into smaller unit
B - Smaller size dataset results faster read performance
Answer : C
Explanation
A query against a MultiProvider is divided into subqueries so more overhead of split queries and manage them.
Q 8 - Which of the following defines the use of InfoSet?
Answer : A
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 - Which of the following transaction is used in SAP BW to manage authorization objects?