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

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

Question No.151

HOTSPOT

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

The package must run a parameterized query against a Windows Azure SQL Database database. You need to use the least amount of development effort to meet the package requirement.

Which task should you use?

To answer, select the appropriate task in the answer area.

image

Correct Answer:

image

Question No.152

You are designing a data warehouse that uses SQL Server 2016.

The data warehouse contains a table named factSales that stores product sales. The table has a clustered index on the primary key, four foreign keys to dimension tables, and an aggregate column for sales totals. All key columns use the INT data type, and the aggregate column uses the MONEY data type.

You need to increase the speed of data retrieval from the factSales table. Which index type should you add to the table?

  1. Full text

  2. Spatial

  3. Non-clustered

  4. Clustered

Correct Answer: C

Question No.153

DRAG DROP

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

The package contains an ADO object source variable that holds a result set that was returned by a stored procedure execution.

You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.

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.

image

Correct Answer:

image

Question No.154

You are installing the Data Quality Server component of Data Quality Services.

You need to provision the hardware and install the software for the server that runs the Data Quality Server.

You must ensure that the minimum Data Quality Server prerequisites are met. What should you do?

  1. Install SQL Server 2016 Database Engine.

  2. Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot.

  3. Make sure the server has at least 4 GB of RAM.

  4. Install Microsoft Internet Explorer 6.0 SP1 or later.

Correct Answer: A

Explanation:

Data Quality Server Minimum System Requirements SQL Server 2016 Database Engine.

Memory (RAM): Minimum: 2 GB

Recommended: 4 GB or more

Note: SQL Server Data Quality Services (DQS) is a new feature in SQL Server 2016 that contains the following two components: Data Quality Server and Data Quality Client.

Question No.155

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.

The project will be deployed to an SSIS catalog folder where Environments have already been created. You need to deploy the project. What should you do?

  1. Use an event handler for OnError for the package.

  2. Use an event handler for OnError for each data flow task.

  3. Use an event handler for OnTaskFailed for the package.

  4. View the job history for the SQL Server Agent job.

  5. View the All Messages subsection of the All Executions report for the package.

  6. Store the System::SourceID variable in the custom log table.

  7. Store the System::ServerExecutionID variable in the custom log table.

  8. Store the System::ExecutionInstanceGUID variable in the custom log table.

  9. Enable the SSIS log provider for SQL Server for OnError in the package control flow.

  10. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow,

  11. Deploy the project by using dtutil.exe with the /COPY DTS option.

  12. Deploy the project by using dtutil.exe with the /COPY SQL option.

  13. Deploy the .ispac file by using the Integration Services Deployment Wizard.

  14. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.

  15. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.

  16. Create a SQL Server Agent job to execute the SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.

  17. Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.

  18. Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.

Correct Answer: M

Question No.156

HOTSPOT

You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model. The model consists of two entities: one named Customer and one named State.

You open the Customer entity.

Currently, data stewards can enter any text value in the Customer entity#39;s State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity.

You need to configure the State attribute of the Customer entity.

Which option should you use?To answer, select the appropriate area in the answer area.

image

Correct Answer:

image

Question No.157

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2016.

The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter.

You need to create a solution to meet the requirements by using the least amount of administrative effort.

What should you do?

  1. Add a SQLMOBILE connection manager to each package.

  2. Add an ADO.NET project connection manager.

  3. Add a SQLMOBILE project connection manager.

  4. Add an ADO.NET connection manager to each data flow task.

  5. Add a SQLMOBILE connection manager to each data flow task.

  6. Add an ADO.NET connection manager to each package.

Correct Answer: B

Explanation:

http://www.databasejournal.com/features/mssql/windows-azure-sql-database-uploading-data-by- using-sql-server-integration-services.html

Question No.158

Your company has several line-of-business applications. The applications use a server that has SQL Server installed and contains several databases.

You need that the business applications can access curated and validated data from the databases.

Which features should you deploy to the server?

  1. Data Quality Services (DQS)

  2. SQL Server Analysis Services (SSAS) dimension hierarchies.

  3. SQL Server Integration Services (SSIS)

  4. Master Data Services (MDS) subscriptions.

Correct Answer: C

Question No.159

You are designing a data warehouse that contains a customer dimension.

The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved.

The customer dimension design must:

Support a Type 3 Slowly Changing Dimension (SCD) process Minimize the total storage consumed

You need to design a solution that meets these requirements. What should you do?

  1. Design two tables. One table will hold the original customer surrogate key and attributes. The other table will hold the most recent customer surrogate key and attributes.

  2. Design a table as a Type 2 SCD dimension that holds the surrogate key for each customer and its attributes. Limit the number of records per customer within the table to two.

  3. Design a table to hold the surrogate key for each customer and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.

  4. Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.

Correct Answer: D

Question No.160

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 data source will be polled once per hour. The data is updated with multiple important status changes per minute.

For each captured data change, the before and after values must be included. You need to configure the CDC Source component.

Which CDC processing mode should you select?

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

image

Correct Answer:

image

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

Leave a Reply

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

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>