Exam 70-767 topic 1 question 58 discussion

Actual exam question from Microsoft's 70-767

Question #: 58
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 remove the Integration Services job.
You need to stop tracking changes to the database temporarily. The solution must ensure that tracking changes can be restored quickly in a few weeks.
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: C 🗳️
catalog.stop_operation stops a validation or instance of execution in the Integration Services catalog.
Incorrect Answers:
H: sys.sp_cdc_stop_job stops a change data capture cleanup or capture job for the current database.
References: https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-stop-operation-ssisdb-database?view=sql-server-2017

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

Comments

Submit Cancel

melvin9900

4 years, 8 months ago

To stop the CDC job, use: EXEC sys.sp_cdc_stop_job And to start the job again, use: EXEC sys.sp_cdc_start_job

upvoted 2 times

...

othman_ee

4 years, 10 months ago

Correct answer: H You just need to stop the capturing and later on you can start it again. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sys-sp-cdc-stop-job-transact-sql?view=sql-server-ver15

upvoted 1 times

eceb

4 years, 10 months ago

Sorry, I'm confused. Could you stop the capturing job after removing the job? The question says "you remove the job" so I think you don't have any job to stop or I'm understanding something wrong. Therefore in my opinion the right answer is catalog.stop_operation.

upvoted 1 times

Anette

4 years, 9 months ago

But since you remove the Integration Service job how can you Stop a validation or instance of execution in the Integration Services catalog? Also, you need to TRACK Changes, which means that CDC must be used since Change Data Capture was implemented to track changes. So, In my opinion the answer is C.

upvoted 1 times

Cococo

4 years, 8 months ago

Romove != Removed, so you remove the job but first, you need to stop it.

upvoted 1 times

...

MK_

4 years, 11 months ago

The correct answer in this case should probably be F.

upvoted 1 times

eceb

4 years, 10 months ago

I don't think so, sys.sp_cdc_disable_db drop all objects related to CDC, and the question says "the solution must ensure that tracking changes can be restored quickly"... It also says "you remove the Integration service job" so you cannot execute sys.sp_cdc_stop_job. I think catalog.stop_operation is the right answer.

upvoted 3 times

...

Dieter

5 years, 1 month ago

In my opinion the answer should be H (sys.sp_cdc_stop_job) to fulfill requirements that the users can access the application as quickly as possible. The task does not say how to change the cdc job. Any thoughts to that?

upvoted 3 times

Dieter

5 years, 1 month ago

wrong question :) this description should be for the former question...

upvoted 2 times

...