Courseiva
← Back to Microsoft Azure Data Engineer Associate DP-203 questions

Scenario-based practice

Refer to the Exhibit Practice Questions

Practise Microsoft Azure Data Engineer Associate DP-203 practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

Start full practice testRead exam guide
15
scenario questions
DP-203
exam code
Microsoft
vendor

Scenario guide

How to approach refer to the exhibit practice questions

Practise exhibit-style questions that ask you to read a topology, table, command output or diagram before choosing the best answer.

Quick answer

Exhibit-style questions test whether you can read a topology, command output, diagram or table before choosing the best answer.

How to extract the relevant detail from an exhibit.

How topology, command output or routing information affects the answer.

How to avoid answering from memory before reading the evidence.

How to map the exhibit back to the exam objective.

Related practice questions

Related DP-203 topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Secure, monitor, and optimize data storage and data processing practice questions

Sharpen your DP-203 knowledge of Secure, monitor, and optimize data storage and data processing.

Design and implement data storage practice questions

Targeted DP-203 practice covering Design and implement data storage.

Develop data processing practice questions

Targeted DP-203 practice covering Develop data processing.

DP-203 fundamentals practice questions

Targeted DP-203 practice covering DP-203 fundamentals.

DP-203 scenario practice questions

Work through DP-203 questions on DP-203 scenario.

DP-203 troubleshooting practice questions

Targeted DP-203 practice covering DP-203 troubleshooting.

Practice set

Practice scenarios

Question 1mediummultiple choice
Full question →

You are reviewing a copy job configuration in Azure Data Factory that copies Parquet files from Azure Data Lake Storage Gen2 to Azure Synapse Analytics. The exhibit shows the job settings. If the source folder contains a file that is not in Parquet format (e.g., a CSV file), what will happen?

Exhibit

Refer to the exhibit.

```json
{
  "data": [
    {
      "name": "order_data",
      "path": "orders/*.parquet",
      "partitionBy": ["year", "month", "day"],
      "format": "parquet",
      "options": {
        "compression": "snappy"
      }
    }
  ],
  "source": {
    "provider": "AzureDataLakeStorage",
    "connectionString": "DefaultEndpointsProtocol=https;AccountName=storagedatalake;AccountKey=...;EndpointSuffix=core.windows.net",
    "container": "data"
  },
  "sink": {
    "provider": "AzureSynapseAnalytics",
    "table": "dbo.orders",
    "staging": {
      "linkedServiceName": "AzureDataLakeStorage",
      "folderPath": "staging"
    }
  },
  "copyBehavior": "MergeFiles",
  "faultTolerance": {
    "skipIncompatibleFiles": true,
    "skipIncompatibleRows": true
  }
}
```
Question 2hardmultiple choice
Full question →

Refer to the exhibit. The pipeline fails with a 'Type mismatch' error. The source file has a column 'Name' of type String, and the destination table expects 'FullName' of type String. What is the most likely cause of the failure?

Exhibit

{
  "type": "Microsoft.DataFactory/factories/pipelines",
  "properties": {
    "activities": [
      {
        "name": "CopyData",
        "type": "Copy",
        "policy": {
          "retry": 2,
          "timeout": "0:10:00"
        },
        "inputs": [
          {
            "referenceName": "DelimitedTextInput",
            "type": "DatasetReference"
          }
        ],
        "outputs": [
          {
            "referenceName": "ParquetOutput",
            "type": "DatasetReference"
          }
        ],
        "typeProperties": {
          "source": {
            "type": "DelimitedTextSource",
            "storeSettings": {
              "type": "AzureBlobStorageReadSettings",
              "recursive": true
            }
          },
          "sink": {
            "type": "ParquetSink",
            "storeSettings": {
              "type": "AzureBlobFSWriteSettings"
            },
            "formatSettings": {
              "type": "ParquetWriteSettings"
            }
          },
          "translator": {
            "type": "TabularTranslator",
            "mappings": [
              {
                "source": {
                  "name": "Name",
                  "type": "String"
                },
                "sink": {
                  "name": "FullName",
                  "type": "String"
                }
              }
            ]
          }
        }
      }
    ]
  }
}
Question 3mediummultiple choice
Full question →

Refer to the exhibit. You are monitoring the CopyDataPipeline in Azure Data Factory. The copy activity is failing with timeout errors. What is the most likely cause?

Exhibit

Refer to the exhibit.

{
    "name": "CopyDataPipeline",
    "properties": {
        "activities": [
            {
                "name": "CopyFromBlobToSQL",
                "type": "Copy",
                "inputs": [
                    {
                        "referenceName": "BlobDataset",
                        "type": "DatasetReference"
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "SQLDataset",
                        "type": "DatasetReference"
                    }
                ],
                "typeProperties": {
                    "source": {
                        "type": "BlobSource",
                        "recursive": true
                    },
                    "sink": {
                        "type": "SqlSink",
                        "writeBatchSize": 10000,
                        "writeBatchTimeout": "00:00:30",
                        "sqlWriterUseTableLock": true
                    },
                    "enableStaging": false
                }
            }
        ]
    }
}
Question 4mediummultiple choice
Full question →

Refer to the exhibit. You are configuring an Azure Purview data policy for Azure Storage. The policy above is intended to audit all access events. However, the security team complains that not all read events are being audited. What is the most likely reason?

Exhibit

Refer to the exhibit.

{
  "properties": {
    "rules": [
      {
        "name": "AuditPolicy",
        "description": "Audit all events",
        "ruleState": "Enabled",
        "source": {
          "include": ["*"],
          "exclude": []
        },
        "target": {
          "include": ["*"],
          "exclude": []
        },
        "filter": {
          "predicate": "true"
        },
        "actions": [
          {
            "actionGroup": "ALL_ACTIONS"
          }
        ]
      }
    ]
  }
}
Question 5hardmultiple choice
Full question →

Refer to the exhibit. A Bicep file is used to deploy an Azure Synapse Analytics workspace. What is the purpose of the 'purviewConfiguration' property?

Exhibit

Refer to the exhibit.

{
  "properties": {
    "dataLakeStorageAccountDetails": [
      {
        "accountUrl": "https://mystorageaccount.dfs.core.windows.net"
      }
    ],
    "defaultDataLakeStorage": {
      "accountUrl": "https://mystorageaccount.dfs.core.windows.net",
      "filesystem": "synapseworkspace"
    },
    "sqlAdministratorLogin": "adminuser",
    "sqlAdministratorLoginPassword": "",
    "managedResourceGroupName": "managedRG",
    "purviewConfiguration": {
      "purviewResourceId": "/subscriptions/sub-id/resourceGroups/rg/providers/Microsoft.Purview/accounts/purview-account"
    },
    "encryption": {
      "cmk": {
        "key": {
          "name": "cmk-key",
          "keyVaultUrl": "https://kv.vault.azure.net/"
        }
      }
    }
  }
}
Question 6hardmultiple choice
Full question →

Refer to the exhibit. A data engineer runs a pipeline copy activity and gets this error. What is the most likely cause of the failure?

