1.
Which of the following characterizes the top member in an alternate hierarchy?
2.
Which options are available to manipulate fields in Data Prep Editor?
3.
During a CALC ALL or CALC DIM process, Analytic Services calculates sparse and dense dimensions in a
specific sequence. What makes the default calculation sequence so efficient?
4.
What statistics are available in the Database Properties dialog box? (Choose all that apply.)
5.
Theoretically, if all database dimensions were configured sparse, what would the data block size be?
6.
What do data load rules files enable you to do?
7.
Which statement best describes data normalization?
8.
What type of calculations has all of the following characteristics?
- Calculate all or a portion of the database
- Control the order in which dimensions are calculated
- Driven by business processes
9.
What is the typical methodology for normalizing rates and drivers?
10.
Which statement is true about substitution variables?