As part of the month-end financial closing process, a company uses a batch job to copy all orders into a staging database.
The staging database is used to calculate any outstanding amounts owed by clients, and must process all historical data.
You need to ensure that only the data affected during the month is included in the integration process.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Use change tracking on the orders and run the integration to retrieve new orders and the orders that have the total amount changed in the last month.

B. Create a system view with the orders that have the Modified On field in the last month and run the integration on this subset.

C. Use change tracking on the order lines and run the integration every week and retrieve only the order lines that have been created or deleted in the last month.

D. Create a system view with the order lines that have the Modified On field in the last month and run the integration on this subset.








 

Suggested Answer: CD

C: The change tracking feature in Microsoft Dataverse provides a way to keep the data synchronized in an efficient manner by detecting what data has changed since the data was initially extracted or last synchronized. Deletions and creations are tracked.
D: On modified Order Lines, not on Modified Orders.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-change-tracking-synchronize-data-external-systems
 https://docs.microsoft.com/en-us/powerapps/developer/data-platform/behavior-format-date-time-attribute

This question is in PL-400 Microsoft Power Platform Developer Exam
For getting Microsoft Certified: Power Platform Developer Associate Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.