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 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 - Which of the following are part of Dimension tables in BW?
Answer : B
Explanation
Dimension tables in SAP BW contains SID and pointers to fact table.
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 - A company wants to set up BI reporting on Sales data from source system without extraction. Which of the following SAP BW feature support this?
Answer : C
Explanation
You can access BI data from source system without extraction using Virtual Providers.
Answer : A
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.