A financial services company needs to implement a data warehouse for risk reporting. They have strict data residency requirements and need to keep all data within a specific Azure region. They also need to support both batch and real-time ingestion. Which approach should they take?

Use the Financial Services database template in a dedicated SQL pool in the required region, and use Synapse Pipelines for batch and streaming ingestion.

Use SQL serverless to query files in the data lake, and rely on external tables for reporting.

Use Azure SQL Database with a geo-replicated secondary in another region.

Use Azure Databricks with a cluster in the required region and build the schema manually.

In Microsoft Purview, which method is used to manually add or update lineage information for a data asset that is not automatically tracked?

Creating a custom scan rule set

Using the Purview Studio UI to edit lineage

A data analyst needs to explore a new Parquet dataset in Azure Data Lake Storage Gen2 that was recently registered in Microsoft Purview. The analyst does not have permissions to create Spark pools, and the data must be queried without moving it. You need to provide the analyst with the ability to run ad-hoc T-SQL queries against the data and to discover the schema and partitioning information from the Purview catalog. What should you do?

Use Azure Data Factory to load the Parquet data into a dedicated SQL pool, then grant the analyst access to query the pool.

Create a serverless SQL database in Azure Synapse Analytics, define external tables using OPENROWSET, and grant the analyst access to the Purview data catalog.

Create a Spark pool and instruct the analyst to use PySpark notebooks to read the Parquet files and manually inspect the schema.

Copy the Parquet files into an Azure SQL Database and create views for the analyst to query.

A healthcare organization is implementing a Synapse database template for clinical trials. They need to ensure that the template's tables are created with appropriate data types and relationships, and that the database can be versioned and redeployed across environments. What is the recommended way to implement this?

Use SQL serverless to create external tables over the raw data files.

Use Azure Data Factory to copy the template from a GitHub repository into the Synapse workspace.

Write a single SQL script that creates all tables and relationships manually, and run it in each environment.

Use the Synapse Database Templates gallery to create the database, then customize the tables and relationships in the workspace.

Microsoft Certified:Azure Data Engineer Associate

Domain 1Objective 2

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

Part of the Design and implement data storage domain, which accounts for 15–20% of the DP-203 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 3–7 from this objective — we provide 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

7concepts

15–20%of the exam

Questions 11–15

11foundation · easy
Which Azure Synapse Analytics feature provides pre-built schemas for common business domains to help you quickly create a lake database?
Select an answer first
12expert · hard
A financial services company needs to implement a data warehouse for risk reporting. They have strict data residency requirements and need to keep all data within a specific Azure region. They also need to support both batch and real-time ingestion. Which approach should they take?
Select an answer first
13foundation · easy
In Microsoft Purview, which method is used to manually add or update lineage information for a data asset that is not automatically tracked?
Select an answer first
14application · medium
A data analyst needs to explore a new Parquet dataset in Azure Data Lake Storage Gen2 that was recently registered in Microsoft Purview. The analyst does not have permissions to create Spark pools, and the data must be queried without moving it. You need to provide the analyst with the ability to run ad-hoc T-SQL queries against the data and to discover the schema and partitioning information from the Purview catalog. What should you do?
Select an answer first
15application · medium
A healthcare organization is implementing a Synapse database template for clinical trials. They need to ensure that the template's tables are created with appropriate data types and relationships, and that the database can be versioned and redeployed across environments. What is the recommended way to implement this?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-203

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-203” is a trademark of its owner, used for identification only.

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

Questions 11–15

Which Azure Synapse Analytics feature provides pre-built schemas for common business domains to help you quickly create a lake database?

A financial services company needs to implement a data warehouse for risk reporting. They have strict data residency requirements and need to keep all data within a specific Azure region. They also need to support both batch and real-time ingestion. Which approach should they take?

In Microsoft Purview, which method is used to manually add or update lineage information for a data asset that is not automatically tracked?

Keep studying — Design and implement data storage