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.
catalog.deploy_project
B.
catalog.restore_project
C.
catalog.stop_operation
D.
sys.sp_cdc_add_job
E.
sys.sp_cdc_change_job
F.
sys.sp_cdc_disable_db
G.
sys.sp_cdc_enable_db
H.
sys.sp_cdc_stop_job
Explanation:
sys.sp_cdc_disable_db disables
change data capture for all tables in the database currently enabled. All system objects related to change data capture, such as change tables, jobs, stored procedures and functions, are dropped.
References: https://docs.microsoft.com/en-us/sql/relational
-databases/system-stored-procedures/sys-sp-cdc-disable-db-transact-sql?view=sql-server-2017