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 discover that the job lo
ads changes from the previous three days only.
You need to ensure that the job loads changes from the previous week.
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:
catalog.deploy_project deploys a project to a folder in the Integration Services catalog or updates an existing project that
has been deployed previously.
References: https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-deploy-project-ssisdb-database