Download New Updated (Spring 2015) Microsoft 70-460 Actual Tests 51-60

Ensurepass

 

QUESTION 51

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis. What should you do before the partition can be write-enabled?

 

A.

Ensure that the measure group measures only use semiadditive aggregation functions.

B.

Implement the cube as a local cube.

C.

Ensure that the measure group measures only use nonadditive aggregation functions

D.

Implement the linked measure group as a local measure group.

 

Correct Answer: D

QUESTION 52

HOTSPOT

You are designing a dimension named Employee for a SQL Server Analysis Services multidimensional project.

 

The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.

 

You need to minimize the amount of time required to process the cube.

 

What should you do?

 

To answer, select the appropriate relationship type for each attribute in the answer area.

 

clip_image004

 

Correct Answer:

clip_image005

 

 

 

 

 

QUESTION 53

DRAG DROP

You have a business intelligence (BI) infrastructure.

 

You create a SQL Server Integration Services (SSIS) project that contains the packages for the BI infrastructure.

 

You need to automate the deployment of the SSIS project. The solution must ensure that the deployment can occur as part of an unattended Transact-SQL script.

 

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_image007

 

Correct Answer:

clip_image009

 

 

QUESTION 54

The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately.

 

The Marketing department requests a delimited text file that includes seven fields containing product information from the Products table. You have the following requirements:

 

clip_image011Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.

clip_image011[1]Sort rows in ProductID order.

clip_image011[2]Aggregate product units sold.

clip_image011[3]Minimize the time required to return the results.

 

You create a SQL Server Integration Services (SSIS) package and add the appropriate connection managers and a Data Flow task.

 

You need to develop the Data Flow task.

 

What should you add to the Data Flow task? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

A table-based OLE DB source; a Script component and a Flat File destination.

B.

Only a SQL command-based OLE DB source and a Flat File destination.

C.

A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.

D.

A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.

 

Correct Answer: D

 

 

QUESTION 55

HOTSPOT

A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.

 

You create an SSIS project to perform a weekly refresh of the company’s data warehouse and cubes. The project has three packages.

 

You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.

 

Which program should you use?

 

To answer, select the appropriate program in the answer area.

 

clip_image012

 

Correct Answer:

clip_image013

 

 

 

 

 

 

 

 

 

 

QUESTION 56

You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog. You are preparing a disaster recovery plan for a business intelligence (BI) solution. You need to ensure that the SSIS catalog from Server1 can be restored to Server2. Which two actions should you perform on Server1? Each correct answer presents part of the solution.

 

A.

Back up the master database.

B.

Run sp.configure ‘clr enabled’, 0.

C.

Back up the master key of the SSISDB database.

D.

Back up the master key of the master database.

E.

Back up the SSISDB database.

F.

Run sp_configure ‘clr enabled’, 1.

 

Correct Answer: CE

 

 

QUESTION 57

HOTSPOT

A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option.

 

You have the following requirements to reduce the cube processing time:

 

clip_image011[4]Partition the measure group by month.

clip_image011[5]Create a staging table that contains only data which is more recent than the last time the cube was processed.

clip_image011[6]Do not include data updates or deletions in the staging table.

clip_image011[7]Insert records from the staging table into the appropriate partition.

 

You need to change the process option to meet the requirements.

 

Which process option should you choose?

 

To answer, select the appropriate option from the drop-down list in the dialog box.

 

clip_image015

 

Correct Answer:

clip_image017

 

 

QUESTION 58

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:

 

clip_image011[8]Users must be able to retrieve aggregate data from partition1 as quickly as possible.

clip_image011[9]The processing time for partition1 and partition2 must be minimized.

clip_image011[10]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.

 

clip_image018

 

Correct Answer:

clip_image019

 

 

QUESTION 59

You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.

 

You have the following requirements:

 

clip_image011[11]Allow users to slice data by all flags and indicators.

clip_image011[12]Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table.

clip_image011[13]Use the most efficient design strategy for cube processing and queries.

 

You need to modify the schema.

 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.

B.

Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.

C.

Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.

D.

Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.

 

Correct Answer: A

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 60

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer. You need to calculate the Projected Revenue as efficiently as possible. Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

clip_image021

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: C

 

 

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…