Design Studio — Design data integration
AZ-305 › Unit 2 › Design data integration
Design Studio — Design data integration
This studio turns the topic into an architecture exercise. Produce a recommendation that another engineer could challenge, implement, and validate. There is no credit for a list of Azure products without flows, constraints, failure behaviour, and trade-offs.
Studio brief
- 2
- Design data storage solutions
- 4
- 45–60 minutes
Client brief
Fabrikam is modernising a production workload in this domain: Separate movement, orchestration, transformation, streaming, and business workflow requirements. The workload serves internal teams and external customers, carries regulated data, and must remain supportable by a small platform team. The client has supplied incomplete requirements; part of the exercise is to state assumptions and identify questions that would materially change the recommendation.
The initial requirements are:
- The design must address batch movement/orchestration with explicit assumptions and measurable acceptance evidence.
- The design must address large transformations with explicit assumptions and measurable acceptance evidence.
- The design must address high-throughput event ingestion with explicit assumptions and measurable acceptance evidence.
- The design must address business/saas workflow with explicit assumptions and measurable acceptance evidence.
- The solution must use Microsoft Entra identities, private connectivity where justified, infrastructure as code, and observable health signals.
- The design must state a recovery path, operational owner, cost driver, and one deliberate compromise.
Candidate decision anchors
| Requirement thread | Candidate starting point | Qualification rule |
|---|---|---|
| Batch movement/orchestration | Data Factory in Microsoft Fabric or Azure Data Factory | Use pipelines, connectors, and an appropriate integration runtime |
| Large transformations | Fabric Spark/dataflows or Azure Databricks | Match engineering model and operating ownership |
| High-throughput event ingestion | Event Hubs | Partition for throughput and consumer independence |
| Business/SaaS workflow | Logic Apps | Use connectors, state, approvals, and B2B integration |
These are starting points, not an answer key. You may select a different service when a stated assumption or constraint justifies it. Every deviation must identify the requirement it serves and the new operational cost it introduces.
Studio workflow
Clarify
Write five questions whose answers could change the architecture. Mark hard constraints separately from preferences.
Required submission
- A one-page architecture diagram with a text equivalent.
- A decision record containing context, decision, alternatives, consequences, and validation evidence.
- A requirement-to-control matrix that maps every hard constraint to a component or operating process.
- A failure table covering component, zone, region, identity, network, and operator-error failures where applicable.
- Three validation tests: one functional, one reliability/security, and one operational or cost test.
Review traps
- A connector list is not an integration architecture.
- Event Hubs is not a work queue.
- Integration runtime placement controls network reachability.
Assessment rubric
| Dimension | 0 — Missing | 1 — Partial | 2 — Release quality |
|---|---|---|---|
| Requirements | Products chosen before constraints | Some constraints mapped | Hard constraints, assumptions, and change-driving questions are explicit |
| Architecture | Component list | Main flow shown | Identity, traffic/data, dependencies, and failure boundaries are coherent |
| Trade-offs | No alternative | Alternative named | Strongest alternative rejected using a stated requirement |
| Operability | Monitoring mentioned | Some runbook detail | Health, capacity, deployment, recovery, ownership, and cost evidence defined |
| Currency | No sources | Secondary/undated source | Current Microsoft primary source linked and reviewed date recorded |
Reflection
- Which requirement eliminated the most attractive alternative?
- Which assumption creates the greatest residual risk?
- What would you test in a pilot before approving production deployment?
- How would the recommendation change if the operations team doubled in size or the recovery objective tightened?
Source and freshness
Grounded in the current AZ-305 skills outline and both attached course sources. Current service contracts must be verified in Microsoft Learn during the studio. Reviewed 2026-08-02.