Self-Test Questions With Answers For SAP BI

1. Which of the following statements refer to a Remote Cube?

a. InfoCube that gathers data from several Basic Cubes
b. Transaction data that are not managed in SAP BW but are available to SAP BW users
c. Remote Cubes do not contain data
d. A cube built in a non-BW data warehouse
e. None of the above
 

2. If product price is a slowly changing dimension, how do you model product price if you want to report on the price at the time of the query?

a. As a characteristic on the material dimension
b. As a time-dependent navigational attribute
c. As a time-dependent hierarchy of material
d. As a time-independent navigational attribute of material
e. None of the above
 

3. Which of the following refer to pointer tables that provide the technical link to the master data outside of the InfoCube?

a. Dimension tables
b. Set IDs
c. M tables
d. SID tables
e. ODS transparent tables
 

4. Which of the following Dimensions are delivered by SAP BW for each InfoCube?
This question has more than one answer.

a. Unit
b. Time
c. Transfer package
d. Currency unit
e. Info packet (Info package)
f. GIS
 

5. Which of the following statements describes a categorical dimension?
This question has only one answer.

a. An artificial dimension used to describe the status of another dimension
b. An artificial dimension/attribute used to categorize another dimension
c. An artificial dimension used in a reporting scenario where the comparison of the same key figure is needed
d. A dimension that is used across all cubes
e. None of the above
 

6. Which of the following is an example of a slowly changing dimension?
This question has only one answer.

a. Customer on a sales order
b. Date
c. Person responsible for a cost centre
d. Value of a purchase order
e. None of the above
 

7. Fact tables may be partitioned by which of the following characteristics?

a. 0CALDAY
b. 0CALMONTH
c. 0CALYEAR
d. 0CALPERIOD
e. 0CALWEEK
 

8. Which of the following statements is correct concerning the operational data store (ODS)?

a. The data in the ODS are compressed and do not have a Request ID attached
b. ODS can consolidate data from different source systems
c. Data in the ODS cannot be reported upon
d. The ODS is the inbound layer of the SAP BW system and data are written directly to it from the source system
e. The ODS generally holds transaction data only
 

9. A Fact table consists of which of the following elements?

a. Characteristic InfoObjects
b. Key figures InfoObjects
c. Calculated key figures InfoObjects
d. Hierarchies
e. DIM Ids
 

10. If you worked for a retail company that changed prices on a very frequent basis, how would you model the price?
This question has only one answer.

a. In the master data table as an attribute
b. In the transaction table as a new characteristic
c. In the ODS to enhance performance
d. In the fact table
e. None of the above

---

Correct Answers:

1) b, c

2) d

3) d

4) a, b, e

5) b

6) c

7) b

8) b, e

9) a, b

10) b

SAP BW Tips

Also read
SAP BW Mock Test

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.