- 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 - Which of the following component in BW architecture can be used for detailed storage of data and used for BEx reporting?
Answer : B
Explanation
In SAP BW architecture, ODS can be used for detailed storage of data and used for BEx reporting. It exists between PSA and InfoCubes.
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 - To save in progress query so that it is not accessible to other users. It should be saved as?
Answer : D
Explanation
You can store all the under development queries to Favorites to prevent them accessible to other users.
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 is a type of UD connect in SAP BW?
Answer : B
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 - Criteria for selecting PSA and IDOC methods transfer data depends on?
Answer : C
Q 9 - Which of the following is a valid transformation rule in BW?
Answer : C
Answer : B
Explanation
S_RS_HIER: is related to hierarchies.
To Continue Learning Please Login