Free Preparation Discussions
MENU
Microsoft DP-300 Exam Questions
- Topic 1: Plan and implement data platform resources: This topic equips Microsoft Database Administrators to strategically plan and deploy Azure SQL solutions, ensuring alignment with organizational needs. It emphasizes configuring resources for optimal scale and performance, which is crucial for handling varying workloads effectively. Additionally, it covers creating a robust migration strategy to transition data platforms with minimal disruption, reinforcing knowledge of cloud-based resource management.
- Topic 2: Implement a secure environment: This topic enables administrators to safeguard database integrity by configuring database authentication and authorization, ensuring only authorized access. It emphasizes implementing security measures for data both at rest and in transit, addressing potential vulnerabilities. Finally, it highlights the importance of compliance controls to protect sensitive data and adhere to regulatory standards, fostering a secure database ecosystem.
- Topic 3: Monitor, configure, and optimize database resources: This topic focuses on enhancing database performance through monitoring resource activity and performance, providing insights into usage trends. Administrators will learn techniques to monitor and optimize query performance, streamlining data retrieval processes. It also explores configuring databases for optimal performance, ensuring seamless operations even under demanding conditions.
- Topic 4: Configure and manage automation of tasks: This topic emphasizes operational efficiency by guiding administrators on how to create and manage SQL Server Agent jobs for routine task automation. It includes automating the deployment of database resources, reducing manual intervention. Moreover, it covers managing database tasks within Azure, ensuring streamlined workflows and consistent system management.
- Topic 5: Plan and configure a high availability and disaster recovery (HA/DR) environment: This topic prepares administrators to recommend effective HA/DR strategies for various database scenarios, minimizing downtime. It involves planning and performing backups and restores, ensuring data availability during unexpected events. Additionally, configuring HA/DR solutions reinforces the ability to maintain business continuity and safeguard critical data systems.
Free Microsoft DP-300 Exam Actual Questions
Note: Premium Questions for DP-300 were last updated On Apr. 28, 2026 (see below)
SIMULATION
Task 8
You plan to perform performance testing of db1.
You need prevent db1 from reverting to the last known good query plan.
To prevent db1 from reverting to the last known good query plan, you need to disable the automatic plan correction feature for the database.This feature is enabled by default and allows the Query Store to detect and fix plan performance regressions by forcing the last good plan1.However, if you want to test the performance of different plans without interference from the Query Store, you can turn off this feature by using the ALTER DATABASE SCOPED CONFIGURATION statement2.
Here are the steps to disable the automatic plan correction feature for db1:
Connect to db1 using SQL Server Management Studio, Azure Data Studio, or any other tool that supports Transact-SQL statements.
Open a new query window and run the following command:ALTER DATABASE SCOPED CONFIGURATION SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = OFF); GO
This command will disable the automatic plan correction feature for db1 and allow the Query Optimizer to choose the best plan based on the current statistics and parameters3.
To verify that the automatic plan correction feature is disabled for db1, you can query the sys.database_scoped_configurations catalog view. The value of the force_last_good_plan column should be 0 for db1.
These are the steps to disable the automatic plan correction feature for db1.
You have five on-premises servers that have Microsoft SQL Server 2022 Enterprise installed Each server contains multiple database that store data for web apps and are backed up by using a third-party backup solution.
You plan to migrate the databases to Azure.
You need to recommend a solution to host the databases. The solution must meet the following requirements:
* Compute and storage resources must be shared across the databases.
* Costs must be minimized.
What should you include in the recommendation?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
During normal operations, provide at least two readable copies of Sales.
Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the General Purpose service tier and failover groups.
Does this meet the goal?
Instead deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Note: Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached SSD) on a single node. High availability is achieved by replicating both compute and storage to additional nodes creating a three to four-node cluster.
By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW).
https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
You have an instance of SQL Server on Azure Virtual Machines.
You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle of least privilege.
Which role should you assign to User1?
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVMI hosts a database named OBI.
You need to retrieve query plans from the Query Store on DBI.
What should you do first?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Brian Young
5 days agoRebecca Edwards
2 days agoKatina
22 days agoKarl
29 days agoOmer
1 month agoLisandra
1 month agoJosephine
2 months agoSunny
2 months agoAnnett
2 months agoVeronika
3 months agoAbel
3 months agoLeonida
3 months agoTracie
3 months agoJosphine
3 months agoGlory
4 months agoRana
4 months agoSabrina
4 months agoElza
4 months agoEliseo
5 months agoBrett
5 months agoAleisha
5 months agoJavier
5 months agoHassie
6 months agoSabrina
6 months agoBulah
6 months agoAmalia
6 months agoNelida
7 months agoMauricio
7 months agoArletta
7 months agoLouvenia
8 months agoJeannine
8 months agoKip
10 months agoDaniel
11 months agoLashaunda
12 months agoParis
1 year agoBeula
1 year agoElbert
1 year agoVi
1 year agoAshlee
1 year agoMerilyn
1 year agoWendell
1 year agoKayleigh
1 year agoHannah
1 year agoLeonora
1 year agoAshlee
2 years agoKenny
2 years agoCharlene
2 years agoGussie
2 years agoFelicidad
2 years agoGeorgeanna
2 years agoDierdre
2 years agoOdette
2 years agoDulce
2 years agoVernice
2 years agoArt
2 years agoGeraldo
2 years agoLindsey
2 years agoJannette
2 years ago