[Free] 2017(Oct) EnsurePass Braindumps Microsoft 70-767 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2017 Oct 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: 11 – (Topic 1)

You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD).

You need to add a task or component to the package that allows you to implement the SCD logic.

What should you use?

  1. a Script component

  2. an SCD component

  3. an Aggregate component

  4. a Merge component

Answer: D

Question No: 12 – (Topic 1)

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?

  1. Run the DQSInstaller.exe command.

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

  3. Install ADOMD.NET.

  4. Run the dbimpexp.exe command.

Answer: A Explanation: References:

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

Question No: 13 – (Topic 1)

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

The methodology has the following requirements:

鈥he deployment process must be simplified.

鈥ll the logs must be centralized in SQL Server.

鈥og data must be available via reports or T-SQL.

鈥og 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?

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

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

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

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

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

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

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

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

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

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

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

Answer: B

Reference:

http://msdn.microsoft.com/en-us/library/ms140246.aspx http://msdn.microsoft.com/en-us/library/ms180378(v=sql.110).aspx

Question No: 14 DRAG DROP – (Topic 1)

A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time errors.

You need to edit the package to log specific error messages.

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

Question No: 15 DRAG DROP – (Topic 1)

You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.

Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:

->Valid addresses

->Autocorrected addresses

->Invalid addresses

You need to enhance the SSIS packages to perform address validation by using an external service.

Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.)

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Question No: 16 – (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. Use sp_addlinkedserver to add a linked server to access the MDS database tables directly.

  2. Create an OLE DB connection string that sets the Provider property to MDS.

  3. Use transactional replication for data synchronization.

  4. Create a Subscription View in MDS.

Answer: D

Question No: 17 – (Topic 1)

A SQL Server Integration Services (SSIS) package on a computer is failing periodically in production. The package was created less than one year ago and was deployed to the

SSIS catalog.

Sometimes the package is started on a SQL Agent schedule; sometimes the package is started manually by an SSIS developer by using the Object Explorer in SQL Server Management Studio.

You need to identify the authenticated user responsible for starting the package each time it failed in the past.

Where can you find this information?

  1. the SQL Server Log

  2. the SSISDB.[catalog].[executions] view

  3. the SSISDB.[catalog].[event_messages] view

  4. the SQL Agent Job History

  5. the SQL Agent Error Log

Answer: B

Question No: 18 – (Topic 1)

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

You need to design a package to change a variable value during package execution by using the least amount of development effort.

What should you use?

  1. Expression task

  2. Script task

  3. Execute SQL task

  4. Execute Process task

  5. Term Extraction transformation

    Answer: A

    Reference:

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

    Question No: 19 – (Topic 1)

    You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.

    Ensurepass 2017 PDF and VCE

    You need to establish the correct order for loading each table to maximize parallel processing.

    Which order should you use?

    A.

    1. DimCurrency, DimScenario, DimAccount in parallel

    2. DimOrganization

    3. FactFinance

B.

C. DimCurrency, DimOrganization in parallel

  1. DimScenario, DimAccount in parallel

  2. FactFinance

D.

  1. DimCurrency, FactFinance in parallel

  2. DimOrganization, DimScenario, DimAccount in parallel

E.

  1. FactFinance

  2. DimOrganization, DimScenario, DimAccount in parallel

  3. DimCurrency

F.

  1. DimCurrency

  2. DimOrganization

  3. DimScenario, DimAccount in parallel

  4. FactFinance

    Answer: A

    Explanation: References: http://msdn.microsoft.com/en-us/library/ms139892.aspx http://msdn.microsoft.com/en-us/library/ms141261.aspx

    Question No: 20 – (Topic 1)

    You are the data steward for a Business Intelligence project.

    You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.

    You need to produce the CSV file with the least amount of development effort. What should you do?

    1. Create an Integration Services package and use a Fuzzy Lookup transform.

    2. Create a Master Data Services (MDS) model.

    3. Create a Data Quality Project.

    4. Create an Integration Services package and use a DQS Cleansing transform.

    5. Create an Integration Services package and use a Fuzzy Grouping transform.

Answer: C Explanation:

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