070-767 試験問題を無料オンラインアクセス

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 a Microsoft SQL server that has Data Quality Services (DQS) installed.
You need to review the completeness and the uniqueness of the data stored in the matching policy.
Solution: You profile the data.
Does this meet the goal?

• A.No
• B.Yes

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 configure a new matching policy Master Data Services (MDS) as shown in the following exhibit.

You review the Matching Results of the policy and find that the number of new values matches the new values.
You verify that the data contains multiple records that have similar address values, and you expect some of the records to match.
You need to increase the likelihood that the records will match when they have similar address values.
Solution: You increase the relative weights for Address Line 1 of the matching policy.
Does this meet the goal?

• A.NO
• B.Yes

You are designing the data warehouse to import data from three different environments. The sources for the data warehouse will be loaded every hour.
Scenario A includes tables in a Microsoft Azure SQL Database:
* Millions of updates and inserts occur per hour
* A periodic query of the current state of rows that have changed is needed.
* The change detection method needs to be able to ignore changes to some columns in a table.
* The source database is a member of an AlwaysOn Availability group.
Scenario B includes tables with status update changes:
* Tracking the duration between workflow statuses.
* All transactions must be captured, including before/after values for UPDATE statements.
* To minimize impact to performance, the change strategy adopted should be asynchronous.
Scenario C includes an external source database:
* Updates and inserts occur regularly.
* No changes to the database should require code changes to any reports or applications.
* Columns are added and dropped to tables in the database periodically. These schema changes should not require any interruption or reconfiguration of the change detection method chose.
* Data is frequently queried as the entire row appeared at a past point in time.
All tables have primary keys.
You need to load each data source. You must minimize complexity, disk storage, and disruption to the data sources and the existing data warehouse.
Which change detection method should you use for each scenario? To answer, drag the appropriate loading methods to the correct scenarios. Each source may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解：

Explanation

Box A: System-Versioned Temporal Table
System-versioned temporal tables are designed to allow users to transparently keep the full history of changes for later analysis, separately from the current data, with the minimal impact on the main OLTP workload.
Box B: Change Tracking
Box C: Change Data Capture
Change data capture supports tracking of historical data, while that is not supported by change tracking.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server
https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-table-usage-scenarios

You plan to deploy several Microsoft SQL Server Integration Services (SSIS) packages to a highly available SQL Server instance. The instance is configured to use an AlwaysOn availability group that has two replicas.
You need to identify which deployment method must be used to ensure that the packages are always accessible from all the nodes in the availability group.
Which deployment method should you use for the packages?

• A.Deploy to the msdb database on the primary replica.
• B.Deploy to the msdb database on the secondary replica.
• C.Deploy to a shared folder on a file server.
• D.Deploy to a file on the hard drive of the primary replica.

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.
You remove the Integration Services job.
You need to stop tracking changes to the database. The solution must remove all the change data capture configurations from DB1.
Which stored procedure should you execute?

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