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

Questions 31–35

1. 31foundation · easy

   When implementing an Azure Synapse lake database from a database template, which component is automatically created to store the table definitions?

   • AA lake database
   • BA Spark table
   • CA data flow
   • DA SQL script
   Reveal Solution Discussion Select an answer first
2. 32application · easy

   A new data analyst wants to understand the data assets available in the organization. They need to see the business glossary, classifications, and descriptions of the assets in Microsoft Purview. What should they use?

   • AUse Azure Data Studio to connect to Purview and browse assets.
   • BUse Azure Synapse Studio to view Purview assets.
   • CBrowse the Purview Data Catalog's asset details and glossary pages.
   • DUse the Purview Atlas API to retrieve all metadata programmatically.
   Reveal Solution Discussion Select an answer first
4. 33expert · hard

   A data analyst needs to find a dataset in Microsoft Purview that was created by a Spark job and contains customer demographics. The analyst knows the dataset is in the 'analytics' schema of a lake database. The analyst also needs to understand the transformation steps that created the dataset. What should the analyst do?

   • AUse the Purview Atlas API to query for assets with 'customer demographics' in the name and check lineage.
   • BBrowse the lake database in Purview, expand the 'analytics' schema, and manually review each table's lineage.
   • CSearch Purview for 'customer demographics', filter by the 'analytics' schema, and view the asset's lineage to see the Spark job and source data.
   • DAsk the data engineering team to provide the lineage information for the dataset.
   Reveal Solution Discussion Select an answer first
5. 34foundation · easy

   Which Microsoft Purview feature is used to view the metadata of a data asset, such as its schema, classification, and lineage?

   • AData source settings
   • BScan rule set
   • CAsset details page
   • DCollection policy
   Reveal Solution Discussion Select an answer first
6. 35application · medium

   A retail company is building a new data exploration layer in Azure Synapse Analytics. They need to store and query data about customers, products, and sales transactions. The team wants to use a pre-built schema that aligns with common retail patterns and can be customized to their specific needs. They also need to ensure that the schema is easily discoverable in Microsoft Purview. What should the team do?

   • AUse the Spark pool to create tables and store them in the lake database, but do not use any templates.
   • BUse Azure Data Factory to copy data into Azure SQL Database and create a schema manually.
   • CUse the Azure Synapse Database Templates for Retail, deploy the template to a serverless SQL database, and register the resulting database in Purview.
   • DCreate a custom schema from scratch in a dedicated SQL pool and manually document it in a wiki.
   Reveal Solution Discussion Select an answer first