Introduction

Completed

Azure Architects need to design and recommend data integration solutions to support cloud migration strategies. The cloud data solution must be designed to handle the ingestion, processing, and analysis of data that's too large and complex for traditional database systems.

Meet Tailwind Traders

Tailwind Traders is a fictitious home improvement retailer. The company specializes in hardware manufacturing, and operates retail hardware stores across the globe and online. The storage infrastructure holds various data types, including product volume stock, historical data, and production logs. The implementation also supports data streaming from real-time critical manufacturing processes and quality control statistics.

As you work through this lesson, suppose you're the CTO for Tailwind Traders. You're tasked with analyzing and architecting a cloud data solution to handle data that's too large and complex for traditional database systems. You're asked to determine the best approach to combine data from multiple sources. The solution must be able to reformat data into analytical models, and save the models for querying, reporting, and visualization.

Learning objectives

In this module, you:

  • Design a data integration solution with Azure Data Factory.

  • Design a data integration solution with Azure Data Lake.

  • Design a data integration and analytics solution with Azure Databricks.

  • Design a data integration and analytics solution with Azure Synapse Analytics.

  • Design strategies for hot, warm, and cold data paths.

  • Design an Azure Stream Analytics solution for data analysis.

Skills measured

The content in this module helps you prepare for Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions. The module concepts are covered in:

Design data storage solutions

  • Design data integration

    • Recommend a solution for data integration

    • Recommend a solution for data analysis

Prerequisites

  • Conceptual knowledge of data integration solutions

  • Working experience with data integration solutions