This question has only one answer.
a. To avoid redundancy
b. To make it look good
c. To increase performance
d. To comply with the multidimensional data modeling
rules
e. None of the above
2. Hierarchy can be which of the following?
This question has more than one answer.
a. Time-dependent name
b. Version dependent
c. With intervals
d. Time-dependent structure
e. Used by multiple InfoCube
f. None of the above
3. If product price is a slowly changing dimension,
how do you model product price if you want to report the price at any point
in time?
This question has more than one answer.
a. As a time-dependent navigational attribute
b. As a time-dependent navigational attribute of material
c. As a time-independent navigational attribute of material
d. As a characteristic on the material dimension
e. As a time-dependent hierarchy of material
4. Name the three differences between OLAP and OLTP
systems?
This question has more than one answer.
a. Software used
b. Current data versus history required
c. One to two months of data versus two to seven years
of data
d. Detailed transaction data versus summarized data
e. None of the above
5. Sometimes we have to combine unrelated characteristics into one dimension, due to which of the following facts?
a. We run out of dimensions and we have to include the
data in the same InfoCube
b. We are running out of space on the database
c. We are looking for higher performance
d. Lower number of dimensions is a way to optimize data
staging
e. To reduce the number of joins
f. All of the above
6. Which of the following items refer to InfoObjects?
This question has more than one answer.
a. Characteristics
b. Key figures
c. Queries
d. Attributes
e. None of the above
7. What are the three predefined dimensions in SAP
BW?
This question has more than one answer.
a. Date
b. InfoPackage
c. Time
d. Unit
e. None of the above
8. What are the advantages of a smaller dimension?
This question has more than one answer.
a. Available immediately after transaction data load
b. Improves query performance
c. Overhead during load time
d. It is not an advantage but a liability
e. None of the above
9. What are the limitations of a Remote Cube?
This question has more than one answer.
a. Additional requirements for extractors
b. Slow
c. System dependent
d. Only for transaction data
e. Small volume
10. Which of the following are examples of characteristics?
This question has more than one answer.
a. Monthly sales
b. Products
c. Cost centers
d. Company codes
e. Sales person
11. A conceptual description of data objects, their attributes, and the relationships between them is:
a) A data warehouse
b) A data model
c) An InfoCatalog
d) An InfoSet
e) An InfoSource
12. Which of the following are types of SAP BW InfoCubes?
a) MultiCube
b) Inverted Cube
c) Remote Cube
d) Relational Cube
e) Basic Cube
---
Correct Answers:
1) a
2) b, c, d
3) b, e
4) b, c, d
5) a, e
6) a, b
7) b, c, d
8) a, b, c
9) a, b, d
10) b, c, d, e
11) b
12) a, c, and e
