- 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 - 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 - What do you understand by data integrity in database?
A - Eliminating incorrect data
B - Eliminating duplicate data
Answer : A
Explanation
Data integrity deals with removing duplicate data in database.
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 - 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, InfoObjects in dimension tables are called?
Answer : B
Explanation
InfoObjects in Dimension tables are called characteristics and InfoObject in fact tables are called key figures.
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 transfer method doesn't support hierarchy upload?
Answer : B
Explanation
In Persistent Staging area data transfer, there is restricted use of hierarchy upload.
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 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.
To Continue Learning Please Login