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

Scenario-based practice

Refer to the Exhibit Practice 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
15
scenario questions
DP-300
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-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 2easymultiple choice
Full question →

Refer to the exhibit. You apply this JSON configuration to an Azure SQL Database server. Which actions will be audited?

Exhibit

Refer to the exhibit.

{
    "properties": {
        "state": "Enabled",
        "storageEndpoint": "https://mystorage.blob.core.windows.net",
        "retentionDays": 30,
        "auditActionsAndGroups": [
            "SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
            "FAILED_DATABASE_AUTHENTICATION_GROUP"
        ]
    }
}
Question 3hardmultiple 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 4mediummultiple choice
Full question →

Refer to the exhibit. You are managing db1, which is currently in Standard tier. What is the maximum size you can set for db1 without changing the service objective?

Network Topology
availablelocation eastusquery "[?name=='Standard'].supportedServiceLevelObjectives[?name=='S2'].maxSizeBytes"resource-group rg1server srv1name db1query 'maxSizeBytes'Azure CLI command and output:"268435456000""107374182400"
Question 5mediummultiple choice
Full question →

Refer to the exhibit. You run the above PowerShell command to set the Transparent Data Encryption (TDE) protector for an Azure SQL Database server. What is the result?

Exhibit

Invoke-AzSqlDatabaseTransparentDataEncryptionProtector -ServerName "myserver" -ResourceGroupName "myrg" -ProtectorType "AzureKeyVault" -KeyVaultKeyId "https://myvault.vault.azure.net/keys/mykey/abc123"
Question 6mediummultiple choice
Full question →

You are analyzing the exhibit KQL query that queries Azure Diagnostics logs for Query Store runtime statistics. The query is intended to show average CPU time per hour for each database. However, the result shows no data for the last 24 hours, although Query Store is enabled on all databases. What is the most likely reason?

Exhibit

Refer to the exhibit.
```kusto
AzureDiagnostics
| where ResourceProvider == "MICROSOFT.SQL"
| where Category == "QueryStoreRuntimeStatistics"
| summarize avg(avg_cpu_time) by DatabaseName, bin(TimeGenerated, 1h)
| render timechart
```
Question 7mediummultiple choice
Full question →

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database. The template configures backup retention. What is the effect of this configuration?

Exhibit

Refer to the exhibit.

```json
{
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies",
  "apiVersion": "2023-05-01-preview",
  "name": "Default",
  "properties": {
    "retentionDays": 7,
    "diffBackupIntervalInHours": 12
  }
}
```
Question 8hardmultiple 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 9mediummultiple choice
Full question →

Refer to the exhibit. A Logic App is configured to pause an Azure SQL Database named AdventureWorks every Friday at 8 PM. However, the database is not pausing. What is the most likely reason?

Exhibit

Refer to the exhibit.

{
  "name": "start-stop-database",
  "type": "Microsoft.Logic/workflows",
  "location": "eastus",
  "properties": {
    "definition": {
      "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
      "actions": {
        "Pause_Database": {
          "type": "ApiConnection",
          "inputs": {
            "host": {
              "connection": {
                "name": "@parameters('$connections')['sql']['connectionId']"
              }
            },
            "method": "post",
            "path": "/databases/@{encodeURIComponent('AdventureWorks')}/pause",
            "queries": {
              "api-version": "2023-08-01-preview"
            }
          }
        }
      },
      "triggers": {
        "Recurrence": {
          "recurrence": {
            "frequency": "Week",
            "interval": 1,
            "schedule": {
              "hours": [20],
              "minutes": [0],
              "weekDays": ["Friday"]
            }
          },
          "type": "Recurrence"
        }
      }
    }
  }
}
Question 10hardmultiple choice
Full question →

Refer to the exhibit. A PowerShell script is used to move an Azure SQL Database into an elastic pool. The script runs without error. Which condition must be true before the script runs?

Exhibit

Refer to the exhibit.

$resourceGroup = "rg-sql"
$databaseName = "sqldb1"
$elasticPoolName = "ep1"

Set-AzSqlDatabase -ResourceGroupName $resourceGroup `
  -DatabaseName $databaseName `
  -ElasticPoolName $elasticPoolName
Question 11hardmultiple choice
Full question →

Refer to the exhibit. You are configuring a backup policy for an Azure SQL Database. The database is in the East US region. You need to ensure that the database can be restored to a different region in the event of a regional disaster. Which setting in the exhibit must be correctly configured?

Exhibit

{
  "properties": {
    "backupStorageRedundancy": "Geo",
    "geoBackupPolicy": {
      "state": "Enabled",
      "location": "eastus2",
      "retentionDays": 7
    },
    "longTermRetentionPolicy": {
      "weeklyRetention": "P4W",
      "monthlyRetention": "P12M",
      "yearlyRetention": "P3Y"
    }
  },
  "type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies"
}
Question 12mediummultiple choice
Full question →

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database backup policy. The database is used for a reporting workload that is updated daily. The compliance team requires that point-in-time restore (PITR) be available for the past 30 days. What action should you take?

Exhibit

{
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies",
  "apiVersion": "2023-08-01-preview",
  "properties": {
    "retentionDays": 14,
    "diffBackupIntervalInHours": 12
  }
}
Question 13hardmultiple choice
Full question →

Refer to the exhibit. An Azure SQL Database administrator sees the error in the SQL Server error log. The database is in the General Purpose tier with 100 GB of storage. Which action should the DBA take to resolve the issue?

Exhibit

Refer to the exhibit.

Exhibit:
```
Event ID: 4140
Severity: 16
Message: Could not allocate space for object 'sys.sysrscols' in database 'mydb' because the 'PRIMARY' filegroup is full.
```
Question 14mediummultiple choice
Full question →

Refer to the exhibit. An Azure SQL Database is receiving Intelligent Insights degradation alerts. Which action should be taken first?

Exhibit

Azure SQL Database Intelligent Insights log:

{
  "id": "/subscriptions/.../resourceGroups/.../providers/Microsoft.Sql/servers/.../databases/.../metrics",
  "properties": {
    "startTime": "2024-05-01T10:00:00Z",
    "endTime": "2024-05-01T11:00:00Z",
    "metrics": [
      {
        "name": "cpu_percent",
        "average": 85,
        "max": 99,
        "min": 20
      },
      {
        "name": "physical_data_read_percent",
        "average": 95,
        "max": 100,
        "min": 50
      },
      {
        "name": "log_write_percent",
        "average": 10,
        "max": 15
      }
    ],
    "observations": [
      {
        "type": "Degradation",
        "subType": "ResourceLimit",
        "details": "DTU consumption reached 100% for extended period. Consider scaling up or optimizing queries."
      }
    ]
  }
}

Current database tier: Standard S2 (50 DTU)
Question 15easymultiple choice
Full question →

Refer to the exhibit. The ARM template snippet configures auditing for an Azure SQL Database. Based on the configuration, which events are audited?

Exhibit

{
  "type": "Microsoft.Sql/servers/databases/auditingSettings",
  "apiVersion": "2020-11-01-preview",
  "properties": {
    "state": "Enabled",
    "auditActionsAndGroups": [
      "SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
      "FAILED_DATABASE_AUTHENTICATION_GROUP"
    ],
    "storageAccountAccessKey": "...",
    "retentionDays": 90
  }
}

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.