Hotspot Question You have an on-premises datacenter and an Azure subscription. The environment contains 100 databases of various types, including Azure SQL Database, Azure SQL Managed Instances…

This hotspot question tests knowledge of Azure data catalog and big data analytics services, requiring you to match specific requirements to the correct Azure services.

Submitted by haruto_sh· Mar 6, 2026Design data storage solutions

Question

Hotspot Question You have an on-premises datacenter and an Azure subscription. The environment contains 100 databases of various types, including Azure SQL Database, Azure SQL Managed Instances, Azure Cosmos DB, Microsoft SQL Server, MySQL, and Oracle. Multiple apps access the databases. You need to recommend a data solution. The solution must meet the following requirements: - Provide a single searchable catalog of the data in all the databases. The catalog must contain metadata of the data. The solution must minimize storage requirements. - Provide a central data lake that contains specific data from multiple databases. The solution must include a big data engine that can create machine learning models. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:

Exhibit

Answer Area

For the searchable data catalog, use:
Azure Data ExplorerAzure Data FactoryAzure Synapse AnalyticsMicrosoft Purview Data Map
For the central data lake, use:
Azure Data ExplorerAzure Data FactoryAzure Synapse AnalyticsMicrosoft Purview Data Map

Explanation

This hotspot question tests knowledge of Azure data catalog and big data analytics services, requiring you to match specific requirements to the correct Azure services.

Approach. For the single searchable catalog with metadata and minimal storage, Microsoft Purview (formerly Azure Purview) is the correct answer - it provides a unified data governance and cataloging service that scans and indexes metadata from diverse sources (Azure SQL, Cosmos DB, SQL Server, MySQL, Oracle) without copying the actual data, thus minimizing storage. For the central data lake with a big data engine capable of creating machine learning models, Azure Synapse Analytics is the correct answer - it combines a data lake (Azure Data Lake Storage Gen2), big data processing (Spark pools), and integration with Azure Machine Learning, making it ideal for consolidating specific data from multiple databases and building ML models.

Concept tested. The question tests understanding of two distinct Azure services: Microsoft Purview for metadata cataloging/data governance across heterogeneous data sources (no data movement, minimal storage), and Azure Synapse Analytics for unified big data analytics, data lake management, and machine learning model creation from consolidated data.

Reference. https://learn.microsoft.com/en-us/azure/purview/overview and https://learn.microsoft.com/en-us/azure/synapse-analytics/overview-what-is

Topics

#Microsoft Purview#Data catalog#Data lake#Data governance

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice