Exam 70-767 topic 1 question 60 discussion

Actual exam question from Microsoft's 70-767

Question #: 60
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.
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?

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: A 🗳️
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

by Dieter at May 17, 2020, 3:46 p.m.

Comments

Submit Cancel

Dieter

Highly Voted 5 years ago

Answer is E ( sys.sp_cdc_change_job) since there it says the concrete requirements for the job.

upvoted 7 times

...

othman_ee

Most Recent 4 years, 10 months ago

Answer E You need to change the job to specify you want to capture more than 3 days only https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sys-sp-cdc-change-job-transact-sql?view=sql-server-ver15

upvoted 2 times

...

ThomasKwakman

5 years ago

Hi! Shouldn't it be E. sys.sp_cdc_change_job to modify the retention period of the capture job so that it covers 7 days instead of only 3 ?

upvoted 2 times

...