Study guide
7.1 Data Integration Pipeline Design
Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions Exam
Track your progress as you read
Finished sections get a check mark.
1 Introduction & Exam Orientation
1.1 AZ-305 Current Exam Facts & Format 1.2 Candidate Profile, Prerequisites & the AZ-104 Requirement 1.3 Skills Outline, Domain Weights & How to Use This Guide
2 Chapter 2: Logging, Monitoring & Diagnostics Design
2.1 Logging Solution Design 2.2 Log Routing Design 2.3 Azure Monitor Metrics & Alerting Design 2.4 Application Insights & Diagnostic Monitoring Design
3 Chapter 3: Authentication & Authorization Design
3.1 Authentication Solution Design 3.2 Identity Management Design 3.3 Authorization for Azure Resources 3.4 Authorization for On-Premises Resources 3.5 Secrets, Certificates & Key Management Design
4 Chapter 4: Governance, Compliance & Identity Governance Design
4.1 Management Group & Subscription Hierarchy Design 4.2 Resource Group Organization & Tagging Strategy Design 4.3 Compliance Management Design 4.4 Identity Governance Design
5 Chapter 5: Relational Data Storage Design
5.1 Relational Data Storage Selection 5.2 Database Service & Compute Tier Design 5.3 Database Scalability Design 5.4 Relational Data Protection Design
6 Chapter 6: Semi-Structured & Unstructured Data Storage Design
6.1 Semi-Structured Data Storage Design 6.2 Unstructured Data Storage Design 6.3 Storage Tier & Cost-Performance Trade-off Design 6.4 Unstructured Data Protection & Durability Design
7 Chapter 7: Data Integration & Analytics Design
7.1 Data Integration Pipeline Design 7.2 Event-Based & Real-Time Data Integration Design 7.3 Data Analytics Platform Design
8 Chapter 8: Backup & Disaster Recovery Design
8.1 Recovery Objectives Design: Calculating and Meeting RTO/RPO 8.2 Azure Site Recovery Architecture for Hybrid Workloads 8.3 Compute Backup & Recovery Design 8.4 Database Backup & Recovery Design 8.5 Unstructured Data Backup & Recovery Design
9 Chapter 9: High Availability Design
9.1 Compute High Availability: Availability Sets & Availability Zones 9.2 Compute High Availability: Load Balancing & VM Scale Set Design 9.3 Relational Data High Availability Design 9.4 Semi-Structured & Unstructured Data High Availability Design
10 Chapter 10: Compute Solution Design
10.1 Compute Requirements Analysis & Virtual Machine-Based Solution Design 10.2 Container-Based Solution Design (AKS, Container Apps, Azure Container Instances) 10.3 Serverless-Based Solution Design (Azure Functions, Logic Apps) 10.4 Batch Processing Solution Design (Azure Batch, HPC Workloads)
11 Chapter 11: Application Architecture Design
11.1 Messaging Architecture Design (Service Bus, Queue Storage) 11.2 Event-Driven Architecture Design (Event Grid, Event Hub) 11.3 API Integration & Application Caching Design (API Management, Azure Cache for Redis, CDN) 11.4 Application Configuration Management & Automated Deployment Design (App Configuration, DevOps Pipelines, Deployment Slots)
12 Chapter 12: Migration Design
12.1 Migration Assessment: Cloud Adoption Framework & On-Premises Evaluation 12.2 IaaS & PaaS Workload Migration Design 12.3 Database Migration Design (Data Migration Service, Database Migration Assistant) 12.4 Unstructured Data Migration Design (AzCopy, Data Box, Storage Migration Service)
13 Chapter 13: Network Solution Design
13.1 Internet Connectivity Design 13.2 Hybrid Connectivity Design 13.3 Network Security Optimization Design 13.4 Network Performance Optimization & Load-Balancing/Routing Design
14 Chapter 14: Final Review, Exam Strategy & Career Path
14.1 Cross-Domain Scenario Practice: Combining Identity, Data, Continuity & Infrastructure Decisions 14.2 Common AZ-305 Decision Traps 14.3 Final Study Plan & Practice Assessment Strategy 14.4 After AZ-305: Retake Policy, Renewal & Career Path
7.1 Data Integration Pipeline Design
Key Takeaways Explain This Topic AI
Azure Data Factory and Synapse Pipelines run on the same orchestration engine; choose based on whether the org needs a standalone integration hub or a unified Synapse workspace.
A Self-Hosted Integration Runtime is mandatory whenever a source or sink has no public endpoint, such as an on-premises system behind a firewall.
Tumbling Window triggers are the correct choice for backfill, retry, and exactly-once-per-interval processing scenarios; Schedule triggers are for simple calendar cadences.
Azure-SSIS Integration Runtime is the tested path for lifting and shifting legacy SSIS packages into Azure without a full rewrite.
Microsoft Fabric Data Factory is positioned as the successor to classic ADF/Synapse Pipelines for 2026 exam scenarios that call for a unified SaaS analytics platform.
Last updated: July 2026
Why Data Integration Design Shows Up on AZ-305
Every enterprise Azure environment eventually has to move data from where it is created to where it is needed — from an on-premises enterprise resource planning (ERP) system into a cloud data warehouse, from a line-of-business SQL Server into a reporting layer, or from dozens of SaaS APIs into one analytical store. The official AZ-305 skill " Recommend a solution for data integration " sits inside the Data Storage domain (20-25% of the exam) and is one of the most scenario-heavy topics on the test, because it forces you to reconcile three things at once: where the source data lives (cloud, on-premises, or SaaS), how it must be transformed, and how the pipeline should be triggered and monitored. Expect case-study questions that describe a hybrid data estate and ask you to pick the orchestration engine, the integration runtime, and the trigger type — not just name a service.
Core Service: Azure Data Factory
Azure Data Factory (ADF) is Azure's cloud-native extract, transform, load / extract, load, transform (ETL/ELT) orchestration service. It does not store or process data itself in most cases — it coordinates movement and transformation across other compute and storage services. Four building blocks matter for the exam:
Pipelines — a logical grouping of activities that together perform a task (for example, copy → transform → load).
Activities — the individual steps inside a pipeline: Copy Activity (moves data between 100+ connectors), Data Flow (a visual, Spark-backed, no-code transformation activity called Mapping Data Flow ), Lookup , Stored Procedure , Execute Pipeline , and Web/Webhook activities.
Linked Services and Datasets — a Linked Service defines the connection to a data store (like a connection string with authentication); a Dataset points to a specific structure within it (a table, folder, or file).
Triggers — Schedule triggers (fixed calendar cadence), Tumbling Window triggers (fixed-size, non-overlapping time slices with built-in retry and dependency chaining — the right answer whenever a scenario mentions backfill or "process each hour's data exactly once"), and Event-based triggers (fire on blob creation/deletion in a storage account).
Integration Runtime (IR) is the compute infrastructure that actually executes the activities, and picking the correct IR type is one of the most tested design decisions:
Integration Runtime When to Recommend
Azure IR Fully managed, serverless; use for cloud-to-cloud data movement and Data Flow execution with no on-premises dependency
Self-Hosted IR (SHIR) Installed on a VM or on-premises server inside the customer's network; required whenever a source or sink sits behind a firewall or inside a private on-premises network with no public endpoint
Azure-SSIS IR Provisions a dedicated VM cluster to lift-and-shift existing SQL Server Integration Services (SSIS) packages into Azure with minimal rework
Azure Synapse Pipelines: Same Engine, Different Home
Azure Synapse Pipelines uses the identical underlying ADF orchestration engine, but it is embedded directly inside an Azure Synapse Analytics workspace alongside SQL pools and Apache Spark pools. The exam-relevant distinction is architectural placement, not capability:
If the organization is standardizing on a single Synapse Analytics workspace as its unified analytics platform (SQL + Spark + pipelines in one place, one workspace-level security boundary, one Git integration), recommend Synapse Pipelines so data engineers do not have to manage two separate orchestration surfaces.
If data integration needs to fan out to many non-analytics destinations (Azure Functions, Logic Apps, on-premises systems, SaaS APIs) independent of any analytics workspace, or the organization does not otherwise need Synapse, recommend standalone Azure Data Factory .
A forward-looking fact worth knowing for a 2026 sitting: Microsoft has been steering new analytics builds toward Microsoft Fabric , whose Fabric Data Factory is described as the next generation of both ADF and Synapse Pipelines, and the classic Azure Synapse Spark runtime (3.4) reaches end of support on March 31, 2026 with Microsoft recommending migration to Fabric. The AZ-305 objective itself stays generic ("recommend a solution for data integration"), and ADF/Synapse Pipelines remain fully supported GA services, so exam scenarios can still validly point to either — but if a scenario explicitly says the customer wants a single SaaS platform combining ingestion, warehousing, and Power BI with no infrastructure to manage, Fabric is the intended design answer over classic Synapse.
Exam Scenario Walkthrough
A hospital network runs its billing system on an on-premises SQL Server behind a corporate firewall with no public endpoint. Requirements: (1) copy billing records into Azure SQL Database nightly, (2) apply a no-code transformation that masks patient identifiers before landing, (3) guarantee each night's batch is processed exactly once even if a run fails and is retried, and (4) the destination environment already runs Synapse Analytics for downstream Spark analytics. The design should include a Self-Hosted Integration Runtime installed inside the hospital's network (because the source has no public endpoint), a Mapping Data Flow for the masking transformation, a Tumbling Window trigger (for guaranteed-once, retryable nightly processing), and orchestration through Synapse Pipelines rather than standalone ADF, since the destination workspace already centralizes analytics.
Takeaways
Azure Data Factory and Synapse Pipelines share one orchestration engine; the choice is about workspace consolidation, not feature gaps.
Any source or sink without a public endpoint requires a Self-Hosted Integration Runtime ; Azure IR alone cannot reach it.
Tumbling Window triggers are the answer whenever a scenario needs backfill, dependency chaining, or "exactly once per interval" semantics.
Azure-SSIS IR is the tested answer for migrating legacy SSIS packages instead of rewriting pipelines from scratch.
Know that Fabric Data Factory is Microsoft's stated direction beyond classic Synapse pipelines, useful for scenarios that explicitly ask for a unified SaaS analytics platform.