Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

An organization has an Azure SQL Database instance that must be synchronized daily with data from Dynamics 365 Sales. A large amount of data might need to be synchronized on some days.

You need to reduce the time required to synchronize data.

Solution:

✑ Write a SSIS package to connect to the source and target.

✑ Develop the SSIS package to find the records by the Modified on field.

✑ Create or update the records in the database instance based on results.

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: B

Explanation:

Instead enable change tracking for entities that will be synchronized, and use the Data Export Service to sync data between the database and Dynamics 365 Sales.

Reference:

https://docs.microsoft.com/en-us/power-platform/admin/enable-change-tracking-control-data-synchronization

https://docs.microsoft.com/en-us/power-platform/admin/replicate-data-microsoft-azure-sql-database