Here are some sample 70-767 exam questions. 70-767 dumps is really great to pass exam. It contains 70-767 practice test braindumps Q&A.

An effective 70-767 exam questions preparation and grip over the entire course contents are definitely required to pass out your Microsoft Certification exam. 70-767 dumps here are reliable, comprehensive and up to the standards having 70-767 exam questions verified by Professional Experts. Our 70-767 dumps compose of 70-767 exam questions and 70-767 practice test, come in two formats i.e. in PDF file format and Online practice test software.

By using this online test engine mode you can practice 70-767 questions answers easily for the actual Microsoft 70-767 exam. You can download and try the free 70-767 dumps demo before buying exam 70-767 PDF file from Testmayor. Our excellent 70-767 exam questions dumps is a guarantee to your success in Microsoft certification exam.

Get 70-767 exam questions dumps and pass exam in first attempt.


70-767 | You are troubleshooting an existing SQL Server…

Question: 2

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.

Answer: A

70-767 | You are implementing a SQL Server Integration…

Question: 1

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.

Answer: J