PL-400 Question #204: Real Exam Question with Answer & Explanation

Question

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.

Options

• AUse change tracking on the orders and run the integration to retrieve new orders and the orders
• BCreate a system view with the orders that have the Modified On field in the last month and run the
• CUse change tracking on the order lines and run the integration every week and retrieve only the
• DCreate a system view with the order lines that have the Modified On field in the last month and