Valid 70-767 Dumps shared by ExamDiscuss.com for Helping Passing 70-767 Exam! ExamDiscuss.com now offer the newest 70-767 exam dumps, the ExamDiscuss.com 70-767 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-767 dumps with Test Engine here:
You have a database named DB1 that contains millions of rows. You plan to perform a weekly audit of the changes to the rows. You need to ensure that you can view which rows were modified and the hour that the modification occurred. What should you do?
Correct Answer: D
Explanation/Reference: Explanation: SQL Server 2017 provides two features that track changes to data in a database: change data capture and change tracking. Change data capture provides historical change information for a user table by capturing both the fact that DML changes were made and the actual data that was changed. Changes are captured by using an asynchronous process that reads the transaction log and has a low impact on the system. References: https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes- sql-server
