Latest MCSE 70-463 Real Exam Download 31-40

Ensurepass

 

QUESTION 31

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 32

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 33

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 34

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 35

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 36

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 37

You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis. You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum. 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: J

 

QUESTION 38

You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. 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: A

 

QUESTION 39

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place. The methodology has the following requirements:

clip_image002The deployment process must be simplified.

clip_image002[1]clip_image002[2]clip_image002[3]All the logs must be centralized in SQL Server. Log data must be available via reports or T-SQL. Log archival must be automated.

 

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?

 

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

B. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.

C. Add an OnError event handler to the SSIS project.
D. Use an msi file to deploy the package on the server.

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

F. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

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

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

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

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

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

 

Correct Answer: J

 

QUESTION 40

To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package


clip_image002[4]logging methodology. The methodology has the following requirements: Centralized logging in SQL Server

clip_image002[5]Simple deployment

clip_image002[6]clip_image002[7]Availability of log information through reports or T-SQL Automatic purge of older log entries

clip_image002[8]Configurable log details

 

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?

 

A. Use the gacutil command.

B. Use the dtutil /copy command.

C. Use the Integration Services Deployment Wizard.
D. Create an OnError event handler.

E. Create a reusable custom logging component.

F. Run the package by using the dtexec /rep /conn command.

G. Run the package by using the dtexec /dumperror /conn command.

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

I.  Add a data tap on the output of a component in the package data flow.

J. Deploy the package by using an msi file.

K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

 

Correct Answer: H

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.