Latest MCSE 70-463 Real Exam Download 81-90

Ensurepass

 

QUESTION 81

 

You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You have the following requirements:

 

• Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.

• Ensure that users can generate the exception report in an XML format.

• Use the minimum development effort.

You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A. Use a Data Profiling task. Use a Data Flow task to extract the XML output of the Data Profiling task into a SQL Server table. Query the table to view the exceptions.

B. Use Data Flow tasks to process the clean data.

C. Use a Data Profiling task. Read the exceptions in Data Profile Viewer.

D. Design a stored procedure that examines data for common dirty data patterns. Use an Execute SQL

task.


Correct Answer: C

 

QUESTION 82

 

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. You have the following requirements:

• The deployment model must support changing the content of connection strings by using parameters at execution time.

• The deployment model must automatically log events to the SSISOB database.

• Maximize performance at execution time.

You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A. Use a project deployment model. Modify connection manager properties to use project parameters.

B. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.

C. Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.

D. Use a project deployment model. Modify connection manager properties to use package parameters.

 

Correct Answer: A

 

QUESTION 83

 

You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours. Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the

month level. You need to partition the table to maximize the performance of queries. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A. Partition the fact table by month, and compress each partition.
B. Partition the fact table by week.

C. Partition the fact table by year.

D. Partition the fact table by day, and compress each partition.

 

Correct Answer: D

 

QUESTION 84

A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data feed. The package is executed several times a day, either as part of other packages’ control flow or by

itself. The external data feed is unreliable because network failures and slow response times are frequent. The package is currently deployed on the file system. To analyze the reliability of the external data feed, you must collect execution data. Every time the DataFeed package is executed, the following information must be logged:

• Start Time

• End Time

• Execution Result

• Execution Duration

You need to design a logging solution that meets the requirements by using the least amount of administrative and development effort. 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.)

 

Build List and Reorder:


 

clip_image001

 

Correct Answer:

clip_image002

 

 

QUESTION 85

You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing. Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:

• Valid addresses

• Autocorrected addresses

• Invalid addresses

You need to enhance the SSIS packages to perform address validation by using an external service. Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.)

 

 

Select and Place:


 

clip_image003

 

Correct Answer:

clip_image004

 

 

QUESTION 86

You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:

• Include multiple properties in a configuration.

• Support several packages with different configuration settings.

You need to select the appropriate configuration. Which configuration type should you use? To answer, select the appropriate option from the drop-down list in the dialog box.

 

Hot Area:


 

clip_image005

 

Correct Answer:

clip_image006

 

 

QUESTION 87

You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:

• Include multiple properties in a configuration.

• Force packages to load all settings in the configuration.

• Support Encrypting File System (EFS) formats.

You need to select the appropriate configuration. Which configuration type should you use? To answer, select the appropriate option from the drop-down list in the dialog box.

 

Hot Area:


 

clip_image005[1]

 

Correct Answer:

clip_image007

 

 

QUESTION 88

You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project. The first package that you create in this project contains a package connection that accesses a flat file. Additional packages in the project must also access this file. You need to define and reuse the flat file connection in all project packages. What should you do?

 

A. Convert the package Connection Manager in the first package to a project Connection Manager.
B. Copy the package Connection Manager and paste it into the second package.

C. Convert the project to the Package Deployment model.

D. Set the ProtectionLevel property of the package Connection Manager to DontSaveSensitive to reuse the flat file connection.

 

Correct Answer: A

 

QUESTION 89

You are installing the Data Quality Client on user desktops. You need to ensure that the prerequisite software components are installed. Which components must be present to meet this goal? (Each correct answer presents part of the solution. Choose all that apply.)

 

A. SQL Server Management Studio
B. Internet Explorer 6.0 SP1 or later
C. Microsoft Silverlight 5


D. .NET Framework 3.5 SP1

E. .NET Framework 4.0

F. Microsoft Silverlight 4

G. SQL Server Data Tools

 

Correct Answer: BE

 

QUESTION 90

You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the product data that is available in the MDS repository. You need to design a solution that gives the application access to the product data with the least amount of development effort. What should you do?

 

A. Create a Subscription View in MDS.

B. Access the product entity tables in the MDS database directly.

C. Use SQL Server Integration Services (SSIS) to extract the data and put it in a staging database.
D. Use change data capture on the product entity tables.

 

Correct Answer: A

Download Latest 70-463 Real Free Tests , help you to pass exam 100%.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.