1.
In Smart View for Office - before you refresh a worksheet you activate the display option to suppress #Missing values. When you refresh your worksheet, Analytic Services returns:
2.
If a dimension is missing in your data source, what does Analytic Services do when you load the data?
3.
A calculation script
4.
Which member property ensures a member is always calculated on retrieval?
5.
During calculation script development, you follow the calculation test procedure below: 1. Clear data from the database 2. Load test input data 3. Run the calculation script 4. Audit calculation results What are the benefits of following this procedure? (Choose all that apply.)
6.
Which of the following characterizes the top member in an alternate hierarchy?
7.
Which options are available to manipulate fields in Data Prep Editor?
8.
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?
9.
What statistics are available in the Database Properties dialog box? (Choose all that apply.)
10.
Theoretically, if all database dimensions were configured sparse, what would the data block size be?