exam questions

Exam PL-400 All Questions

View all questions & answers for the PL-400 exam

Exam PL-400 topic 7 question 15 discussion

Actual exam question from Microsoft's PL-400
Question #: 15
Topic #: 7
[All PL-400 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
OlenaChep
6 days, 3 hours ago
Selected Answer: AB
I think the answer is AB. We need orders amount. If order was created or amount was changed no meter in which way (delete order line, insert order line, update order line) the Modify date for Order itself will be changed. And Order itself contains information about customer.
upvoted 1 times
...
Juan0414
1 week, 2 days ago
Selected Answer: AB
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/use-change-tracking-synchronize-data-external-systems It is orders not order lines
upvoted 1 times
...
sudoaptupgrade
4 months, 2 weeks ago
Selected Answer: AB
It should be AB
upvoted 1 times
...
SvetlankaP99
7 months, 3 weeks ago
Selected Answer: AB
In C - about every week, we need every month, so it's not C. As well as not D, because of order lines (that are only in C, in A and B - orders, not order lines) 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. So we have only these options: 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. B - about orders in last month A - about orders in last month
upvoted 1 times
...
Carelele
1 year, 2 months ago
AB, from the lines you can't even access the client
upvoted 2 times
...
At09
1 year, 5 months ago
AB it is
upvoted 1 times
...
MikeAWS
1 year, 6 months ago
My guess AB! A: This option uses change tracking to track changes that have been made to orders. The integration can then be run to retrieve new orders and orders that have had their total amount changed in the last month. This will ensure that only the data affected during the month is included in the integration process. B: This option creates a system view with the orders that have been modified in the last month. The integration can then be run on this subset of orders. This will ensure that only the data affected during the month is included in the integration process.
upvoted 2 times
...
lezzles11
1 year, 7 months ago
Selected Answer: AD
Yeah, doesn't say that change tracking is just for 7 days. https://learn.microsoft.com/en-us/power-apps/developer/data-platform/use-change-tracking-synchronize-data-external-systems
upvoted 2 times
...
Kline
2 years ago
Order lines. I suppose you could remove and add a new line for the same amount
upvoted 1 times
...
Flatternschuchtern
2 years, 5 months ago
My guess is AB, can anyone elaborate why do we need lines instead of just looking at totals?
upvoted 4 times
MarioM
2 years, 5 months ago
change tracking is available for 7 days
upvoted 3 times
justin_s
2 years, 1 month ago
No. There's no such restriction, you can change it by ExpireChangeTrackingInDays.
upvoted 2 times
...
...
Frank208
1 year, 9 months ago
I am assuming it says that all historical records need to be processed. Order line items may change hence, we need line items in order to capture all historical records.
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago