You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS).
How should you configure the backup options?

• A. Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password.
• B. Clear the Apply compression check box. Clear the Encrypt backup file check box.
• C. Select the Apply compression check box. Clear the Encrypt backup file check box.
• D. Select the Apply compression check box. Select the Encrypt backup file check box and supply a password.

HOTSPOT
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:
----
Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
----
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the following requirements:
- For the Sales History measure group, query performance must be optimized over data latency.
- For the Current Sales measure group, data latency must be optimized over query performance.
What should you do? To answer, select the appropriate storage mode for each measure group in the answer area.

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.

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) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

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

You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A. Restart the US service.
• B. Register a service principal name for the Analysis Services service.
• C. Configure SSRS01 to use the Custom authentication type.
• D. Register a service principal name for the Report Server service.
• E. Configure SSRS01 to use the Negotiate authentication type.