Heavy operational reports run directly against the live OLTP licensing database and cause lock contention for clerks. What architecture response is indicated?
Select an answer to reveal the explanation.
Short Explanation
Running giant reports on the same register clerks use is like auditing the cash drawer during every sale—everything locks up. Peel reporting load onto an isolated copy or ODS/warehouse path so transactions keep moving.
Full Explanation
Heavy read workloads on OLTP systems compete for locks and resources with transactional users, degrading operational performance. Architecture should isolate analytic or intensive operational-reporting reads via replicas, ODS, warehouse, or similar patterns. Workload isolation protects systems of record while still enabling needed reporting.