Courseiva
← Back to Microsoft Azure Database Administrator Associate DP-300 questions

Scenario-based practice

Hard Difficulty Questions

Practise Microsoft Azure Database Administrator Associate DP-300 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
20
scenario questions
DP-300
exam code
Microsoft
vendor

Scenario guide

How to approach hard difficulty questions

These are the questions most candidates get wrong. They require connecting multiple concepts, reading tricky output, or knowing edge-case behaviour that isn't on most study cards. Practising them trains you to operate under uncertainty — a necessary skill on the real exam.

Quick answer

Hard Difficulty Questions 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.

Related practice questions

Related DP-300 topic practice pages

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

Plan and configure a high availability and disaster recovery environment practice questions

Targeted DP-300 practice covering Plan and configure a high availability and disaster recovery environment.

Plan and implement data platform resources practice questions

Targeted DP-300 practice covering Plan and implement data platform resources.

Monitor, configure, and optimize database resources practice questions

Monitor, configure, and optimize database resources practice questions for DP-300.

Configure and manage automation of tasks practice questions

Work through DP-300 questions on Configure and manage automation of tasks.

Plan and configure high availability and disaster recovery practice questions

Plan and configure high availability and disaster recovery practice questions for DP-300.

Implement a secure environment practice questions

Sharpen your DP-300 knowledge of Implement a secure environment.

DP-300 fundamentals practice questions

Targeted DP-300 practice covering DP-300 fundamentals.

DP-300 scenario practice questions

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

DP-300 troubleshooting practice questions

Targeted DP-300 practice covering DP-300 troubleshooting.

Practice set

Practice scenarios

Question 1hardmultiple choice
Full question →

You run the query in the exhibit on an Azure SQL Database. The result shows high wait_time_ms for PAGEIOLATCH_SH waits. What does this indicate?

Exhibit

Refer to the exhibit.
SELECT 
  wait_type,
  wait_time_ms,
  waiting_tasks_count
FROM sys.dm_os_wait_stats
WHERE wait_type = 'PAGEIOLATCH_SH'
ORDER BY wait_time_ms DESC;
Question 2hardmultiple choice
Full question →

You have an Azure SQL Managed Instance with a large number of databases. You need to monitor the storage space used by each database to proactively manage capacity. Which tool should you use?

Question 3hardmulti select
Full question →

You are configuring security for an Azure SQL Managed Instance. The instance will host a critical application that requires always encrypted with secure enclaves. Which TWO actions must you take to support this feature? (Choose two.)

Question 4hardmultiple choice
Full question →

A retail company is migrating its on-premises SQL Server database to Azure SQL Database. The database has a table with 500 million rows and receives 10,000 INSERT operations per second during peak hours. The application requires read-committed snapshot isolation. Which Azure SQL Database tier and configuration should the DBA recommend to minimize cost while meeting performance requirements?

Question 5hardmultiple choice
Full question →

You are reviewing an Azure SQL Database audit policy configuration. The policy is set to audit successful and failed database authentication events. You notice that audit logs are being written to both Azure Blob Storage and Azure Monitor. However, you are concerned about security of the storage account access key in the policy. What is the recommended approach to securely reference the storage account?

Exhibit

Refer to the exhibit.
```json
{
  "properties": {
    "name": "myAuditPolicy",
    "type": "Microsoft.Sql/servers/databases/auditingSettings",
    "apiVersion": "2023-02-01-preview",
    "properties": {
      "state": "Enabled",
      "auditActionsAndGroups": [
        "SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
        "FAILED_DATABASE_AUTHENTICATION_GROUP"
      ],
      "storageEndpoint": "https://mystorage.blob.core.windows.net",
      "storageAccountAccessKey": "...",
      "retentionDays": 90,
      "isAzureMonitorTargetEnabled": true
    }
  }
}
```
Question 6hardmultiple choice
Full question →

