- 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 - To use special characters in BW, which of the following transaction can be used?
Answer : C
Explanation
RSKC is used to enter special characters in BW.
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 - Which of the following uses J2EE connectivity to enable reporting on Relational and multidimensional data sources?
Answer : B
Explanation
UD connect uses application server J2EE connectivity to allow reporting on both SAP and non SAP data sources.
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 - In SAP BW, which of the following transaction can be used to display tables in Star schema?
Answer : C
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
Q 10 - In order to execute query, which of the following authorization object access is mandate in BW?
Answer : A
Explanation
S_RS_COMP: this object is very important for reporting and is used for authorization for using different components for query definition.