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

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: 1 DRAG DROP – (Topic 1)

You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process.

You need to load data from all copied files to a destination table in SQL Server.

Which three steps 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.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

References:

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

Question No: 2 DRAG DROP – (Topic 1)

You are designing a SQL Server Integration Services (SSIS) package. The package moves order-related data to a staging table named Order. Every night the staging data is truncated and then all the recent orders from the online store database are inserted into the staging table.

Your package must meet the following requirements:

鈥f the truncate operation fails, the package execution must stop and report an error.

鈥f the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be rolled back.

鈥or auditing purposes, a log entry must be entered in a SQL log table after each execution of the Data Flow task.

The TransactionOption property for the package is set to Required. You need to design the package to meet the requirements.

How should you design the control flow for the package? (To answer, drag the appropriate setting from the list of settings to the correct location or locations in the answer area.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

Explanation:

References:

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

Question No: 3 – (Topic 1)

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load.

The package and all three Execute SQL product tasks have their TransactionOption property set to Supported.

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

What should you do?

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

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

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

  4. Move the three Execute SQL product tasks into a Sequence container.

Answer: A Explanation:

References:

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

Question No: 4 – (Topic 1)

You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.

Products for each distributor source must be combined for insertion into a single product table destination.

You need to select the appropriate data flow transformation to meet this requirement.

Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)

  1. Multicast

  2. Merge Join

  3. Term Extraction

  4. union All

  5. Merge

Answer: D,E

Reference: http://msdn.microsoft.com/en-us/library/ms141703.aspx Reference: http://msdn.microsoft.com/en-us/library/ms141775.aspx Reference: http://msdn.microsoft.com/en-us/library/ms141020.aspx Reference: http://msdn.microsoft.com/en-us/library/ms141809.aspx Reference: http://msdn.microsoft.com/en-us/library/ms137701.aspx

Question No: 5 – (Topic 1)

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?

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

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

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

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

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

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

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

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

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

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

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

Answer: B

Reference:

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

Question No: 6 – (Topic 1)

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?

  1. Create a time mapping table.

  2. Change the level of granularity in both fact tables to be the same.

  3. Merge the fact tables.

  4. Create a view on the sales table.

Answer: B

Question No: 7 – (Topic 1)

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?

  1. Create a Subscription View in MDS.

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

  3. Use SQL Server Integration Services (SSIS) to extract the data and put it in a staging database.

  4. Use change data capture on the product entity tables.

Answer: A

Question No: 8 – (Topic 1)

You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).

The package includes custom scripts that must be upgraded. You need to upgrade the package to SQL Server 2016.

Which tool should you use?

  1. SSIS Upgrade Wizard in SQL Server 2008 BIDS

  2. SSIS Upgrade Wizard in SQL Server Data Tools

  3. SQL Server DTExecUI utility (dtexecui.exe)

  4. SQL Server dtexec utility (dtexec.exe)

Answer: B

Question No: 9 DRAG DROP – (Topic 1)

You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property.

You need to create a project parameter and configure it so that its value is encrypted when it is deployed to the SSIS catalog.

Which three steps 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.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Question No: 10 DRAG DROP – (Topic 1)

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#39; 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.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Box 1:

Ensurepass 2017 PDF and VCE

Box 2:

Ensurepass 2017 PDF and VCE

Box 3:

Ensurepass 2017 PDF and VCE

Ref: http://msdn.microsoft.com/en-us/library/hh479592.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.