azureblog.co.uk
← AZ-305 study plan
AZ-305 · Design data storage solutions

Design data integration and analysis

Recommending data integration with Data Factory and Fabric, and data analysis with Microsoft Fabric, Databricks and Synapse.

  • 12 min
  • 2 concepts
  • Try it yourself
  • 3-question check

Learn

Data integration moves and transforms data from many sources into one place; data analysis turns it into insight. Microsoft Fabric now brings most of these tools together as one SaaS platform built on OneLake.

  1. 1

    Recommend a solution for data integration

    Azure Data Factory (and Data Factory in Fabric) orchestrates ETL/ELT pipelines with 90+ connectors, copy activities and mapping data flows; a self-hosted integration runtime reaches on-premises sources. Use Event Hubs and Stream Analytics (or Fabric Real-Time Intelligence) for streaming data. Use mirroring in Fabric to replicate operational databases into OneLake in near real time.

    Remember: On-premises source for Data Factory? Self-hosted integration runtime.

  2. 2

    Recommend a solution for data analysis

    Microsoft Fabric: one SaaS platform with lakehouses, warehouses, notebooks, real-time analytics and Power BI, all on OneLake. Azure Databricks: Apache Spark platform for data engineering and machine learning. Azure Synapse Analytics: dedicated SQL pools and Spark for existing investments. Azure Data Explorer: fast analysis of large volumes of logs and telemetry with KQL.

    Remember: One integrated analytics platform: Microsoft Fabric.

A typical analytics flow

  1. IngestData Factory pipelines, mirroring or event streams.
  2. StoreOneLake or Data Lake Storage (bronze, silver, gold).
  3. TransformSpark notebooks, dataflows or SQL.
  4. ServeWarehouse or lakehouse SQL endpoint.
  5. VisualisePower BI reports.

Try it

Which service fits?

This interactive part needs JavaScript.

In the portal

  • Data factoriesAzure portal: Data factories > Create
  • FabricAzure portal: Microsoft Fabric > Create

Key terms

Click a card to see the definition.

Check your understanding

3 questions. Score 80% or more and these skills are marked as confident in your AZ-305 study plan.

  1. What lets Data Factory reach an on-premises database?

  2. What is OneLake?

  3. Which service is optimised for KQL over huge telemetry volumes?

Sources

Facts in this lesson are from Microsoft Learn. This site isn't affiliated with Microsoft.