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

Questions 16–20

1. 16expert · hard

   A company has deployed the 'Supply Chain' database template to a serverless SQL database in Azure Synapse Analytics. They need to customize the schema to add a new table for tracking shipments. After adding the table, they need to ensure it is discoverable in Microsoft Purview and that lineage from the source data is captured. What is the most efficient way to achieve this?

   • ACreate the table in a separate database and register it in Purview separately.
   • BCreate the new table in the serverless SQL database, then trigger a Purview scan of the database to capture the new table and its lineage.
   • CRe-deploy the entire database template with the new table included in the template definition.
   • DUse the Purview Atlas API to manually create the new table asset and define its lineage.
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A data governance team wants to push custom lineage information to Microsoft Purview for a process that is not natively supported, such as a custom Python script that transforms data. What should they do?

   • AManually document the lineage in a spreadsheet and upload it to Purview.
   • BUse Azure Synapse Pipelines to run the script and rely on automatic lineage.
   • CUse Azure Data Factory to wrap the Python script and let Purview capture lineage automatically.
   • DUse the Purview Atlas API to submit lineage information for the custom process.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data engineering team uses Azure Data Factory pipelines to move data from an on-premises SQL Server to Azure Data Lake Storage. They want to see the lineage of the data in Microsoft Purview, showing how the data flows from source to destination. What should they do?

   • ARegister the Data Factory and SQL Server in Purview, and ensure the pipeline activities are configured to capture lineage.
   • BUse Azure Synapse Analytics to run the pipelines and then export lineage to Purview.
   • CUse Azure Databricks to read the data and write lineage information to Purview using the API.
   • DManually create lineage entries in Purview for each pipeline run.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   In Azure Synapse Analytics, which component allows you to run distributed data processing using Python, Scala, or SQL on a managed cluster?

   • AServerless SQL pool
   • BApache Spark pool
   • CDedicated SQL pool
   • DIntegration runtime
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A data analyst wants to find all datasets in Microsoft Purview that contain customer personal information, such as names and email addresses. They need to browse the catalog to understand the structure and classification of these assets. What should they do first?

   • ABrowse the asset hierarchy by data source and open each asset to check its schema.
   • BUse the Purview Data Catalog search bar to search for 'customer' and filter by classification.
   • CRequest a new scan of all data sources to update the catalog.
   • DUse the Purview Atlas API to query all assets and manually inspect them.
   Reveal Solution Discussion Select an answer first