Exam DP-203 All QuestionsBrowse all questions from this exam
Question 288

You have an Azure subscription that contains an Azure Data Lake Storage account named dl1 and an Azure Analytics Synapse workspace named workspace1.

You need to query the data in dl1 by using an Apache Spark pool named Pool1 in workspace1. The solution must ensure that the data is accessible Pool1.

Which two actions achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct answer is worth one point.

    Correct Answer: B, C

    To query data in an Azure Data Lake Storage account using an Apache Spark pool in Azure Synapse Analytics, you need to ensure that the data is accessible to the Spark pool. Loading the data into the primary storage account of the Synapse workspace ensures that the Spark pool can access the data directly. Additionally, creating a linked service for the data lake storage from within the Synapse workspace establishes the necessary connection for accessing the data. Registering the data source in Microsoft Purview is used for tracking metadata and lineage, which does not directly grant access to the Spark pool. Implementing Azure Synapse Link is also irrelevant in this context, as it is used for integrating Azure Cosmos DB with Azure Synapse Analytics.

Discussion
jongertOptions: BC

Would say Purview only registers the data source to track lineage, should not have anything to do with access. Synapse Link is not concerned with data lake. Seemingly, data lake storage has to be configured as primary storage as per: https://learn.microsoft.com/en-us/troubleshoot/azure/synapse-analytics/spark/spark-jobexec-storage-access#common-issues-and-solutions

DanweoOptions: BC

B and C, Purview doesnt give access

e56bb91Options: BC

B works, C also works

mghf61Options: AC

A, C ?

be8a152Options: CD

C,D is the correct answer

dakku987Options: BC

chatgpt(although not sure) C. From workspace1, create a linked service for dl1. D. From Microsoft Purview, register dl1 as a data source. Explanation: Create a linked service (C): You need to create a linked service in workspace1 that establishes a connection to dl1. This linked service allows your Spark pool (Pool1) to access the data in dl1. Register dl1 as a data source (D): Registering dl1 as a data source in Microsoft Purview helps in tracking lineage and metadata. While it is not directly related to enabling access from Spark, it is a good practice for governance and understanding the data landscape within your organization.

dakku987

wait ignore my comment its CD