Microsoft Certified:Azure Data Engineer Associate
Domain 1Objective 2
Design and Implement the Data Exploration Layer DP-203 Practice Questions (Page 2)
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 6–10
- 6
A data engineering team is designing a new data model for a retail company that includes dimensions such as customer, product, and store. Which type of Azure Synapse Analytics database template would be most appropriate for this scenario?
Select an answer first - 7
A data scientist needs to find a specific table in Microsoft Purview that contains sales data for the year 2023. The table is stored in an Azure SQL Database and has a column named 'SalesAmount'. What is the most efficient way to locate this asset?
Select an answer first - 8
A manufacturing company wants to implement a data warehouse in Azure Synapse Analytics. They need to track production orders, inventory, and suppliers. Which Synapse database template should they use as a starting point?
Select an answer first - 9
Which Azure Synapse Analytics feature is used to execute PySpark code for data exploration and transformation?
Select an answer first - 10
A data engineering team needs to provide both SQL and Python-based exploration of a large dataset in Azure Data Lake Storage Gen2. The team wants to minimize compute costs while allowing multiple analysts to run queries concurrently. They also need to support both T-SQL and PySpark notebooks. What should they do?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.