Exam 70-767 topic 1 question 59 discussion

Actual exam question from Microsoft's 70-767

Question #: 59
Topic #: 1

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.
A new version of the Integration Services package is 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

Show Suggested Answer

Suggested Answer: B 🗳️
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

by [deleted] at April 4, 2025, 4:41 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!