QUESTION 81

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a solution that can join a single time dimension to both fact tables. What should you do?

 

A.     Join the two fact tables.

B.      Merge the fact tables.

C.      Create a time dimension that can join to both fact tables at their respective granularity.

D.     Create a surrogate key for the time dimension.

 

Correct Answer: C

 

 

 

 

 

 

QUESTION 82

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?

 

A.     Run the dbimpexp.exe command.

B.      Install the data providers that are used for data refresh.

C.      Run the DQSInstalIer.exe command.

D.     Install the Analysis Services OLE DB Provider.

 

Correct Answer: C

 

 

QUESTION 83

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?

 

A.     Run the Configuration component in the Data Quality Client.

B.      Install ADOMD.NET.

C.      Run the Data Quality Server Installer.

D.     Make the data available for DQS operations.

 

Correct Answer: C

 

 

QUESTION 84

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Team Type, does not yet have a domain. You need to complete the mapping of the Team Type column. What should you do?

 

A.     Add a column mapping for the Team Type column.

B.      Add a domain for the Team Type column.

C.      Map a composite domain to the source column.

D.     Create a composite domain that includes the Team Type column.

 

Correct Answer: B

 

 

 

 

 

QUESTION 85

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server. What should you do?

 

A.     Add an OnError event handler to the SSIS project.

B.      Use an msi file to deploy the package on the server.

C.      Open a command prompt and run the gacutil command.

D.     Open a command prompt and run the dtutil /copy command.

E.      Open a command prompt and run the dtexec /rep /conn command.

F.      Open a command prompt and run the dtexec /dumperror /conn command.

G.     Run the package by using the dtexecui.exe utility and the SQL Log provider.

H.     Create a reusable custom logging component and use it in the SSIS project.

I.       Configure the SSIS solution to use the Project Deployment Model.

J.       Configure the output of a component in the package data flow to use a data tap.

K.      Run the dtutil command to deploy the package to the SSIS catalog and store the

configuration in SQL Server.

 

Correct Answer: I

 

 

QUESTION 86

You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific data originating from a SQL Azure database, a custom task component is added to the project. You need to ensure that the custom component is deployed on a test environment correctly. What should you do?

 

A.     Add an OnError event handler to the SSIS project.

B.      Use an msi file to deploy the package on the server.

C.      Open a command prompt and run the gacutil command.

D.     Open a command prompt and run the dtutil /copy command.

E.      Open a command prompt and run the dtexec /rep /conn command.

F.      Open a command prompt and run the dtexec /dumperror /conn command.

G.     Run the package by using the dtexecui.exe utility and the SQL Log provider.

H.     Create a reusable custom logging component and use it in the SSIS project.

I.       Configure the SSIS solution to use the Project Deployment Model.

J.       Configure the output of a component in the package data flow to use a data tap.

K.      Run the dtutil command to deploy the package to the SSIS catalog and store the

configuration in SQL Server.

 

Correct Answer: C

 

 

QUESTION 87

You are developing a data flow transformation to merge two data sources. One source contains product data and the other source contains data about the country in which the product was manufactured. Both data sources contain a twocharacter CountryCode column and both use SQL Server. Both data sources contain an ORDER BY clause to sort the data by the CountryCode column in ascending order. You use a Merge Join transformation to join the data.

 

clip_image002

 

You need to ensure that the Merge Join transformation works correctly without additional transformations. What should you do? (Each answer presents a part of the solution. Choose all that apply.)

 

A.     Set the appropriate SortKeyPosition properties on the data sources.

B.      Set the ValidateExternalMetaData property on the Merge Join transformation to True.

C.      Set the IsSorted property on both data sources.

D.     Set the MaxBuffersPerlnput property on the Merge Join transformation to 2.

 

Correct Answer: AC

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 88

DRAG DROP

You are designing a package control flow. The package moves sales order data from a SQL Azure transactional database to an on-premise reporting database. The package will run several times a day, while new sales orders are being added to the transactional database. The current design of the package control flow is shown in the answer area.

 

clip_image004

 

The Insert New Orders Data Flow task must meet the following requirements:

 

Ÿ   Usage of the tempdb database should not be impacted.

Ÿ   Concurrency should be maximized, while only reading committed transactions.

Ÿ   If the task fails, only that task needs to be rolled back.

 

You need to configure the Insert New Orders Data Flow task to meet the requirements. How should you configure the transaction properties? (To answer, select the appropriate setting or settings in the answer area.)

 

Select and Place:

clip_image006

 

Correct Answer:

clip_image008

 

 

 

 

 

 

 

 

QUESTION 89

You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B. Both packages must reference a file path corresponding to an input folder where files will be located for further processing. You need to design a solution so that the file path can be easily configured with the least administrative and development effort. 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.

 

Build List and Reorder:

clip_image010

 

Correct Answer:

clip_image012

 

 

 

 

 

QUESTION 90

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_image014

 

Correct Answer:

clip_image016

 

 

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

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