Question 180
A data architect recommends this approach: Optimize primarily for transactional write and point-read patterns. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Read-write ratio. Operational data access remains responsive under many short transactions.
Incorrect Answers
The other situation is better matched to Use transactional concurrency control appropriate for the database. Concurrent operations can be isolated while preserving valid committed state.
The other situation is better matched to Classify the task as an analytical or OLAP workload. Large scans and grouped historical summaries dominate rather than individual order updates.
The other situation is better matched to Classify the workflow as extract-load-transform. Transformation occurs after ingestion using the target environment's compute.