This section presents you various set of Mock Tests related to SAP BW. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.
Q 1 - Which statement(s) is true about Multiproviders?
To build MultiProvider, you have to use InfoCubes, info objects and info sets
Q 2 - To use special characters in BW, which of the following transaction can be used?
RSKC is used to enter special characters in BW.
Q 3 - In SAP BW, which of the following is incorrect about flat file upload?
To set flat file parameters, you can use transaction RSCUSTV7
Q 4 - When you create a dimension as line item dimension in an infocube, ID's and SID's are same in this case?
SID's of dimension are stored in fact tables and can be used as dimension id's.
Q 5 - Which of the following transaction can be used to adjust an infoset after making changes
RSISET transaction can be used to adjust changes in an infoset.
Q 6 - Which of the following transactions can be used for maintaining data sources in BW?
RSA1 is used to open administration workbench.
RSA3 is used for checking data sources for extraction
RSA6 is used for mainting data sources
RSA5 is used for installing buisness content data sources
Q 7 - What do you understand by data integrity in database?
Data integrity deals with removing duplicate data in database.
Q 8 - Which of the following component in BW architecture can be used for detailed storage of data and used for BEx reporting?
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 9 - Which of the following is/are incorrect about Infocubes?
InfoCubes doesn't contain a key.
InfoCubes contain star schema structure.
Infocube contains refined data and not detailed data.
An InfoCube can contain two or more operational data stores.
Q 10 - Which of the following is used for dividing table on row or column based and is used for report performance enhancement?
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 11 - In an Operational Data store, how many number of maximum keys an object can have?
Q 12 - When you upload the same data again in an Operational data store in overwrite mode, it creates new entries in change log.