Online Access Free 70-460 Practice Test

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.Child Group
• B.Parent Group
• C.Adjacent Above
• D.Adjacent Below

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.

Correct Answer:

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 designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?

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

You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Set the AttributeHierarchyEnabled property to False.
• B.Set the Usage property to Parent.
• C.Set the IsAggregatable property to False.
• D.Set the AttributeHierarchyVisible property to False.
• E.Set the RootMemberIf property to ParentIsMissing.
• F.set the DefaultMember property to the Forecast member.

HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
- Users must be able to retrieve aggregate data from partition1 as quickly as
possible.
- The processing time for partition1 and partition2 must be minimized.
- The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.

Correct Answer: