Download New Updated (Spring 2015) Microsoft 70-460 Actual Tests 41-50

Ensurepass

 

QUESTION 41

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a tabular model. Which role permission should you use?

 

A.

Read Definition

B.

Read

C.

Process

D.

Select

E.

Browser

F.

Explorer

 

Correct Answer: B

 

 

QUESTION 42

You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table. You need to add the City column to the Customer table. How should you write the calculation?

 

clip_image002

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

F.

Option F

 

Correct Answer: A

 

 

QUESTION 43

HOTSPOT

You are developing a SQL Server Analysis Services (SSAS) cube.

 

You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)

 

clip_image003

 

You need to complete the MDX statement.

 

Which MDX function should you use in line 03?

 

To answer, select the appropriate MDX function in the functions list.

 

clip_image005

 

Correct Answer:

clip_image007

QUESTION 44

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) cube.

 

You need to add a calculated member to the Customer dimension to evaluate the sum of values for the United Kingdom and the United States.

 

Which expression should you use?

 

To answer, drag the appropriate expression to the answer area.

 

clip_image009

 

Correct Answer:

clip_image011

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 45

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:

 

clip_image013Data changes on a monthly basis.

clip_image013[1]The measure group contains a very high data volume.

clip_image013[2]Queries that use the measure group only reference aggregate data.

clip_image013[3]The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.

 

The Current Sales measure group has the following characteristics:

 

clip_image013[4]Data changes frequently.

clip_image013[5]The measure group contains a low data volume.

clip_image013[6]Queries that use the measure group often reference non-aggregate data.

clip_image013[7]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:

 

clip_image013[8]For the Sales History measure group, query performance must be optimized over data latency.

clip_image013[9]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.

 

clip_image015

 

Correct Answer:

clip_image017

 

 

QUESTION 46

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) cube.

 

You need to reuse a Revenue measure group from a different database.

 

In SQL Server Data Tools (SSDT), which three actions should you perform in sequence?

 

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

clip_image019

 

Correct Answer:

clip_image021

 

 

 

 

QUESTION 47

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.

 

The sales department requires the following set of metrics:

 

clip_image013[10]Unique count of customers

clip_image013[11]Unique count of products sold

clip_image013[12]Sum of sales

 

You need to ensure that the cube meets the requirements while optimizing query response time.

 

What should you do? (Each answer presents a complete solution. Choose all that apply.)

 

A.

Place the measures in a single measure group.

B.

Place the distinct count measures in separate measure groups.

C.

Use the additive measure group functions.

D.

Use the semiadditive measure group functions.

E.

Use the Count and Sum measure aggregation functions.

F.

Use the Distinct Count and Sum measure aggregation functions.

 

Correct Answer: BF

 

 

QUESTION 48

You create a materialized reference dimension between a dimension named Regions and a measure group named Orders.

 

You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

 

clip_image022

 

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.

 

What should you reprocess?

 

A.

The Regions dimension

B.

The Customers dimension

C.

The Sales partition

D.

The Orders partition

 

Correct Answer: B

 

 

QUESTION 49

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project file includes two cubes named Finance and Operations. The project also includes a dimension named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date dimension has been added to both cubes.

 

You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects.

 

Which three actions should you perform in sequence?

 

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

clip_image024

 

Correct Answer:

clip_image026

 

 

QUESTION 50

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.

 

clip_image027

clip_image028

 

Correct Answer:

clip_image029

 

Free VCE & PDF File for Microsoft 70-460 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…