CertifyDeckCargando contenido…
Microsoft · azure
DP-300 (Azure Database Administrator Associate) validates that you can implement and operate data solutions on Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines and on-premises SQL Server: plan and deploy the platform and migrate databases; configure Microsoft Entra ID authentication, encryption (TDE, Always Encrypted), auditing, masking and ledger; monitor and optimize with Query Store, DMVs, indexes and statistics; automate with SQL Server Agent, elastic jobs, ARM, Bicep, PowerShell and the CLI; and design high availability and disaster recovery with backups, geo-replication, failover groups and Always On. Skills outline in force since 27 October 2026.
No registration · No credit card
Question bank updated on October 26, 2026
Your company runs SQL Server instances in its own data center, in retail stores and on another public cloud provider. You need a single inventory of these instances in Azure and the ability to query them with Azure Resource Graph, for example to list the instances that run on Linux. What should you do?
Your progress
The CertifyDeck DP-300 practice test includes 357+ original exam questions written from the official Microsoft Certified: Azure Database Administrator Associate skills outline, each with the correct answer explained and available in English and Spanish.
Practice by domain with a free online test, take a timed 100-minute mock exam weighted like the real test and review your mistakes. Start for free, no sign-up or credit card, and try the practice test before deciding.
Official weighting per domain. Start for free, no sign-up.
Database administrators experienced with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines (Windows and Linux) and on-premises SQL Server, fluent in T-SQL for administrative tasks. No prerequisite certification.
DP-300 (Exam DP-300: Administering Microsoft Azure SQL Solutions) is the exam for the Microsoft Certified: Azure Database Administrator Associate certification. It checks that you can administer relational databases in the cloud, on-premises and in hybrid setups with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines (Windows and Linux) and on-premises SQL Server: deploy and migrate them, secure them, watch their performance, automate day-to-day tasks and keep them available.
The skills outline in force from 27 October 2026 has five areas: plan and implement data platform resources (15–20%), implement a secure environment (20–25%), monitor, configure, and optimize database resources (20–25%), configure and manage automation of tasks (15–20%), and plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%).
Platform and migration: choosing between Azure SQL Database, Managed Instance and SQL Server on VMs from the requirements, use cases for Azure Arc-enabled SQL Server and Azure SQL Database in Microsoft Fabric, table partitioning, sharding, data compression, scaling, and online and offline migrations. Security: Microsoft Entra ID authentication, least-privilege permissions in T-SQL, TDE, Always Encrypted (including secure enclaves), firewall rules, private links and service endpoints, data classification, auditing, dynamic data masking, ledger and row-level security.
Performance: baselines, database watcher, Extended Events, Query Store, blocking, DMVs, indexes and statistics, execution plans, automatic tuning, Resource Governor and intelligent query processing. Automation: SQL Server Agent jobs, elastic jobs, ARM and Bicep templates, Azure PowerShell and Azure CLI. HA/DR: strategy from RPO and RTO, backups and point-in-time restore, long-term retention, active geo-replication, failover groups, Always On availability groups, failover cluster instances and log shipping.
Microsoft requires no prior certification, but it assumes you already administer SQL Server and write T-SQL. With that background, four to six weeks are usually enough: follow the Microsoft Learn path for DP-300, set up a test Azure SQL database and a Managed Instance, and practise backups, Query Store and failover groups. If you come from [DP-900](/en/certifications/dp-900) or [AZ-104](/en/certifications/az-104), part of the way is already done.
Start free to measure your level and practise by area. The bank has about 360 questions spread across the 5 domains and 94 skill points of the 27 October 2026 outline, and the mock exam mirrors the real one with 50 questions in 100 minutes.
Official source: study guide DP-300 on Microsoft Learn
CertifyDeck is an independent study platform and is not affiliated with, endorsed by, or sponsored by Microsoft. DP-300 and its related marks belong to their respective owner.
You have 100 minutes to answer; Microsoft recommends allowing 120 minutes of seat time for instructions and comments. It does not publish the exact number of questions: most of its exams have between 40 and 60. Our mock exam uses 50 questions in 100 minutes.
You need 700 out of 1,000, like every other Microsoft certification exam.
The fee depends on the country; in the United States Microsoft associate exams cost 165 USD. CertifyDeck does not sell the exam, only the preparation: you can start free and full access is a one-time payment.
English, Spanish, German, French, Italian, Japanese, Korean, Portuguese (Brazil), and Chinese Simplified and Traditional. On CertifyDeck every question and explanation is available in English and Spanish.
No prior certification. Microsoft expects experience with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines and on-premises SQL Server, and fluency in T-SQL for administrative tasks.
Yes. The English version changes on 27 October 2026, with minor updates to security for data at rest and in transit. Localized versions are updated about eight weeks after the English one. Our bank already follows the 27 October 2026 outline.
One year. You renew it for free by passing an online assessment on Microsoft Learn.
No. They are original questions written from the official study guide and Microsoft's public documentation on Azure SQL and SQL Server.
Yes. You can start for free with no sign-up or card: DP-300 practice questions with explanations, a free online test by domain and published sample questions with answers. Full access to the whole bank and the timed mock exam is a one-off payment.
It is a good free starting point, but it is short and repeats the same items. A practice test with hundreds of original Microsoft Certified: Azure Database Administrator Associate questions, timed mock exams and practice by domain tells you where you fail and whether you keep the level under time pressure.
Start for free, no sign-up or credit card.
Start free, no card
Start free, no card