Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
Dates
Delivery dates
Ship dates
---
You need to implement the minimum number of required SSAS objects.
What should you do?

• A. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• B. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• C. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• D. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• E. Use role playing dimensions.
• F. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• G. Add a measure that uses the Count aggregate function to an existing measure group.
• H. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• I. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• J. Use the Business Intelligence Wizard to define dimension intelligence.
• K. Create a dimension. Then add a cube dimension and link it several times to the measure group.
• L. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• M. Create several dimensions. Add each dimension to the cube.
• N. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• O. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of taps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
- A measure named Measure1 that must contain the average time duration of the laps run by each runner. - A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.

You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Country field on the rows and a grouping of the Year field on the columns.
You need to add the categories on the rows of the matrix.
Which Row Group option should you select when you add the group?

• A. Parent Group
• B. Child Group
• C. Adjacent Below
• D. Adjacent Above

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

• A. In the Properties window for the applicable tables and columns, set the Enabled property to False
• B. Right-click the applicable tables and columns and select the Hide option.
• C. In the Properties window for the applicable tables and columns, set the Visible property to True
• D. Right-click the applicable tables and columns and select the Hide from Client Tools option.

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Windows Azure SQL Database database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)

You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?

• A. Map gallery
• B. SQL Server spatial query
• C. Bing Maps layer
• D. ESRI shape file