This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What is the default retention policy for the change data capture (CDC) cleanup process?
1 day
2 days
3 days
Which of the following tools offers automatic or on-demand bi-directional data synchronization?
Change Data Capture (CDC)
SQL Data Sync
Change tracking
Which is the default function that CDC provides for querying all the changes on table within the specified LSN range?
cdc.fn_cdc_get_all_changes_<capture_instance>
cdc.fn_cdc_get_net_changes_<capture_instance>
You can enable SQL Data Sync on tables that don't have a primary key (PK)
True
False
Which tool should I use if I want to identify whether an insert / update / delete was executed on my data, but without needing a historical record of my data changes?
Change data capture (CDC)
You must answer all questions before checking your work.
Continue
Was this page helpful?