Question 160
A data architect recommends this approach: Treat the workload as analytical reporting over accumulated history. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Historical dashboard. Read-heavy aggregations can use analytical storage and compute patterns.
Incorrect Answers
The other situation is better matched to Describe the solution as short-interval batch processing. Records are grouped into periodic batches rather than analyzed individually on arrival.
The other situation is better matched to Use a database transaction with atomic commit or rollback. Related changes succeed together or none are committed.
The other situation is better matched to Separate analytical reporting compute or store from the OLTP path. Heavy historical reads no longer contend as directly with transactional requests.