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 o
ne 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.
Users report that an application that uses
DB1
is suddenly unresponsive.
You discover that the Integr
ation Services job causes severe blocking issues in the application.
You need to ensure that the users can run the application as quickly as possible.
Your SQL Server login is a member of only the
ssis_admin
database role.
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_change_jo
b modifies the configuration of a change data capture cleanup or capture job in the current database.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sys-sp-cdc-change-job-transact-sql?view=sql-server-2017