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 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 - In an Operational Data store, how many number of maximum keys an object can have?
Answer : B
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 source system you can connect to SAP BW?
Answer : D
Q 7 - In Process Chain Maintenance, which of the following collector is used to send atleast one predecessor process to an event?
Answer : B
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 in BEx suite is used to create BI queries?
Answer : A
Explanation
Query Designer in BEx suite is used to create BI queries and is user friendly tool.
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.
