Courseiva

DP-300 · topic practice

Plan and implement data platform resources practice questions

Practise Microsoft Azure Database Administrator Associate DP-300 Plan and implement data platform resources 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: Plan and implement data platform resources
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Plan and implement data platform resources

Plan and implement data platform resources 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 Plan and implement data platform resources 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

Plan and implement data platform resources questions

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice
Read the full Plan and implement data platform resources explanation →

A company is deploying Azure SQL Managed Instance and needs to ensure that the failover group provides automatic failover with zero data loss during a regional outage. The secondary region is 500 miles away. Which data replication mode should be configured?

Question 2hardmultiple choice
Read the full Plan and implement data platform resources explanation →

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 3easymultiple choice
Read the full Plan and implement data platform resources explanation →

A DBA needs to create a new Azure SQL Database and wants to ensure that the database automatically fails over to a secondary region without manual intervention. The recovery point objective (RPO) is 5 seconds. What should the DBA configure?

Question 4hardmultiple choice
Read the full Plan and implement data platform resources explanation →

A company has an Azure SQL Managed Instance that is experiencing high CPU usage. The DBA observes that a specific query is causing high compile time due to parameter sniffing. The query is executed frequently with varying parameter values. Which approach should the DBA use to reduce CPU usage without changing the T-SQL code?

Question 5mediummultiple choice
Read the full NAT/PAT explanation →

A healthcare company is required to encrypt all patient data at rest and in transit. They are deploying Azure SQL Database. Which combination of features should they implement to meet this requirement?

Question 6hardmultiple choice
Read the full Plan and implement data platform resources explanation →

A DBA is migrating a large on-premises database to Azure SQL Database using the Data Migration Assistant (DMA). The migration fails with an error indicating that the source database contains cross-database queries. What is the best remediation?

Question 7easymultiple choice
Read the full Plan and implement data platform resources explanation →

A company plans to deploy Azure SQL Database in a new region. They require that the database be accessible only from a specific set of Azure virtual machines in the same region. What should the DBA configure?

Question 8mediummultiple choice
Read the full Plan and implement data platform resources explanation →

A company uses Azure SQL Managed Instance for its line-of-business applications. They need to ensure that backups are retained for 35 days for compliance purposes. Which configuration should the DBA set?

Question 9mediummulti select
Read the full Plan and implement data platform resources explanation →

Which TWO of the following are valid methods to migrate an on-premises SQL Server database to Azure SQL Database?

Question 10hardmulti select
Read the full Plan and implement data platform resources explanation →

Which THREE of the following are features available in Azure SQL Managed Instance that are not available in Azure SQL Database (single database)?

Question 11mediummultiple choice
Read the full Plan and implement data platform resources explanation →

Refer to the exhibit. A DBA is creating an Azure SQL Managed Instance using the ARM template snippet shown. The DBA needs to ensure the instance can survive a regional outage without data loss. What change should be made to the template?

Exhibit

Refer to the exhibit.

Exhibit:
```
{
    "properties": {
        "collation": "SQL_Latin1_General_CP1_CI_AS",
        "maxSizeBytes": 214748364800,
        "sku": {
            "name": "GP_Gen5_4",
            "tier": "GeneralPurpose",
            "capacity": 4
        },
        "storageAccountType": "GRS",
        "zoneRedundant": false
    },
    "location": "eastus"
}
```
Question 12hardmultiple choice
Read the full Plan and implement data platform resources explanation →

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 13hardmultiple choice
Review the full routing breakdown →

You are the Azure DBA for a global e-commerce company. The company uses Azure SQL Database for its product catalog. The database is in the Business Critical tier with 16 vCores and 1 TB of storage. During a major sales event, the application experiences severe performance degradation. Analysis reveals that the database is experiencing high write latency on the secondary replicas due to heavy read workload routed to them. The primary replica is not overloaded. The application uses read-only routing to direct queries to readable secondaries. The DBA needs to reduce write latency on the secondaries without affecting the read workload or incurring additional cost. What should the DBA do?

Question 14mediummultiple choice
Read the full Plan and implement data platform resources explanation →

