Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5
DP-203 Design and implement data storage Practice Question
Drag and drop the steps to configure Azure Synapse Analytics serverless SQL pool to query data in Azure Data Lake Storage Gen2 into the correct order.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Set up the storage account and data, then create the serverless SQL pool, then create a database, then create an external data source referencing the storage, and finally create an external file format and external table.
First, set up the storage account and data. Then create the serverless SQL pool, a database, external data source referencing the storage, and finally external file format and external table to query.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Set up the storage account and data, then create the serverless SQL pool, then create a database, then create an external data source referencing the storage, and finally create an external file format and external table.
Why this is correct
This is the correct order because the storage and data must exist first. Then the serverless SQL pool is used to create a database. Within the database, an external data source must reference the storage location. Finally, an external file format (if needed) and external table are created to query the data.
- ✗
Create the serverless SQL pool, then set up the storage account and data, then create a database, then create an external data source, and finally create an external table.
Why it's wrong here
This is incorrect because the storage account must be set up before creating the external data source that references it. Also, creating the serverless SQL pool before setting up storage is possible but placing storage after pool is illogical as the data source needs the storage.
- ✗
Create a database, then create an external data source, then create an external file format, then create an external table, and finally set up the storage account and data.
Why it's wrong here
This is incorrect because the external data source and table depend on the storage account and data existing first. You cannot create an external data source referencing a non-existent storage location.
- ✗
Set up the storage account and data, then create a database, then create an external data source, then create an external file format, then create an external table, and finally create the serverless SQL pool.
Why it's wrong here
This is incorrect because the serverless SQL pool must exist before creating a database in it. Also, the database is created within the serverless SQL pool, so the pool should be created before the database.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.