Free Microsoft 70-767 Exam Dumps Questions & Answers

You need to ensure that a downstream system can consume data in a Master Data Services (MDS) system.
What should you configure?

• A.  a matching policy
• B.  a subscription view
• C.  a Data Collector
• D.  a knowledgebase

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an on-premises Microsoft SQL Server instance and a Microsoft Azure SQL Data Warehouse instance. You move data from the on-premises database to the data warehouse once each day by using a SQL Server Integration Services (SSIS) package.
You observe that the package no longer completes within the allotted time.
You need to determine which tasks are taking a long time to complete.
Solution: You alter the package to log the start and completion times for a task to a table in the on-premises SQL Server instance.
Does the solution meet the goal?

• A.  No
• B.  Yes

You are the administrator of a Microsoft SQL Server Master Data Services (MDS) model. The model was developed to provide consistent and validated snapshots of master data to the ETL processes by using subscription views. A new model version has been created.
You need to ensure that the ETL processes retrieve the latest snapshot of master data.
What should you do?

• A.  Update the subscription views to use the new version.
• B.  Create new subscription views for the new version.
• C.  Add a version flag to the new version, and create new subscription views that use this version flag.
• D.  Update the subscription views to use the last committed version.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
Users report that an application that uses DB1 is suddenly unresponsive.
You discover that the Integration Services job causes severe blocking issues in the application. You need to ensure that the users can run the application as quickly as possible. Your SQL Server login is a member of only the ssis.admin database role.
Which stored procedure should you execute?

• A.  catalog.restore_project
• B.  sys.sp_cdc_enable_db
• C.  sys.sp.cdc.changejob
• D.  catalog.deploy_project
• E.  sys.sp.cdc.addjob
• F.  sys.sp_cdc_disable_db
• G.  catalog.stop.operation
• H.  sys.sp_cdc.stopJob

You are developing a data warehouse. You run the following Transact-SQL statement:

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer: