Microsoft Certified Azure Data Engineer Associate · Free Practice Question Easy
Question 48
Scenario: James Rhodes has taken on a role at Wakanda Secret Service (WSS). T'Challa is the sponsor on a WSS project where he wants to be able to scan data assets.
Given: The project is using a dedicated SQL pool in an Azure Synapse Analytics workspace.
Which kind of source should James register in Microsoft Purview to be able to scan the data assets?
-
A
Azure SQL Database
-
B
Azure Data Lake Storage Gen2
-
C
Azure Cosmos DB
-
D
Azure Synapse Analytics
Reveal correct answer
Correct answer: D
Explanation
An Azure Synapse Analytics source is used to scan database in SQL pools in a workspace.
Azure Data Lake Storage Gen2 store is used to scan Azure storage containers that host data lake assets.
Azure Synapse Analytics and Azure Cosmos DB do not store dedicated SQL pool data in Azure SQL Database.
Register and scan data sources
Microsoft Purview supports the creation of a data map that catalogues data assets in collections by scanning registered sources. Collections form a hierarchy of logical groupings of related data assets, under a root collection that is created when you provision a Microsoft Purview account. You can use the Microsoft Purview Governance Portal to create and manage collections in your account.
To include assets from a particular data source, you need to register the source in a collection. Microsoft Purview supports many kinds of source, including:
Azure Synapse Analytics - One or more SQL databases in a Synapse Analytics workspace.
Azure Data Lake Storage Gen2 - Blob containers used to host folders and files in a data lake.
To catalogue assets used in an Azure Synapse Analytics workspace, you can register one or both of these sources in a collection, as shown here:
After registering the sources where your data assets are stored, you can scan each source to catalog the assets it contains. You can scan each source interactively, and you can schedule period scans to keep the data map up to date.
A. Azure SQL Database is not the correct choice for registering as a source in Microsoft Purview in this scenario. The project specifies the use of a dedicated SQL pool in Azure Synapse Analytics, which is a separate service from Azure SQL Database. Registering Azure SQL Database as a source may not provide the necessary access to scan the data assets in the dedicated SQL pool.
B. Azure Data Lake Storage Gen2 is not the correct choice for registering as a source in Microsoft Purview in this scenario. While Azure Data Lake Storage Gen2 is a popular storage solution for big data analytics, the project specifically mentions the use of a dedicated SQL pool in Azure Synapse Analytics, making it the more appropriate source to register for scanning data assets.
C. Azure SQL Storage is not a valid Azure service or storage solution. It is important to select the correct Azure service that aligns with the project requirements, which in this case is the dedicated SQL pool in Azure Synapse Analytics. Registering Azure SQL Storage as a source may not provide the appropriate access or visibility needed to scan the data assets in the dedicated SQL pool.
D. Registering Azure Synapse Analytics as a source in Microsoft Purview is the correct choice because the project is using a dedicated SQL pool in an Azure Synapse Analytics workspace. This will allow James Rhodes to scan the data assets stored in the dedicated SQL pool within the Azure Synapse Analytics workspace.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
