Azure Data Engineer DP-203 Practice

Q: How many questions are in this practice set?

This practice set contains 60 questions with detailed explanations.

Q: What topics does this practice cover?

It covers the key topics and question types for Microsoft Azure Data Engineer Associate (DP-203), including vocabulary, grammar, reading, and practical test skills.

Q: Are there explanations for every question?

Yes, every question includes a clear explanation so you can understand the correct answer and learn from mistakes.

Q: Can I save my progress and mistakes?

Your wrong answers, favorites, scores, and study streak are saved in your browser, so you can review them on the same device.

Q: What practice modes are available?

You can practice randomly, take a timed mock exam, filter by difficulty, type, and topic, search questions, and review wrong answers.

Practice 60 original Microsoft DP-203 questions covering storage, transformation, pipelines, security, monitoring, and Synapse, with detailed explanations.

Level: Microsoft Azure Data Engineer Associate (DP-203) Difficulty: advanced 60 questions 60 min

Choose a practice mode, answer each Azure DP-203 question, then review the explanation. Wrong answers are saved locally for review.

Practice mode Difficulty Topic Question type Search questions

Day streak: 0 days Saved only on this device

Question 1

Which Azure service stores unstructured data such as JSON and CSV files?

Select an answer Azure DatabricksAzure Blob StorageAzure SQL DatabaseAzure Cosmos DB

Question 2

Which Azure service ingests large volumes of streaming events?

Select an answer Azure Event HubsAzure SQL DatabaseAzure Blob StorageAzure App Service

Question 3

Which Azure service ingests telemetry from IoT devices?

Select an answer Azure SynapseAzure Table StorageAzure IoT HubAzure Data Lake

Question 4

Which Azure service copies and transforms data between systems?

Select an answer Azure DNSAzure CDNAzure Front DoorAzure Data Factory

Question 5

What is a data lake?

Select an answer A relational databaseA message queueA virtual networkA repository that stores raw data in native formats

Question 6

What does ELT mean?

Select an answer Extract, load, and then transform dataEncrypt, log, and transmitEvaluate, link, and testExport, label, and truncate

Question 7

What is a partition key in Azure storage?

Select an answer A DNS recordA key that distributes data for scale and performanceAn encryption keyA password

Question 8

What is a sink in a data pipeline?

Select an answer A transformationA triggerThe destination where data is writtenThe source of data

Question 9

What is a source in a data pipeline?

Select an answer A transformationA scheduleThe origin from which data is readThe destination

Question 10

Match each data ingestion concept to its purpose.

Azure Blob StorageAzure Event HubsAzure Data FactoryData lake

Question 11

Which Azure service runs Apache Spark transformations?

Select an answer Azure DNSAzure CDNAzure Front DoorAzure Databricks

Question 12

Which Azure Synapse capability runs SQL transformations?

Select an answer Synapse LinkSynapse SQLSynapse SparkSynapse Pipelines

Question 13

What is a mapping data flow?

Select an answer A visual ETL transformation in Azure Data FactoryA SQL tableA dashboardA streaming event

Question 14

What is a notebook in data engineering?

Select an answer A pipeline triggerA storage accountA code environment for interactive analysis and transformationA database table

Question 15

What is a streaming query?

Select an answer A stored procedureA query that processes data as it arrivesA batch queryA SQL view

Question 16

What is a window function in analytics?

Select an answer A storage containerA firewall ruleA load balancerA function that aggregates over a defined set of rows

Question 17

What is a dimension table?

Select an answer A table of raw eventsA backupA pipelineA table with descriptive attributes for analysis

Question 18

What is a fact table?

Select an answer A notebookA table with measurable events and foreign keysA dimension tableA dashboard

Question 19

What is data quality?

Select an answer The degree to which data is accurate, complete, and reliableThe data sizeThe pipeline costThe storage tier

Question 20

Match each transformation concept to its purpose.

Azure DatabricksSynapse SQLMapping data flowNotebook

Question 21

Which Azure service orchestrates data pipelines?

Select an answer Azure DNSAzure CDNAzure Data FactoryAzure Blob Storage

Question 22

What is a pipeline in Azure Data Factory?

Select an answer A storage containerA virtual machineA DNS zoneA sequence of activities that perform data work

Question 23

What is an activity in a pipeline?

Select an answer A step that performs a defined operationA storage accountA triggerA dashboard

Question 24

What is a trigger in Azure Data Factory?

Select an answer A connectorAn event or schedule that starts a pipelineA data transformationA table

Question 25

What is a linked service?

Select an answer A triggerConnection information for a data source or destinationA data tableA pipeline run

Question 26

What is a dataset in Azure Data Factory?