You are the DBA for a financial services company. The company is migrating its on-premises SQL Server databases to Azure SQL Managed Instance. One of the databases is 2 TB in size and has a high transaction volume. The migration must have minimal downtime. The source environment is SQL Server 2019 running on Windows Server. The target is a General Purpose managed instance in the same region. The network bandwidth between on-premises and Azure is 500 Mbps. The DBA plans to use Azure Database Migration Service (DMS) for an online migration. However, during the initial sync, the migration is progressing slowly and the estimated time to completion is 48 hours. The DBA needs to reduce the migration time. What should the DBA do?

Question 15mediummultiple choice
Read the full Plan and implement data platform resources explanation →

A company is planning to migrate their on-premises SQL Server databases to Azure SQL Managed Instance. They have a database that uses SQL Server Agent jobs with proxies and also uses cross-database queries extensively. What is the main consideration for this migration?

Question 16easymultiple choice
Read the full Plan and implement data platform resources explanation →

You are designing a disaster recovery strategy for an Azure SQL Database that requires a Recovery Point Objective (RPO) of less than 5 seconds and a Recovery Time Objective (RTO) of less than 1 hour. Which option should you choose?

Question 17hardmultiple choice
Read the full Plan and implement data platform resources explanation →

A company has an Azure SQL Database with a large table that is frequently updated. They notice performance degradation due to index fragmentation. Which maintenance strategy should you recommend to minimize impact on availability and performance?

Question 18mediummulti select
Read the full Plan and implement data platform resources explanation →

Which THREE of the following are valid options for migrating an on-premises SQL Server database to Azure SQL Database?

Question 19mediummultiple choice
Read the full Plan and implement data platform resources explanation →

You are the database administrator for a large e-commerce company. The company has a SQL Server 2019 Enterprise Edition instance running on-premises with multiple databases. One of the databases, 'OrdersDB', is 2 TB in size and has a high transaction rate. The company plans to migrate 'OrdersDB' to Azure SQL Managed Instance to reduce operational overhead. The migration must have minimal downtime, and the target service tier must be Business Critical with 16 vCores. You have set up a test environment and performed a successful test migration using the Azure Database Migration Service (DMS) with online mode. During the final migration, the network bandwidth between on-premises and Azure is limited to 100 Mbps. The migration is taking longer than expected, and you are concerned about the log backup growth. What should you do to minimize the risk of the migration failing due to log space exhaustion?

Question 20hardmultiple choice
Read the full Plan and implement data platform resources explanation →

You are designing a database solution for an e-commerce application that requires high read throughput with sub-5 ms latency. The application runs on Azure VMs. You need to choose between Azure SQL Database and Azure SQL Managed Instance. Which factor most strongly supports choosing Azure SQL Database over SQL Managed Instance?

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 Plan and implement data platform resources sessions

Start a Plan and implement data platform resources only practice session

Every question in these sessions is drawn from the Plan and implement data platform resources domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Plan and implement data platform resources questions →Mixed DP-300 session

Related practice questions

Related DP-300 topic practice pages

Move into related areas when this topic feels solid.

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

Practise DP-300 questions linked to Plan and configure a high availability and disaster recovery environment.

Plan and implement data platform resources practice questions

Practise DP-300 questions linked to Plan and implement data platform resources.

Monitor, configure, and optimize database resources practice questions

Practise DP-300 questions linked to Monitor, configure, and optimize database resources.

Configure and manage automation of tasks practice questions

Practise DP-300 questions linked to Configure and manage automation of tasks.

Plan and configure high availability and disaster recovery practice questions

Practise DP-300 questions linked to Plan and configure high availability and disaster recovery.

Implement a secure environment practice questions

Practise DP-300 questions linked to Implement a secure environment.

DP-300 fundamentals practice questions

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

DP-300 scenario practice questions

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

DP-300 troubleshooting practice questions

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

Frequently asked questions

What does the DP-300 exam test about Plan and implement data platform resources?
Plan and implement data platform resources 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 Plan and implement data platform resources questions in a focused session?
Yes — the session launcher on this page draws every question from the Plan and implement data platform resources 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-300 topics?
Use the topic links above to move to related areas, or go back to the DP-300 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-300 exam covers. They are not copied from any real exam or dump site.