Network Topology
workspace-name synw-devsubscription 123-456resource-group rg-synapserun-id 12345"pipelineName": "CopyDataPipeline","runStart": "2024-03-15T10:00:00Z","runEnd": "2024-03-15T10:05:30Z","status": "Failed","parameters": {},"runDimension": {},"error": {"code": "IntegrationRuntimeNotReady","failureType": "UserError","target": "CopyDataPipeline","details": []
Question 7hardmultiple choice
Full question →

Refer to the exhibit. You have an Azure Data Factory pipeline that copies data from a CSV file in Blob Storage to a Synapse dedicated SQL pool table named dbo.Sales. The pipeline fails. The error message indicates that the 'Amount' column in the sink table does not allow NULLs but the source contains NULL values. What is the best way to resolve this issue without losing data?

Exhibit

{
  "name": "CopyDataFromBlobToSynapse",
  "properties": {
    "activities": [
      {
        "name": "CopyData",
        "type": "Copy",
        "inputs": [{"referenceName": "BlobSource", "type": "DatasetReference"}],
        "outputs": [{"referenceName": "SynapseSink", "type": "DatasetReference"}],
        "typeProperties": {
          "source": {
            "type": "DelimitedTextSource",
            "storeSettings": {
              "type": "AzureBlobStorageReadSettings",
              "recursive": true
            }
          },
          "sink": {
            "type": "SqlPoolSink",
            "writeBatchSize": 10000,
            "preCopyScript": "TRUNCATE TABLE dbo.Sales"
          },
          "translator": {
            "type": "TabularTranslator",
            "mappings": [
              {"source": "ProductID", "sink": "ProductID"},
              {"source": "SaleDate", "sink": "SaleDate"},
              {"source": "Quantity", "sink": "Quantity"},
              {"source": "Amount", "sink": "Amount"}
            ]
          }
        }
      }
    ]
  }
}
Question 8hardmultiple choice
Full question →

Refer to the exhibit. You submit a Spark job in Azure Synapse Analytics using the Azure CLI. The job runs slowly during the shuffle phase. The input data is about 200 GB. Which configuration change would best improve performance for this shuffle-heavy workload?

Network Topology
name MyJobfile abfss://container@storage.dfs.core.windows.net/path/etl.pyexecutor-size Smallexecutors 2conf spark.sql.shuffle.partitions=400"
Question 9easymultiple choice
Full question →

You are an administrator for an Azure Synapse Analytics dedicated SQL pool. You execute the T-SQL statements shown in the exhibit. The external table 'dbo.Orders' is created. Which statement about querying this external table is true?

Exhibit

Refer to the exhibit.

```sql
CREATE EXTERNAL DATA SOURCE MyDataSource
WITH (
    LOCATION = 'abfss://data@storagedatalake.dfs.core.windows.net',
    TYPE = HADOOP,
    CREDENTIAL = MyCredential
);

CREATE EXTERNAL FILE FORMAT MyFileFormat
WITH (
    FORMAT_TYPE = PARQUET,
    DATA_COMPRESSION = 'org.apache.hadoop.io.compress.SnappyCodec'
);

CREATE EXTERNAL TABLE dbo.Orders (
    OrderID INT,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10,2)
)
WITH (
    LOCATION = '/orders/',
    DATA_SOURCE = MyDataSource,
    FILE_FORMAT = MyFileFormat
);
```
Question 10hardmultiple choice
Full question →

Refer to the exhibit. You are reviewing an ARM template for an Azure Data Lake Storage Gen2 account. Which of the following security best practices is violated in this template?

Exhibit

Refer to the exhibit.

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "resources": [
    {
      "type": "Microsoft.Storage/storageAccounts",
      "apiVersion": "2022-09-01",
      "name": "[parameters('storageAccountName')]",
      "location": "[resourceGroup().location]",
      "kind": "StorageV2",
      "sku": {
        "name": "Standard_LRS"
      },
      "properties": {
        "supportsHttpsTrafficOnly": false,
        "minimumTlsVersion": "TLS1_0",
        "isHnsEnabled": true
      }
    }
  ]
}
Question 11easymultiple choice
Full question →

Refer to the exhibit. You run the Kusto query in Azure Monitor Logs to analyze Data Factory pipeline runs. What is the purpose of this query?

Exhibit

Refer to the exhibit.

KQL query:
AzureDiagnostics
| where ResourceProvider == "MICROSOFT.DATAFACTORY"
| where Category == "ActivityRuns"
| where Status == "Failed"
| summarize count() by PipelineName, bin(TimeGenerated, 1h)
| order by count_ desc
Question 12mediummultiple choice
Full question →

