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 of the following uses J2EE connectivity to enable reporting on Relational and multidimensional data sources?
UD connect uses application server J2EE connectivity to allow reporting on both SAP and non SAP data sources.
Q 2 - DB connect relies on ABAP stack and Universal Data connector is based on Java stack?
Both UD connect and DB connect are used for connection to any database system which is able to provide data for BI system. DB Connect relies on ABAP Stack of WAS and UD Connect is built on JAVA Stack of WAS.
Q 3 - In SAP BW, table that consists of master data are kept in separate tables and this structure is known as
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?
RSPC1: Display Process Chain
RSPCM: Monitoring Daily Process Chains
RSPC: Process Chain Maintenance
RZ20: Log for Process Chains
Q 5 - In SAP BW, which of the following is not an available option to perform data load from flat file?
Q 6 - Which of the following can be used for reporting in SAP BW?
BEx Analyzer is one of reporting environment in SAP BW and is integrated with MS Excel.
Q 7 - To save in progress query so that it is not accessible to other users. It should be saved as?
You can store all the under development queries to Favorites to prevent them accessible to other users.
Q 8 - Which of the following is not a valid object in Operational data store?
When new data comes in ODS, it gets store in New table. When it is activated it is written in Active tables and all changes has been recorded to change log.
Q 9 - Which of the following represent key figures in SAP BW?
Key figures represent the measurable values on which you perform the analysis.
Q 10 - Which of the following are part of Dimension tables in BW?
Dimension tables in SAP BW contains SID and pointers to fact table.
Q 11 - Which of the following is used to connect to SAP BW using a BEx query?
Business Intelligence Consumer Service BICS is used for connectivity to BI tools to connect to BEx queries on SAP BW system.
Q 12 - In SAP BW, InfoObjects in dimension tables are called?
InfoObjects in Dimension tables are called characteristics and InfoObject in fact tables are called key figures.
|Question Number||Answer Key|