This question has more than one answer.
a. The grain of the fact table represents
actual working documents like order number or invoice number
b. All descriptive attributes of
the grain are located in other dimensions
c. The InfoCube becomes very weak
and performs poorly when it is run
d. The degenerating dimensions
cannot be modeled using normal star schema
e. None of the above
2. What values can a key figure
retain?
This question has only one answer.
a. Last value
b. Average value
c. First value
d. Sum
e. All of the above
f. None of the above
3. Which of the following describes
an unbalanced hierarchy?
This question has only one answer.
a. A hierarchy with too many leaves
within one branch
b. A hierarchy with fewer nodes
within one or more branches
c. Hierarchy without leaves
d. The term used for data that
are delivered from two or more sources on different aggregation
levels
f. None of the above
4. How many hierarchies can be
created for a key figure?
This question has only one answer.
a. 10
b. 2
c. 5
d. More than 1
e. None
5. Which of the following represents
a characteristic that spans an entire data model and upon which all other
entities are dependent?
This question has only one answer.
a. Many-to-many relationship
b. A degenerated characteristic
c. A strong entity
d. An attribute
e. A data model characteristic
6. Navigational attributes behave
in a query like which of the following?
This question has only one answer.
a. Attributes
b. Variables
c. Characteristics
d. Filters
e. None of the above
7. When should an attribute be
placed in a separate dimension?
This question has only one answer.
a. Always
b. If the attribute changes frequently
c. If the attributes have a large
number of distinct values
d. Never
e. None of the above
8. Which of the following objects
is not provided in business content?
This question has only one answer.
a. InfoCube
b. InfoSource
c. KPIs
d. Queries
e. SAP R/3 extractor program
f. None of the above
9. Which of the following objects
keeps the aggregate and InfoCube in sync?
This question has only one answer.
a. Dim pointer
b. Read pointer
c. SID pointers
d. Surrogate pointer
e. None of the above
f. All of the above
10. A MultiCube joins numerous
other InfoCubes via which of the following?
This question has only one answer.
a. A common set of characteristics
b. A common set of key figures
c. A common set of InfoSources
d. A common set of DataSource
e. None of the above
---
Correct Answers:
1) a, b, c
2) e
3) b
4) e
5) e
6) c
7) b
8) f
9) b
10) a
