- 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 - Which statement(s) is true about Multiproviders?
A - Virtual Infoprovider in SAP BW stores the data.
B - Multiprovider consists of InfoCubes, info objects and info sets
C - More than one info provider is required to build a Multiprovider
Answer : B
Explanation
To build MultiProvider, you have to use InfoCubes, info objects and info sets
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 - 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 transaction code can be used for monitoring daily process chains?
Answer : B
Explanation
RSPC1: Display Process Chain
RSPCM: Monitoring Daily Process Chains
RSPC: Process Chain Maintenance
RZ20: Log for Process Chains
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 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 - 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 is a valid transformation rule in BW?
Answer : C
Answer : B
Explanation
S_RS_HIER: is related to hierarchies.