Implementing a SQL Data Warehouse — Question 36

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 loads 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?

Answer options

• 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

Correct answer: A

Explanation

The correct answer is A, catalog.deploy_project, as it is used to deploy and update the jobs related to change data capture in SQL Server. The other options either relate to restoring projects, stopping operations, or managing the change data capture settings, but do not address the need to ensure the job retrieves a broader range of change data.