Mobile Menu

[Free] 2019(Nov) EnsurePass Microsoft 70-767 Dumps with VCE and PDF 141-150

by admin, November 7, 2019

Get Full Version of the Exam
http://www.EnsurePass.com/70-767.html

Question No.141

HOTSPOT

You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to obtain the CDC data.

The CDC Source component has the following requirements:

image

The output must include metadata columns that indicate which source columns have changed.

image

The output must return only one change row per source row that is modified in the current CDC processing range.

You need to configure the CDC Source component. Which CDC processing mode should you select?

To answer, configure the appropriate option or options in the dialog box in the answer area.

image

Correct Answer:

image

Question No.142

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The package contains a data flow task that has 10 source-to-destination execution trees.

Only five of the source-to-destination execution trees are running in parallel. You need to ensure that all the execution trees run in parallel.

What should you do?

  1. Add OnError and OnWarning event handlers.

  2. Create a new project and add the package to the project.

  3. Query the ExecutionLog table.

  4. Add an Execute SQL task to the event handlers.

Correct Answer: A

Question No.143

HOTSPOT

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

You use a Data Profiling task to examine the data from a source system. You need to establish:

image

The minimum and maximum dates for the datetime columns in the source data

image

The minimum, maximum, and average values for numeric columns in the source data You need to use the appropriate profile type in the Data Profiling task.

Which profile type should you use?

To answer, select the appropriate profile type in the answer area.

image

Correct Answer:

image

Question No.144

HOTSPOT

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

OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by using SQL Server Management Studio.

You need to execute the package and minimize the number of event types that are logged. Which setting should you use?

To answer, change the appropriate setting in the answer area.

image

Correct Answer:

image

Question No.145

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

The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.

You need to create a separate data flow path for data that has been modified since it was last processed.

Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)

  1. Multicast

  2. Data Conversion

  3. Lookup

  4. Slowly Changing Dimension

  5. Aggregate

Correct Answer: AC

Explanation:

A: The transformation that distributes data sets to multiple outputs. The transformation that distributes data sets to multiple outputs.

C: Lookup Transformation

The transformation that looks up values in a reference table using an exact match. Note:

SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean data. Destinations load data into data stores or create in-memory datasets.

Incorrect:

Not B: Data Conversion Transformation

The transformation that converts the data type of a column to a different data type. Not D: Slowly Changing Dimension Transformation

The transformation that configures the updating of a slowly changing dimension.

Not E: The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across.

Question No.146

You have Master Data Services (MDS) in a SQL Server deployment. You need to deploy a model that contains data to the MDS repository. What should you use?

  1. the Model Deployment Wizard

  2. the MDSModelDeploy tool

  3. the Master Data Services Configuration Manager tool

  4. the Integration Services Deployment Wizard

Correct Answer: B

Explanation:

https://msdn.microsoft.com/en-us/library/ff486956.aspx

Question No.147

HOTSPOT

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

The name of the target instance is passed to the package via an Environment variable.

The Environment variable provides the server name to the Project parameter named ServerName. The OLE DB Project Connection Manager has been parameterized.

You need to configure the Connection Manager property to accept the parameter. Which property and parameter should you use?

To answer, configure the appropriate option or options in the dialog box in the answer area.

image

Correct Answer:

image

Question No.148

You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services Catalog.

You need to ensure that the package credentials are encrypted. Which protection level should you set for the package?

  1. EncryptSensitivewithUserKey

  2. EncryptAllWithUserKey

  3. ServerStorage

  4. EncryptSensitivewithPassword

Correct Answer: D

Question No.149

HOTSPOT

You are the Master Data Services (MDS) administrator at your company. An existing user needs to integrate data from other systems into MDS. You need to give the user permissions to integrate data.

Which user management menu item should you select?

To answer, configure the appropriate option or options in the dialog box in the answer area.

image

Correct Answer:

image

Question No.150

You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night.

The Windows Azure SQL Database data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.

If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50.

Many values are incorrectly matched.

You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.

What should you do?

  1. Change the similarity threshold to 0.40.

  2. Decrease the maximum number of matches per lookup.

  3. Change the similarity threshold to 0.85.

  4. Increase the maximum number of matches per lookup.

Correct Answer: C Explanation: Similarity threshold

Set the similarity threshold at the component level by using the slider. The closer the value is to 1, the closer the resemblance of the lookup value to the source value must be to qualify as a match. Increasing the threshold can improve the speed of matching since fewer candidate records need

to be considered.

Get Full Version of the Exam
70-767 Dumps
70-767 VCE and PDF

Categories