Select an answer A reference to the structure and location of dataA virtual machineA DNS recordA firewall rule

Question 27

What is a pipeline run?

Select an answer A storage tierA tableA trigger scheduleAn execution of a pipeline

Question 28

What is a checkpoint in streaming?

Select an answer A storage accountA load balancerSaved state that lets a job resume after failureA data source

Question 29

What is idempotency in data pipelines?

Select an answer Running a job again safely without duplicating resultsEncrypting dataScaling computeScheduling a job

Question 30

Match each pipeline concept to its purpose.

PipelineActivityTriggerLinked service

Question 31

Which Azure service securely stores secrets and keys?

Select an answer Azure Blob StorageAzure SQL DatabaseAzure CDNAzure Key Vault

Question 32

What is a managed identity in Azure?

Select an answer A firewall ruleA DNS recordAn Azure-managed identity that services use to access resourcesA user password

Question 33

What is encryption at rest?

Select an answer Deleting dataEncrypting data stored on diskEncrypting data in transitHiding data values

Question 34

What is encryption in transit?

Select an answer Encrypting data while it travels between systemsEncrypting stored filesMasking secretsBacking up data

Question 35

What is a private endpoint?

Select an answer A firewall ruleA DNS recordA private network address for accessing a serviceA public IP address

Question 36

What is dynamic data masking?

Select an answer Deleting dataEncrypting keysScaling databasesHiding sensitive values from query results

Question 37

Which Azure service catalogs and governs data assets?

Select an answer Azure DNSMicrosoft PurviewAzure CDNAzure Front Door

Question 38

What is Azure RBAC?

Select an answer Role-based access control for Azure resourcesA network firewallA backup policyA DNS zone

Question 39

What is a data lineage?

Select an answer A storage tierA pipeline triggerA database indexTracking where data comes from and how it changes

Question 40

Match each security concept to its purpose.

Azure Key VaultManaged identityPrivate endpointMicrosoft Purview

Question 41

Which Azure service monitors pipeline runs and metrics?

Select an answer Azure MonitorAzure DNSAzure CDNAzure Front Door

Question 42

What is a metric in Azure Monitor?

Select an answer An alertA dashboardA numeric measure collected over timeA log entry

Question 43

What is a log in Azure Monitor?

Select an answer A virtual machineA storage accountA record of an event or activityA numeric metric

Question 44

What is an alert in Azure Monitor?

Select an answer A pipeline activityA notification triggered by a conditionA log entryA data table

Question 45

What is a diagnostic setting?

Select an answer A firewall ruleA backup planA DNS recordA configuration that routes logs and metrics to destinations

Question 46

What is cost optimization in data engineering?

Select an answer Reducing waste while meeting performance needsDeleting all dataDisabling monitoringIncreasing storage

Question 47

What are hot and cool access tiers?

Select an answer Security rolesStorage tiers for frequent and infrequent accessCompute sizesPipeline modes

Question 48

What is query performance insight?

Select an answer A storage tierA firewallA backupTools that identify slow or expensive queries

Question 49

What is capacity planning?

Select an answer Rotating keysMasking valuesEstimating resources needed for expected workloadsDeleting data

Question 50

Match each monitoring concept to its purpose.

Azure MonitorAlertDiagnostic settingMetric

Question 51

Which Azure service unifies data warehousing and big data analytics?

Select an answer Azure CDNAzure Synapse AnalyticsAzure Blob StorageAzure DNS

Question 52

What is a SQL pool in Synapse?

Select an answer A storage containerA Spark jobA pipelineA relational data warehouse compute resource

Question 53

What is an Apache Spark pool in Synapse?

Select an answer Managed Spark compute for large-scale processingA SQL databaseA storage accountA trigger

Question 54

What is a Synapse pipeline?

Select an answer A notebookA tableOrchestration that moves and transforms dataA dashboard

Question 55

What is a lake database in Synapse?

Select an answer A virtual networkA firewallA schema applied to data lake filesA relational SQL database

Question 56

What is a dedicated SQL pool?

Select an answer A storage tierA provisioned warehouse with reserved computeAn on-demand query engineA Spark cluster

Question 57

What is a serverless SQL pool?

Select an answer A provisioned warehouseA Spark jobA pipelineAn on-demand query engine for files in the data lake

Question 58

What is a Synapse workspace?

Select an answer A central resource that contains pools, pipelines, and dataA storage containerA DNS zoneA firewall

Question 59

What is a data flow in Synapse?

Select an answer A triggerA visual transformation activityA backupA virtual machine

Question 60

Match each Synapse component to its purpose.

WorkspaceDedicated SQL poolServerless SQL poolSpark pool