Exam DP-300 Topic 4 Question 200 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 200
Topic #: 4
Task 4
You need to enable change data capture (CDC) for db1.

Suggested Answer:

See the explanation part for the complete Solution.
Explanation:
To enable change data capture (CDC) for db1, you need to run the stored procedure sys.sp_cdc_enable_db in the database context. CDC is a feature that records activity on a datab ase when tables and rows have been modified 1 . CDC can be used for various scenarios, such as data synchronization, auditing, or ETL processes
2 .
Here are the steps to enable CDC for db1:
* Connect to db1 using SQL Server Management Studio, Azure Data Studio, or any other tool that supports Transact-SQL statements.
* Open a new q uery window and run the following command: EXEC sys.sp_cdc_enable_db; GO
* This command will enable CDC for the database and create the cdc schema, cdc user, metadata tables, and other system objects for the database 3 .
* To verify that CDC is enabled for db1, you can query the is_cdc_enabled column in the sys.databases catalog view. The value should be 1 for db1.
These are the steps to enable CDC for db1

by Joanna at Jul 13, 2026, 05:44 AM

Limited Time Offer

15%

Off

Get Premium DP-300 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10