Design and Implement the Data Exploration Layer DP-203 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   In the Microsoft Purview Data Catalog, which feature allows you to locate data assets by entering keywords that match asset names, descriptions, or classifications?

   • ASearch
   • BData map
   • CInsights
   • DBrowse
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A healthcare organization is implementing Azure Synapse Analytics database templates to standardize their data exploration layer. They have deployed the Healthcare template to a serverless SQL database. Now they need to ensure that when new data is loaded into the underlying data lake, the lineage information in Microsoft Purview is updated to reflect the new data sources. What should they configure?

   • ASet up Purview to scan the serverless SQL database and the data lake on a schedule, and enable data lineage for the SQL database assets.
   • BCreate a custom application that calls the Purview API to push lineage after each data load.
   • CUse Azure Data Factory to copy data into the serverless SQL database and rely on Data Factory's built-in lineage tracking.
   • DManually update the lineage information in Purview after each data load using the Purview UI.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data engineering team needs to run a complex transformation that requires joining a large Parquet dataset with a small reference CSV, applying window functions, and writing the result back to the data lake. The team wants to use Python libraries and needs the job to scale out across multiple nodes. Which approach should they choose?

   • AUse SQL serverless to write a T-SQL query that joins the files and use CETAS to write the result.
   • BUse Azure Data Factory to copy both files into a dedicated SQL pool and run the transformation as a stored procedure.
   • CCreate an Apache Spark pool in Azure Synapse Analytics and run a PySpark notebook that reads both files, performs the join and window functions, and writes the output.
   • DUse Azure Synapse Pipelines to run a data flow that reads the files and writes the output.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In Azure Synapse Analytics, which query engine is used to run T-SQL queries directly against files in a data lake without provisioning a dedicated compute cluster?

   • ASpark pool
   • BSQL serverless (serverless SQL pool)
   • CDedicated SQL pool
   • DData Explorer pool
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company is using Azure Synapse Analytics database templates to create a data exploration layer. They have deployed the 'Customer Insights' template to a serverless SQL database. Now they need to customize the schema to add a new column to one of the tables. After making the change, they need to ensure the lineage in Microsoft Purview reflects the updated schema. What should they do?

   • ARe-deploy the entire database template from scratch with the new column included.
   • BAlter the table in the serverless SQL database to add the column, then trigger a new Purview scan of the database.
   • CManually update the lineage in Purview using the UI to reflect the new column.
   • DUse the Purview Atlas API to update the schema and lineage directly without scanning.
   Reveal Solution Discussion Select an answer first