You are reviewing an Azure Resource Manager template for an Azure SQL Database auditing policy. Based on the exhibit, which of the following is true?

Exhibit

Refer to the exhibit.

{
    "Name": "audit-policy",
    "Type": "Microsoft.Sql/servers/auditingSettings",
    "ApiVersion": "2021-11-01",
    "Properties": {
        "state": "Enabled",
        "storageEndpoint": "https://auditlogs.blob.core.windows.net",
        "retentionDays": 90,
        "auditActionsAndGroups": [
            "DATABASE_LOGOUT_GROUP",
            "DATABASE_ROLE_MEMBER_CHANGE_GROUP"
        ]
    }
}
Question 13mediummultiple choice
Full question →

Refer to the exhibit. A data engineer wants to copy only new orders from an Azure SQL database to Azure Data Lake Storage Gen2. The pipeline runs daily at midnight. What should be added to the pipeline to ensure incremental loads?

Exhibit

{
  "name": "CopyDataPipeline",
  "properties": {
    "activities": [
      {
        "name": "CopyData",
        "type": "Copy",
        "inputs": [{"name": "InputDataset"}],
        "outputs": [{"name": "OutputDataset"}],
        "typeProperties": {
          "source": {
            "type": "AzureSqlSource",
            "sqlReaderQuery": "SELECT * FROM Orders WHERE OrderDate > '2024-01-01'"
          },
          "sink": {
            "type": "DelimitedTextSink",
            "storeSettings": {
              "type": "AzureBlobFSWriteSettings",
              "copyBehavior": "PreserveHierarchy"
            }
          },
          "enableStaging": false,
          "translator": {
            "type": "TabularTranslator",
            "columnMappings": {
              "OrderID": "order_id",
              "CustomerID": "customer_id",
              "OrderDate": "order_date"
            }
          }
        }
      }
    ]
  }
}
Question 14mediummultiple choice
Full question →

Refer to the exhibit. A data engineer creates an external table in Azure Synapse Analytics pointing to Parquet files in ADLS Gen2. The query 'SELECT * FROM Sales' returns 0 rows, but the files exist. What is the most likely cause?

Exhibit

Azure Synapse Analytics CREATE EXTERNAL TABLE statement:

CREATE EXTERNAL TABLE [dbo].[Sales]
(
    [SaleID] int,
    [ProductID] int,
    [SaleDate] datetime2(7),
    [Quantity] int,
    [Amount] decimal(10,2)
)
WITH
(
    LOCATION = 'sales/2024/03/',
    DATA_SOURCE = [ADLS_DataSource],
    FILE_FORMAT = [ParquetFormat]
);

CREATE EXTERNAL FILE FORMAT [ParquetFormat]
WITH (
    FORMAT_TYPE = PARQUET,
    DATA_COMPRESSION = 'org.apache.hadoop.io.compress.SnappyCodec'
);

CREATE EXTERNAL DATA SOURCE [ADLS_DataSource]
WITH (
    TYPE = HADOOP,
    LOCATION = 'abfss://container@storage.dfs.core.windows.net',
    CREDENTIAL = [StorageCredential]
);
Question 15hardmultiple choice
Full question →

You deploy the Azure Security Center automation shown in the exhibit. What is the purpose of this automation?

Exhibit

Refer to the exhibit.

{
  "type": "Microsoft.Security/automations",
  "apiVersion": "2020-01-01",
  "properties": {
    "description": "Monitor for high-severity alerts",
    "isEnabled": true,
    "actions": [
      {
        "actionType": "EventHub",
        "eventHubResourceId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.EventHub/namespaces/ehns1/eventhubs/eh1",
        "connectionString": "Endpoint=sb://..."
      }
    ],
    "scopes": [
      "/subscriptions/.../resourceGroups/rg1"
    ],
    "sources": [
      {
        "ruleId": "HighSeverityAlerts",
        "severity": "High"
      }
    ]
  }
}

These DP-203 practice questions are part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style DP-203 questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.