Options for Data Syncing and Checking Changes in Dataverse and Azure SQL Database

Correct Answers: B and D

To synchronize the data between the Dataverse and external system, you need to enable the Change tracking option (Number 3) for the tables you want to synchronize.

You can find this option on the table settings blade (Number 1) under the "Create and update settings" section (Number 2).

You can retrieve the data changes using the Delta links.

The Delta links are the tool provided by the OData 4.0 specification.

It works like the date and time tracking stamps.

To see the table's changes, you need to use a Web API and call the Dataverse entity using a special header key: Prefer with “odata.track-changes” as a value.

In response, you will get the deltaLink token.

You can use this token the next time when you want to see the changes since you run your query.

All other options are incorrect.

For more information about the Dataverse change tracking and data synchronization, please visit the below URLs:

To ensure that data is in-sync between Dataverse and Azure SQL database, you can use two options:

1. Change tracking: This feature allows you to track changes to data in Dataverse tables and entities. When data is updated in Dataverse, the change tracking feature can identify the specific changes made to the data and store them in a change tracking table. You can then use this information to synchronize the changes with your Azure SQL database.

To use change tracking, you need to enable it on the Dataverse tables or entities that you want to track. You can then use a tool such as Azure Data Factory or a custom script to extract the changes and synchronize them with your Azure SQL database. Change tracking is a reliable and efficient way to keep your data in-sync between Dataverse and Azure SQL.

2. Delta link: This feature is a unique URL that represents a specific point in time in the data history of a table or entity in Dataverse. When you retrieve data from Dataverse using a delta link, you get only the changes that have occurred since the previous time you retrieved data using the delta link. This makes it easy to identify the latest changes to the data and synchronize them with your Azure SQL database.

To use delta link, you need to enable it on the Dataverse tables or entities that you want to track. You can then use a tool such as Azure Data Factory or a custom script to retrieve the changes and synchronize them with your Azure SQL database. Delta link is a powerful and flexible way to keep your data in-sync between Dataverse and Azure SQL.

Option A (OpenAPI) is a specification for building APIs, and is not directly related to data synchronization between Dataverse and Azure SQL. Option C (Blank custom connector) is a tool for building custom connectors to connect to external services, and is not directly related to data synchronization between Dataverse and Azure SQL. Option E (Postman Collection) is a tool for testing APIs, and is not directly related to data synchronization between Dataverse and Azure SQL.