A customer needs help to optimize a workflow that automatically exports tracking records campaigns sent during the day.
The workflow has a scheduler that runs every 6 hours and reads tracking logs created current date minus 6 hours. During data validation, the customer notices that records are missing with this approach. Which two recommendations should the Architect make? (Choose two.)
- Add a scheduler to execute every 6 hours, use an option to store the date since last execution of the export workflow, and use as a reference point.
- Use an incremental query activity to fetch the last modified records from the tracking table modified in the last 6 hours.
- Create an incremental query activity to fetch the last modified records from the recipient table that has tracing logs modified in the last 6 hours.
- Add a scheduler to execute every 6 hours and use a dirty flag to update the tracking record that was picked in the execution of the workflow
- Create a loop with a wait for 6 hours, store an instance variable of the id field that was last selected, and use that in the next query.