[Free] 2017(Sep) EnsurePass Dumpsleader Microsoft 70-767 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2017 Sep Microsoft Official New Released 70-767
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/70-767.html

Implementing a Data Warehouse using SQL

Question No: 31 – (Topic 1)

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.

Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.

You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.

What should you do?

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

  2. Deploy the package by using an msi file.

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

  4. uses the dtutil /copy command.

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

  6. Create an OnError event handler.

  7. uses the Project Deployment Wizard.

  8. Use the gacutil command.

  9. Create a reusable custom logging component.

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

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

Answer: A

Reference:

http://www.rafael-salas.com/2016/01/ssis-2016-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/hh230989.aspx http://msdn.microsoft.com/en-us/library/jj655339.aspx

Question No: 32 – (Topic 1)

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 Group, does not yet have a domain.

You need to complete the mapping of the Group column. What should you do?

  1. Map a composite domain to the source column.

  2. Create a composite domain that includes the Group column.

  3. Add a domain for the Group column.

  4. Add a column mapping for the Group column.

Answer: C

Question No: 33 – (Topic 1)

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 two-character 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.

Ensurepass 2017 PDF and VCE

You need to ensure that the Merge Join transformation works correctly without additional transformations.

What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  1. Change the ORDER BY clause on the product source to order by ProductName.

  2. Change the Merge Join transformation to a Merge transformation.

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

  4. Set the IsSorted property on both data sources.

Answer: C,D

Question No: 34 – (Topic 1)

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment.

A package in the project uses a custom task component.

You need to ensure that the custom object is deployed on the test environment correctly. What should you do?

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

  2. Create a reusable custom logging component.

  3. Create an OnError event handler.

  4. Use the gacutil command.

  5. Use the dtutil /copy command.

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

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

  8. Use the Project Deployment Wizard.

  9. Deploy the package by using an msi file.

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

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

Answer: D

Reference:

http://msdn.microsoft.com/en-us/library/ms403356.aspx

Question No: 35 – (Topic 1)

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?

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

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

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

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

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

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

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

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

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

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

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

Answer: I

Explanation: References: http://msdn.microsoft.com/en-us/library/hh231102.aspx http://msdn.microsoft.com/en-us/library/hh213290.aspx http://msdn.microsoft.com/en-us/library/hh213373.aspx

Question No: 36 DRAG DROP – (Topic 1)

You are developing a SQL Server Integration Services (SSIS) package.

The package uses custom functionality that accesses a SQL Server database. The custom

functionality must be implemented by using Language Integrated Query (LINQ). You need to ensure that the LINQ code can be debugged at design time.

What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Question No: 37 – (Topic 1)

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to Supported.

You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes.

What should you do?

  1. Move the three Execute SQL tasks into a Sequence container.

  2. Move the three Execute SQL tasks into a Foreach Loop container.

  3. Change the TransactionOption property of all three Execute SQL tasks to Required.

  4. Change the TransactionOption property of the package to Required.

Answer: D

Reference:

http://msdn.microsoft.com/en-us/library/ms137749.aspx

http://msdn.microsoft.com/en- us/library/microsoft.sqlserver.dts.runtime.dtstransactionoption.aspx

Question No: 38 – (Topic 1)

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.)

  1. SQL Server Management Studio

  2. Internet Explorer 6.0 SP1 or later

  3. Microsoft Silverlight 5

  4. .NET Framework 3.5 SP1

  5. .NET Framework 4.0

  6. Microsoft Silverlight 4

  7. SQL Server Data Tools

Answer: B,E

Explanation: Before installing DQS, make sure that your computer meets the minimum system requirements.

Data Quality Client requirement:

NET Framework 4.0 (installed during the Data Quality Client installation, if not already installed)

Internet Explorer 6.0 SP1 or later

Question No: 39 – (Topic 1)

You are installing SQL Server Data Quality Services (DQS).

You need to give specific users access to the Data Quality Server. Which SQL Server application should you use?

  1. SQL Server Configuration Manager

  2. SQL Server Data Tools

  3. SQL Server Management Studio

  4. Data Quality Client

Answer: C Explanation:

Ref: http://msdn.microsoft.com/en-us/library/hh213045.aspx

Question No: 40 DRAG DROP – (Topic 1)

A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog.

To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed.

You need to create these output files with the least amount of administrative and development effort.

Which three stored procedures should you execute in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Box 1:

Box 2:

Ensurepass 2017 PDF and VCE

Box 3:

Ensurepass 2017 PDF and VCE

Ref: http://msdn.microsoft.com/en-gb/library/hh230989(v=sql.110).aspx

100% Ensurepass Free Download!
Download Free Demo:70-767 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass 70-767 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE

Leave a Reply

Your email address will not be published. Required fields are marked *

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