PrepAway - Latest Free Exam Questions & Answers

Which Transact-SQL statement should you use?

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 Transact-SQL statement should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
EXEC sys.sp_cdc_disable_db

B.
ALTER DATABASE Contoso
SET CHANGE_TRACKING = OFF

C.
ALTER TABLE Sales.SalesOrder
DISABLE CHANGE_TRACKING

D.
EXEC sys.sp_cdc_disable_table
@source_schema = N’Sales’,
@source_name = N’SalesOrder’,
@capture_instance = N’Sales_SalesOrder’


Leave a Reply