Summary and resources

Completed

In this module, you learned about Azure data integration and data analysis solutions. You explored integration and analytics options offered by Azure Data Factory, Azure Data Lake, Azure Databricks, and Azure Synapse Analytics. You discovered how to optimize your strategy for hot, warm, and cold data paths. You reviewed how to design an Azure Stream Analytics solution for data analysis.

Learn more with Copilot

Copilot can assist you in designing Azure infrastructure solutions. Copilot can compare, recommend, explain, and research products and services where you need more information. Open a Microsoft Edge browser and choose Copilot (top right) or navigate to copilot.microsoft.com. Take a few minutes to try these prompts and extend your learning with Copilot.

• As an Azure solution architect, I'm looking to design a data integration solution. What are my options within Azure and the use cases for them?

• Explain the key differences between Azure data integration services and Azure data analytics services. Provide two real-world examples for each service, focusing on scenarios where they would be most effectively applied?

• I'm an Azure Solution Architect tasked with designing a data integration solution that handles both batch and real-time data. We need to integrate data from SQL databases, NoSQL stores, and IoT streams into a central data warehouse and a data lake for analytics. The solution must support high-volume data transfers and complex transformations while adhering to strict compliance and security standards. What services would you recommend, and what are the typical use cases for each?

Learn more with Azure documentation

• Read about Azure Data Factory.
• Read about Azure Databricks.
• Read about Azure Data Lake.
• Examine the Azure Synapse SQL architecture.
• Get an overview of Azure Synapse Link for Azure Cosmos DB.
• Understand Analytics end-to-end with Azure Synapse.
• Understand Transact-SQL features supported in Azure Synapse SQL.
• Understand stream processing.
• Get an overview of Azure Stream Analytics Cluster.

Learn more with self-paced training

• Use data integration at scale with Azure Data Factory.
• Discover Azure database and analytics services.
• Review concepts of data analytics.
• Review an introduction to Azure Data Factory.
• Work with data streams by using Azure Stream Analytics.

Learn more with optional hands-on exercises

• Explore Azure Databricks (interactive exercise). This module requires an Azure subscription with administrative access permissions.
• Explore Azure Synapse Analytics (interactive exercise). This module requires an Azure subscription with administrative access permissions.