List of questions
Related questions
Question 171 - PL-400 discussion
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.
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.
Create a system view with the orders that have the Modified On field in the last month and run the integration on this subset.
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.
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.
0 comments
Leave a comment first