Courseiva

DP-300 · topic practice

Scenario practice questions

Practise Microsoft Azure Database Administrator Associate DP-300 Scenario 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: Scenario
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Scenario

Scenario 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 Scenario 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

Scenario questions

20 questions · select your answer, then reveal the explanation

Question 1easymultiple choice
Read the full Scenario explanation →

You are deploying an Azure SQL Database for a development environment. The database will be used for testing and will be deleted after three months. You want to minimize costs while ensuring the database can be restored to any point within the retention period. Which backup retention policy should you configure?

Question 2mediummultiple choice
Read the full Scenario explanation →

Your company is deploying a multi-tenant application using Azure SQL Database. Each tenant gets its own database. You need to manage resources efficiently while ensuring performance isolation between tenants. The number of tenants fluctuates, and you want to minimize cost. What is the best strategy?

Question 3hardmultiple choice
Read the full Scenario explanation →

A company uses Azure SQL Database with elastic pools. They need to automatically scale up the pool DTU when CPU usage exceeds 80% for 5 minutes and scale down when below 20% for 10 minutes. Which solution should they implement?

Question 4mediummulti select
Read the full Scenario explanation →

You are implementing automation for an Azure SQL Database. Which TWO scenarios are appropriate for using elastic database jobs? (Choose two.)

Question 5easymultiple choice
Read the full Scenario explanation →

You are the DBA for a company that uses Azure SQL Database. You need to ensure that only authorized users can view sensitive columns (e.g., salary) in the Employees table. You want to obfuscate the data for certain users but allow full access to HR managers. Which feature should you use?

Question 6mediummultiple choice
Read the full Scenario explanation →

You have an Azure SQL Database that is experiencing performance degradation. You suspect that parameter sniffing is causing suboptimal execution plans. What should you do to mitigate this issue without changing application code?

Question 7mediummultiple choice
Read the full Scenario explanation →

You are deploying Azure SQL Database for a multi-tenant SaaS application. Each tenant has its own database. You need to ensure that tenant data is isolated and that performance is predictable. Cost efficiency is important. Which deployment model should you use?

Question 8mediummultiple choice
Read the full Scenario explanation →

You are configuring Azure SQL Database for a new e-commerce application that must support high read throughput for product catalog queries. The application uses Entity Framework Core and requires that read-only queries be offloaded to a secondary replica to reduce load on the primary. Which feature should you enable?

Question 9easymultiple choice
Read the full Scenario explanation →

You are tasked with automating index maintenance for an Azure SQL Database. Which Azure service should you use to run T-SQL scripts on a recurring schedule?

Question 10hardmultiple choice
Read the full Scenario explanation →

Refer to the exhibit. The SalesDB database is experiencing log space full errors. Based on the exhibit, what is the most likely reason?

Exhibit

Azure CLI output from 'az sql db list-editions -o table':

Edition       | SLO        | DTU | MaxStorageGB
GeneralPurpose | GP_Gen5_2  | 100 | 512
GeneralPurpose | GP_Gen5_4  | 200 | 512
GeneralPurpose | GP_Gen5_8  | 400 | 1024
BusinessCritical | BC_Gen5_2 | 100 | 512
BusinessCritical | BC_Gen5_4 | 200 | 512

Current database properties:

Name: SalesDB
Edition: GeneralPurpose
ServiceObjective: GP_Gen5_2
Storage used: 480 GB
Max storage: 512 GB

Query Store shows:

Total log write rate: 5 MB/s
Log IO percentage: 80%

sys.dm_db_log_space_usage:

Total log space: 100 GB
Used log space: 95 GB
Question 11hardmulti select
Read the full Scenario explanation →

Which THREE of the following are required to configure Transparent Data Encryption (TDE) with customer-managed keys in Azure Key Vault for Azure SQL Database?

Question 12easymulti select
Read the full Scenario explanation →

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

Question 13easymultiple choice
Read the full Scenario explanation →

You are the database administrator for a company that uses Azure SQL Database. The company has a strict security policy requiring that all database connections be encrypted and that the server's firewall only allows connections from a list of approved IP addresses. You have configured the server-level firewall rules accordingly and enabled the 'Force encryption' setting on the server. However, after deployment, you notice that an application running on an Azure virtual machine is able to connect to the database even though its public IP address is not in the approved list. The virtual machine is in the same region as the database. What is the most likely cause?

Question 14hardmultiple choice
Read the full Scenario explanation →

You are a database administrator for a global SaaS provider. You have multiple Azure SQL Databases in a single logical server. You need to implement a disaster recovery strategy that provides automatic failover across Azure regions with the lowest possible RPO and RTO for critical databases. The solution must not require any application code changes. What should you implement?

Question 15easymultiple choice
Read the full Scenario explanation →

You are designing a new Azure SQL Database for an e-commerce application. The database will contain sensitive customer data and must be isolated from other tenants. Which deployment option provides the highest level of resource isolation?

Question 16hardmultiple choice
Read the full Scenario explanation →

You are troubleshooting a performance issue on an Azure SQL Database. Query Store shows a significant increase in query duration for a specific query. The execution plan has changed from a hash join to a nested loops join. What is the most likely cause?

Question 17mediummultiple choice
Read the full Scenario explanation →

You have an Azure SQL Database in the General Purpose tier. You need to implement a disaster recovery solution that provides an RPO of 5 seconds and an RTO of 1 hour. The solution must use Azure PaaS features only. What should you do?

Question 18easymultiple choice
Read the full Scenario explanation →

You need to automatically scale up an Azure SQL Database to the next service tier when CPU usage exceeds 80% for 10 minutes, then scale back down when CPU drops below 30% for 30 minutes. Which Azure feature should you use?

Question 19mediummulti select
Read the full Scenario explanation →

Which THREE factors should be considered when choosing between Azure SQL Database active geo-replication and auto-failover groups for disaster recovery?

Question 20hardmultiple choice
Read the full Scenario explanation →

You have an Azure SQL Database that is configured with automatic failover groups. During a planned failover, you notice that the failover takes longer than expected. You need to minimize downtime during future planned failovers. What should you do?

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 Scenario sessions

Start a Scenario only practice session

Every question in these sessions is drawn from the Scenario domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Scenario 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

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.

Frequently asked questions

What does the DP-300 exam test about Scenario?
Scenario 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 Scenario questions in a focused session?
Yes — the session launcher on this page draws every question from the Scenario 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.