Courseiva

DP-203 · topic practice

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

Practise Microsoft Azure Data Engineer Associate DP-203 Secure, monitor, and optimize data storage and data processing practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
20 questionsDomain: Secure, monitor, and optimize data storage and data processing
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Secure, monitor, and optimize data storage and data processing

Secure, monitor, and optimize data storage and data processing questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Secure, monitor, and optimize data storage and data processing exam traps

  • ▸Answering from memory before reading the full scenario.
  • ▸Missing a constraint such as cost, availability, security, scope or command context.
  • ▸Choosing a broad answer when the question asks for the most specific fix.
  • ▸Ignoring why the wrong options are tempting.

Practice set

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

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Your organization uses Azure Synapse Analytics dedicated SQL pool. You need to ensure that all data at rest in the SQL pool is encrypted using a customer-managed key stored in Azure Key Vault. What should you configure?

Question 2hardmultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You are designing a data processing solution in Azure Databricks that uses Unity Catalog. The security team requires that all users authenticate using Microsoft Entra ID and that access to tables is governed by attribute-based access control (ABAC) using table tags. Which feature should you enable?

Question 3easymultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Your team uses Azure Data Factory to copy data from on-premises SQL Server to Azure Blob Storage. You need to ensure that data in transit is encrypted using TLS 1.2. What should you configure?

Question 4mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You have an Azure Databricks workspace that uses a managed resource group. The security team requires that all cluster nodes use no public IP addresses and that all outbound traffic goes through a firewall. What should you configure?

Question 5hardmultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Refer to the exhibit. You are creating an Azure Storage account using an ARM template with the above snippet. After deployment, a security auditor reviews the configuration and notes that the storage account is not using a customer-managed key for encryption. What is the most likely reason?

Exhibit

Refer to the exhibit.

{
  "properties": {
    "encryption": {
      "keySource": "Microsoft.Keyvault",
      "keyVaultProperties": {
        "keyName": "mykey",
        "keyVersion": "",
        "keyVaultUri": "https://myvault.vault.azure.net/"
      },
      "infrastructureEncryption": "Enabled"
    }
  }
}
Question 6mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You are monitoring an Azure Synapse Analytics dedicated SQL pool and notice that some queries are taking longer than expected. You need to identify queries that are experiencing significant memory pressure. Which dynamic management view (DMV) should you query?

Question 7hardmultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Your organization uses Azure Data Lake Storage Gen2 with hierarchical namespace enabled. You need to grant a service principal read and write access to a specific directory without granting access to the parent directories. What should you use?

Question 8easymultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You have an Azure Stream Analytics job that writes output to Azure Synapse Analytics. You need to ensure that the job can authenticate to Synapse Analytics using a managed identity. What should you do?

Question 9mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Your team uses Azure Data Factory to orchestrate data movement. You need to monitor pipeline runs and set up alerts when a pipeline fails more than three times in an hour. What is the most efficient approach?

Question 10hardmulti select
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You are optimizing the performance of an Azure Synapse Analytics dedicated SQL pool. Which TWO actions can help reduce data movement during query execution?

Question 11easymulti select
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You need to secure access to an Azure Data Lake Storage Gen2 account. Which THREE methods can you use to authenticate and authorize access?

Question 12mediummulti select
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You are monitoring the performance of an Azure Data Factory pipeline that uses a Copy activity to load data into Azure Synapse Analytics. Which THREE metrics should you monitor to identify potential performance bottlenecks?

Question 13hardmultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Refer to the exhibit. You are reviewing the workload classifier configuration for an Azure Synapse Analytics dedicated SQL pool. You notice that the 'HeavyLoader' classifier has a queryExecutionTimeoutSeconds of 0. What is the implication of this setting?

Exhibit

Refer to the exhibit.

GET https://mysynapse.azuresynapse.net/monitoring/workloadManagement/workloadClassifiers?api-version=2020-12-01

Response:
{
  "value": [
    {
      "name": "HeavyLoader",
      "properties": {
        "memberName": "LoaderGroup",
        "wlmContext": {
          "importance": "high",
          "minPercentageResource": 30,
          "maxPercentageResource": 100,
          "capPercentageResource": 60,
          "queryExecutionTimeoutSeconds": 0
        }
      }
    },
    {
      "name": "ReportUser",
      "properties": {
        "memberName": "ReportGroup",
        "wlmContext": {
          "importance": "normal",
          "minPercentageResource": 10,
          "maxPercentageResource": 100,
          "capPercentageResource": 50,
          "queryExecutionTimeoutSeconds": 3600
        }
      }
    }
  ]
}
Question 14mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

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 15easymultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You have an Azure Synapse Analytics serverless SQL pool. You need to monitor the number of queries that are currently executing. Which dynamic management view should you query?

Question 16mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Your team is using Azure Synapse Analytics to process sensitive customer data. You need to ensure that column-level security is applied to a specific table so that only users with a certain role can view certain columns. Which feature should you use?

Question 17hardmultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

An Azure Data Factory pipeline runs multiple times daily, loading data from an on-premises SQL Server to Azure Blob Storage. You notice that the pipeline sometimes fails due to transient network errors. You need to implement a retry policy with exponential backoff. Which configuration should you apply?

Question 18mediummultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You are designing a solution to monitor the performance of Azure Synapse Analytics dedicated SQL pools. You need to identify queries that are consuming more than 100 GB of memory and have been running for more than 30 minutes. Which DMV should you query?

Question 19easymultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

Your company uses Azure Blob Storage to store backups. You need to ensure that data is encrypted at rest using a customer-managed key stored in Azure Key Vault. Which feature should you enable?

Question 20hardmultiple choice
Read the full Secure, monitor, and optimize data storage and data processing explanation →

You are optimizing an Azure Synapse Analytics dedicated SQL pool. A frequent query scans a large fact table and filters on a date column. You notice that the query uses a full table scan. What is the most effective way to improve query performance?

Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Secure, monitor, and optimize data storage and data processing sessions

Start a Secure, monitor, and optimize data storage and data processing only practice session

Every question in these sessions is drawn from the Secure, monitor, and optimize data storage and data processing domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Secure, monitor, and optimize data storage and data processing questions →Mixed DP-203 session

Related practice questions

Related DP-203 topic practice pages

Move into related areas when this topic feels solid.

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

Practise DP-203 questions linked to Secure, monitor, and optimize data storage and data processing.

Design and develop data processing practice questions

Practise DP-203 questions linked to Design and develop data processing.

Design and implement data security practice questions

Practise DP-203 questions linked to Design and implement data security.

Monitor and optimize data storage and processing practice questions

Practise DP-203 questions linked to Monitor and optimize data storage and processing.

Design and implement data storage practice questions

Practise DP-203 questions linked to Design and implement data storage.

Develop data processing practice questions

Practise DP-203 questions linked to Develop data processing.

DP-203 fundamentals practice questions

Practise DP-203 questions linked to DP-203 fundamentals.

DP-203 scenario practice questions

Practise DP-203 questions linked to DP-203 scenario.

DP-203 troubleshooting practice questions

Practise DP-203 questions linked to DP-203 troubleshooting.

Frequently asked questions

What does the DP-203 exam test about Secure, monitor, and optimize data storage and data processing?
Secure, monitor, and optimize data storage and data processing questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Secure, monitor, and optimize data storage and data processing questions in a focused session?
Yes — the session launcher on this page draws every question from the Secure, monitor, and optimize data storage and data processing domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other DP-203 topics?
Use the topic links above to move to related areas, or go back to the DP-203 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the DP-203 exam covers. They are not copied from any real exam or dump site.