Microsoft · AZ-305
Data integration and analysis
AZ-305 · Lesson 7 of 13 · 46:05
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the AZ-305 exam (Microsoft Azure Solutions Architect Expert). In this lesson: designing data integration and analysis: Azure Data Factory pipelines, mapping data flows and integration runtimes (Azure, self-hosted, Azure-SSIS), Microsoft Fabric and OneLake, Azure Databricks and Azure Synapse Analytics, real-time data with Event Hubs, Azure Stream Analytics and Azure Data Explorer, and how to map each requirement to the right service. Includes three original practice questions.
Preview the topics
- Every night, data must be copied from a SQL Server behind the company firewall to Data Lake Storage, and security forbids any inbound port. What should the architect recommend?
- Sensor readings arrive through Event Hubs, and the team must compute averages every five minutes with a SQL-like query, and store them in SQL Database, with minimal code. What should the architect recommend?
- A company wants one software-as-a-service platform for ingestion, a lakehouse, a warehouse, and Power BI reports, all working on a single copy of the data. What should the architect recommend?