After cash-office audits, county finance must land corrected fee rows in a quarantined adjustments table. Which pattern fits?
Select an answer to reveal the explanation.
Short Explanation
Audit corrections belong in a quarantine inbox. You'll INSERT the fixed fee rows there as new rows. MERGEing them into a quarantined adjustments table after cash-office audits won't work since you'd upsert and lose each separate correction.
Full Explanation
After cash-office audits, corrected fee rows should INSERT into a quarantined adjustments table rather than silently mutating production fee facts. Quarantine keeps corrections reviewable, attributable, and separable from the original posted activity—essential for county finance audit trails. Downstream processes can then apply approved adjustments through controlled merge or accounting rules without pretending history always looked corrected.
MERGEing corrected fee rows into a quarantined adjustments table after cash-office audits fails by concept: it matches and upserts against existing quarantine rows instead of adding each correction as a new attributable row, risking overwrite of prior adjustments. OVERWRITEing corrected fee rows into a quarantined adjustments table after cash-office audits fails by operation: it replaces the entire quarantine contents and wipes prior adjustments instead of appending new rows, so finance loses the complete attributable adjustment trail the audit requires. UPDATEing corrected fee rows into a quarantined adjustments table after cash-office audits fails by operation: it mutates existing quarantine rows in place instead of INSERTing each correction as a separate new row, so finance loses the attributable adjustment trail the audit requires.
Exam caveat: Correction workflows favor insert-into-quarantine or explicit adjustment ledgers over MERGEing corrected fee rows into a quarantined adjustments table after cash-office audits. Distinguish operational fix tickets from auditable financial adjustments.
Operational check: After a cash-office audit, INSERT corrected fee rows into the adjustments quarantine with auditor metadata. Confirm production fee facts remain unchanged until an approved application job runs. Reconcile adjustment totals to the audit memo and confirm that quarantined rows aren't updated in place but are INSERTed as new corrected fee rows after cash-office audits.
Prefer to study offline? Printable PDF study book + test engine ($7.50, unofficial). These questions stay free here.