Knowledge check

1.

What is the default retention policy for the change data capture (CDC) cleanup process?

1 day

2 days

3 days

2.

Which of the following tools offers automatic or on-demand bi-directional data synchronization?

Change Data Capture (CDC)

SQL Data Sync

Change tracking

3.

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>

4.

You can enable SQL Data Sync on tables that don't have a primary key (PK)

True

False

5.

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)

SQL Data Sync

Change tracking

Feedback