ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 171 - PL-400 discussion

Report
Export

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.

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

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

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

Answers
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: C, D

Explanation:

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

asked 05/10/2024
Brett Tin
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first