Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.
1.2. Workload Types: The Intent of Data
💡 First Principle: We optimize systems either for writing individual records safely (Transactional) or reading massive aggregates efficiently (Analytical). You cannot optimize for both simultaneously with a single engine.
Scenario: A bank has two needs: (1) Process individual ATM withdrawals with guaranteed accuracy—the customer's balance must never be wrong. (2) Generate monthly reports showing withdrawal trends across all 10 million customers. These two needs require fundamentally different database architectures.
Understanding workload types helps you select the right Azure services for each use case.