Microsoft Exam PL-400 Topic 10 Question 54 Discussion

Actual exam question for Microsoft's PL-400 exam

Question #: 54
Topic #: 10

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.

AUse 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.

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

CUse 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.

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

Show Suggested Answer

Suggested Answer: C, D

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.

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

by Elza at May 06, 2022, 07:39 PM

Limited Time Offer

25%

Off

Get Premium PL-400 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!