Your company uses Azure SQL Database with the Hyperscale service tier. You notice that the database is experiencing high I/O latency during peak hours. After analyzing the query performance, you determine that the primary bottleneck is due to log write throughput. You need to reduce log write latency without changing the service tier. What should you do?

Question 7hardmulti select
Full question →

You are configuring performance optimization for an Azure SQL Database that uses the Hyperscale service tier. The database has heavy read-write workloads. Which THREE actions should you take to optimize performance?

Question 8hardmultiple choice
Full question →

Refer to the exhibit. An administrator is trying to perform a point-in-time restore for a managed instance database. The output shows the state of the instance and databases. What is the most likely reason db1 shows 'Restoring' status?

Network Topology
az sql mi showresource-group rg1name mi1az sql midb listmi mi1query 'properties.state'query '[].{Name:namedatabase db1"Ready""Name": "db1","Status": "Restoring"},"Name": "db2","Status": "Online""name": "db1_20230315_1030","recoveryPointId": "123456","time": "2023-03-15T10:30:00Z"
Question 9hardmulti select
Full question →

You are monitoring an Azure SQL Database using Query Performance Insight and notice that a specific query has a high average duration and high CPU usage. The query plan shows a clustered index scan on a large table. Which two actions should you take to optimize performance? (Choose two.)

Question 10hardmulti select
Full question →

Which THREE factors should you consider when choosing between vCore and DTU purchase models for Azure SQL Database performance optimization?

Question 11hardmultiple choice
Full question →

You are automating the scaling of an Azure SQL Database based on workload patterns. The database uses the DTU purchasing model. You need to ensure that scaling actions do not cause connection drops. Which scaling method should you use?

Question 12hardmulti select
Full question →

Which THREE components are required to configure a failover group for Azure SQL Database? (Choose three.)

Question 13hardmultiple choice
Full question →

You have an Azure SQL Managed Instance configured with a failover group for disaster recovery. The primary instance is in the East US region and the secondary is in West US. You need to perform a planned failover for maintenance with zero data loss. What is the correct sequence of steps?

Question 14hardmultiple choice
Full question →

You have a SQL Server on Azure VM that is part of a failover cluster instance (FCI). The cluster nodes are in an availability set. You need to ensure that the database can tolerate a complete Azure region failure. What should you add to the current architecture?

Question 15hardmultiple choice
Full question →

Your company has a SQL Server on Azure VM hosting a critical database. You need to ensure high availability with automatic failover and no data loss during a planned patching event. The solution must minimize cost. Which configuration should you use?

Question 16hardmulti select
Full question →

Your company uses Azure SQL Database with active geo-replication for disaster recovery. The primary database is in the West Europe region. You need to perform a planned failover to the secondary in North Europe for a maintenance window. Which THREE actions should you take? (Choose three.)

Question 17hardmultiple choice
Full question →

You are managing an Azure SQL Database that uses Intelligent Insights. You receive an alert that there is a performance issue with a specific query. You need to analyze the root cause. What should you use?

Question 18hardmultiple choice
Full question →

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database backup retention policy. The database is in a business-critical environment that requires point-in-time restore (PITR) for the last 28 days. What is the issue with this configuration?

Exhibit

Refer to the exhibit.

{
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies",
  "apiVersion": "2023-05-01-preview",
  "properties": {
    "retentionDays": 28,
    "diffBackupIntervalInHours": 24,
    "weeklyRetention": "P4W",
    "monthlyRetention": "P12M",
    "yearlyRetention": "P7Y",
    "weekOfYear": 1
  }
}
Question 19hardmulti select
Full question →

Your company is migrating several on-premises SQL Server databases to Azure. The databases range from 50 GB to 2 TB and have varying performance requirements. You need to decide which Azure SQL deployment options to use. The requirements include: - Minimal application changes. - Support for SQL Server Agent jobs. - Ability to scale storage independently from compute. - Native support for cross-database queries. Which TWO options meet these requirements? (Choose two.)

Question 20hardmulti select
Full question →

Which TWO statements about Azure SQL Database zone-redundant configuration are true? (Choose two.)

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