Note: This question is part of a series of questions that use the same or similar answer choic

es. 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

tha

t 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.

A new version of the Integration Services package i

s released that introduces several errors in the loading process.

You need to roll back the Integration Services package to the previous version.

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.restore_project restores a project in the Integration Services catalog to a previous

version.

References:

https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-restore-project-ssisdb-database?view=sql-server-2017