How would you configure the database to ensure that each department generates its report (based on its target data) using the most recent report format every day?
Which two actions could you perform to overcome this error without affecting the queries that are currently being executed?