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
