Home » [Free] Get all latest Microsoft 70-467 Actual Tests 131-140

[Free] Get all latest Microsoft 70-467 Actual Tests 131-140

Ensurepass

QUESTION 131

DRAG DROP

You are the database administrator of a SQL Server 2012 data warehouse implemented as a single database on a production server. The database is constantly updated by using SQL Server Integration Services (SSIS) packages and SQL Server Analysis Services (SSAS) cube writeback operations.

 

The database uses the full recovery model. A backup strategy has been implemented to minimize data loss in the event of hardware failure.

 

SQL Server Agent jobs have been configured to implement the following backup operations:

 

clip_image002A full database backup every day at 12:00 A.M.

clip_image002[1]Differential database backups every day at 6:00 A.M., 12:00 P.M., and 6:00 P.M.

clip_image002[2]Transaction log backups every hour on the hour.

 

At 2:38 P.M.a SSIS package corrupts the data in a fact table. The corruption cannot be undone. You are notified at 3:15 P.M.You immediately take the database offline to prevent further data access and modification.

 

You need to restore the data warehouse and minimize downtime and data loss.

 

Which four 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_image004

 

Correct Answer:

clip_image006

 

 

 

 

 

 

 

 

 

QUESTION 132

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading. The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility. You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Use a project deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.

B.

Use a package deployment model. Use the Integration Services Deployment Wizard.

C.

Use a package deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.

D.

Use a project deployment model. Use the Integration Services Deployment Wizard.

 

Correct Answer: C

 

 

QUESTION 133

HOTSPOT

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

 

You create an SSIS project to perform a daily refresh of the data warehouse and data models. The project has five packages.

 

You need to configure the project to ensure that the development, 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_image007

 

Correct Answer:

clip_image008

QUESTION 134

DRAG DROP

You are developing packages in a SQL Server Integration Services (SSIS) project to load a data warehouse.

 

You are designing a method for configuring the packages’ connections when deployed to a production SSIS catalog. All packages load data from two source databases.

 

Two packages also load data from a third source database. Another SSIS project will use the same connections.

 

You need to meet the requirements.

 

What should you do?

 

To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Each term may be used once, more than once, or not at all.)

 

clip_image010

 

Correct Answer:

clip_image012

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 135

DRAG DROP

A SQL Server Analysis Services (SSAS) cube named Sales includes a dimension named Date that defines a hierarchy named Calendar. The Calendar hierarchy consists of Year, Quarter, and Month levels. The Type properties of the Date dimension and its attributes are appropriately configured to mark the dimension as a time dimension.

 

You are creating a Multidimensional Expressions (MDX) query that will return sales for each month of 2011 and a three-month moving average of sales (labeled 3MMA), as shown in the following diagram.

 

clip_image014

 

You need to complete the MDX query.

 

Which set expression should you use?

 

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

 

clip_image016

 

Correct Answer:

clip_image018

QUESTION 136

HOTSPOT

You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Customer is based on the DimCustomer table. A subset of the data source view is shown in the following graphic.

 

clip_image019

 

You need to relate the Customer dimension to the AccountBalance measure group.

 

Which relationship type should you choose? To answer, select the appropriate option from the drop-down list in the dialog box.

 

clip_image020

Correct Answer:

clip_image021

 

 

QUESTION 137

The IT department is currently upgrading all SQL Server Integration Services (SSIS) packages to SSIS 2012. The final version of a complex SSIS 2005 package has been overwritten. Four prior versions of the package exist. Each of the prior versions contains a different part of the final solution. You have backups of all associated project files. You need to create an updated package as quickly and accurately as possible. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Use an XML editing tool to merge the compatible changes of the package versions by comparing the package refID fields. Upgrade the merged version.

B.

Upgrade the four package versions. Use an XML editing tool to merge the compatible changes of the package versions by comparing the package refID fields.

C.

Use the DataSet.Merge method to merge the compatible changes of the package versions by using the Lineage IDs. Upgrade the merged version.

D.

Upgrade the four package versions. Use SSIS Designer to visually compare the package versions, determine the compatible changes, and copy the compatible tasks into a single package.

 

Correct Answer: B

 

 

 

 

 

 

 

QUESTION 138

HOTSPOT

You administer a SQL Server Analysis Services (SSAS) cube.

 

You plan to optimize the cube partitions by using usage-based optimization.

 

You need to configure the SSAS instance.

 

Which properties should you configure?

 

To answer, select the appropriate properties in the dialog box in the answer area.

 

clip_image022

 

Correct Answer:

clip_image023

 

 

QUESTION 139

DRAG DROP

You administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are provisioned.

 

You need to monitor the number of report data feed processing events during every automated execution.

 

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_image025

 

Correct Answer:

clip_image027

 

 

QUESTION 140

DRAG DROP

A company has a data warehouse that is rapidly increasing in size.

 

You plan to improve query performance by partitioning a very large fact table.

 

You need to identify the columns that are good partitioning candidates and the range that each partition should include.

 

Which component should you add to the package?

 

To answer, drag the appropriate component from the list of items to the answer area.

 

clip_image029

 

Correct Answer:

clip_image031

 

Instant Access to Download Testing Software & PDF File for Microsoft 70-467 Real Exam

Instant Access to Try Microsoft 70-467 Free Demo

HOT EXAM!

Name of author

Name: admin