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

Questions 26–30

1. 26foundation · easy

   Which Microsoft Purview feature allows you to programmatically push data lineage information for assets that are not automatically captured by scanning?

   • AAzure Policy
   • BData Factory lineage
   • CAtlas API
   • DSynapse pipeline
   Reveal Solution Discussion Select an answer first
2. 27expert · hard

   A large organization has multiple data sources and uses Microsoft Purview for data governance. They need to ensure that lineage is captured for both Azure Data Factory pipelines and custom Python scripts. They also need to allow data scientists to search for assets by business term. What should they implement?

   • AUse only Data Factory for all data movement and avoid custom scripts.
   • BRegister all data sources in Purview, enable automatic lineage for Data Factory, and use the Atlas API for custom scripts. Create a business glossary for searchable terms.
   • CCreate a business glossary but do not register data sources.
   • DUse only the Atlas API for all lineage and skip automatic capture.
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A company has a serverless SQL database in Azure Synapse Analytics created from the 'Retail' database template. They need to query sales data stored as Parquet files in Azure Data Lake Storage. The data is partitioned by year and month. The team wants to minimize query cost and ensure that only relevant partitions are scanned. They also need to see the lineage of the data in Purview. What should they do?

   • ALoad the Parquet files into a dedicated SQL pool and create clustered columnstore indexes for query performance.
   • BUse Spark to read the Parquet files and create temporary views, then query them with serverless SQL.
   • CUse OPENROWSET queries with explicit partition filters in the WHERE clause, and manually register the files in Purview.
   • DCreate external tables in the serverless SQL database using the template's schema, with partition elimination using the year and month columns, and ensure Purview scans the database for lineage.
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A data engineering team uses Azure Synapse Analytics Spark pools to process streaming data. They need to find the output tables in Microsoft Purview to verify the schema and lineage of the processed data. What should they do?

   • AUse Azure Data Factory to copy the output tables to a new location and register them in Purview.
   • BUse the Spark UI to view the query plan and manually document the lineage.
   • CSearch Purview for the table names and review the lineage tab to see the Spark job that produced them.
   • DBrowse the Spark pool's storage account in Purview and look for the output files.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A data engineering team uses Azure Synapse Analytics to explore semi-structured JSON logs stored in Azure Data Lake Storage. The logs contain nested arrays and complex data types that are difficult to query with standard SQL. The team needs to perform iterative data exploration and transformation using a familiar programming language, and they also need to search the Purview catalog to find other datasets with similar schemas. Which approach should the team use?

   • AUse Azure Data Factory to copy the JSON files into Azure Cosmos DB and query them with the SQL API.
   • BCreate a Spark pool in Azure Synapse and use PySpark DataFrames to read the JSON files, flatten the nested structures, and register the results as temporary views.
   • CUse serverless SQL to query the JSON files with OPENROWSET and specify the JSON format in the query.
   • DLoad the JSON files into a dedicated SQL pool using PolyBase and query them with T-SQL.
   Reveal Solution Discussion Select an answer first