You are required to modify a table named Sales.SalesOrder. The table has change tracking enabled on it. You need to disable change tracking prior to modifying the Sales.SalesOrder table. Which…

Question

Options

• AEXEC sys.sp_cdc_disable_db
• BALTER DATABASE Contoso
• CALTER TABLE Sales.SalesOrder
• DEXEC sys.sp_cdc_disable_table

• A
  3% (1)
• B
  13% (4)
• C
  77% (23)
• D
  7% (2)

Explanation

Enabling Change Tracking for a Database Before you can use change tracking, you must enable change tracking at the database level. ALTER DATABASE AdventureWorks2008R2 SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON); Enabling Change Tracking for a Table Change tracking must be enabled for each table that you want tracked. When change tracking is enabled, change tracking information is maintained for all rows in the table that are affected by a ALTER TABLE Person.Person ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON); Disabling Change Tracking Change tracking must first be disabled for all change-tracked tables before change tracking can be set to OFF for the database. To determine the tables that have change tracking enabled for a database, use the sys. change_tracking_tables catalog view. ALTER TABLE Person.Person DISABLE CHANGE_TRACKING; When no tables in a database track changes, you can disable change tracking for the database. ALTER DATABASE AdventureWorks2008R2 SET CHANGE_TRACKING = OFF;

No community discussion yet for this question.