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. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• B. Use role playing dimensions.
• 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 calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• E. Create several dimensions. Add each dimension to the cube.
• F. Use the Business Intelligence Wizard to define dimension intelligence.
• G. 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.
• H. Create a dimension. Then add a cube dimension and link it several times to the measure group.
• I. 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.
• J. Add a measure that uses the Count aggregate function to an existing measure group.
• K. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• L. 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.
• M. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• N. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• O. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

You are deploying the Research model.
You need to ensure that the data contained in the model can be refreshed.
What should you do?

• A. Create a SQL Server Integration Services (SSIS) package that imports data from MarketResearch.xIsx nightly. Load the data to CUBE1,
• B. Import MarketResearch.xIsx to a new tabular database on the Tabular instance.
• C. Upload MarketResearch.xIsx to Library1.
• D. Assign the Tabular instance service account permissions to the MarketResearch.xlsx network location.

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. In the Properties window for the applicable tables and columns, set the Visible property to True
• C. Right-click the applicable tables and columns and select the Hide from Client Tools option.
• D. Right-click the applicable tables and columns and select the Hide option.

You need to ensure that all reports meet the reporting requirements.
What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

• A. Create a report. Copy the report to source code control. Create each new report by using the report template in source code control.
• B. Create a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.
• C. Create a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
• D. Create a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report

Explanation: Only visible for PassLeaderVCE members. You can sign-up / login (it's free).

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange rates. One of the measures in this group is named Average Rate and it will be used to report the average currency exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.
Which value should you select for the AggregationFunction property for the Average Rate measure? To answer, select the appropriate setting in the answer area.