- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 used for dividing table on row or column based and is used for report performance enhancement?
Answer : A
Explanation
Partioning is defined as dividing table based on available fields and it is easier to perform a search in smaller tables and hence reporting performance is enhanced.
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, which of the following transaction can be used to display tables in Star schema?
Answer : C
Q 6 - An attribute of an InfoObject which is displayed with InfoObject and can't be used on its own is known as?
Answer : B
Explanation
A display attribute is an attribute of an InfoObject that can be displayed together with InfoObject and cannot be used on its own.
Q 7 - In a Log view under process change management, a yellow mark shows that a process chain
Answer : C
Explanation
- Grey: Not Yet Run
- Green: Completed with no errors
- Yellow: Running
- Red: Failed
Q 8 - Which of the following defines the use of InfoSet?
Answer : A
Q 9 - Which of the following is component of Business Explorer suite?
Answer : E
Explanation
BEx suite is reporting environment in SAP BW and it doesn't contain Persistent Staging Area of SAP BW
Q 10 - Which of the following authorization object is used to protect RSA1?
Answer : B
Explanation
S_RS_ADMWB −
This authorization object is used to protect many administration tasks including RSA1 administration workbench.