Microsoft DP-300: Administering Microsoft Azure SQL Solutions

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Secure and monitor data platform

   Administrators must sign in to an Azure SQL logical server with their corporate identities instead of a shared SQL login. Which configuration achieves this?

   1. ASet a Microsoft Entra administrator on the server and enable Entra authentication
   2. BDisable authentication on the server so sign-in skips credential checks
   3. CPublish the admin password in the wiki where every staff member can read it
   4. DCreate one shared SQL login and give its password to each administrator
   Show answer and explanationHide answer

   Correct answer: A

   A Microsoft Entra administrator with Entra authentication enables individual, auditable sign-in with corporate identities. Shared logins lose accountability, and disabling authentication or publishing passwords are unsafe.

2. Question 2Plan and implement data platform resources

   A company is moving an on-premises SQL Server database to Azure and needs fine control over vCores, memory, and storage with the ability to use Azure Hybrid Benefit. Which purchasing model fits?

   1. AThe DTU-based model with fixed bundles only
   2. BThe vCore-based model
   3. CA free tier with no SLA
   4. DA file share with nightly copies
   Show answer and explanationHide answer

   Correct answer: B

   The vCore model exposes compute and storage separately and supports Azure Hybrid Benefit for licensing. DTU bundles limit that control, and free tiers and file shares are not production database hosting models.

3. Question 3Plan and implement high availability and disaster recovery

   An application needs automatic failover to a secondary region with a stable listener endpoint, so connection strings do not change during a failover. Which feature fits?

   1. AA file export to a USB drive
   2. BAn auto-failover group
   3. CA read-only replica with no failover
   4. DA manual copy of the database every week
   Show answer and explanationHide answer

   Correct answer: B

   Auto-failover groups provide automatic failover to a secondary region with listener endpoints that stay constant. Weekly copies, read-only replicas without failover, and file exports do not meet the requirement.

4. Question 4Optimize query performance

   The team sees a query that scans a large table and suggests a missing index. What is the best next step?

   1. ADelete the table that the query scans so the scan operation is removed from the plan and the cost disappears from the workload profile
   2. BRestart the server every hour through a scheduled task so cached execution plans are cleared before the scan
   3. CReview the suggested index against the workload, test it, and create it if it improves performance without harming writes
   4. DCreate every suggested index automatically through the advisor without review by a DBA or the team lead
   Show answer and explanationHide answer

   Correct answer: C

   Suggested indexes must be evaluated against the real workload because each index adds write cost. Automatic creation can produce many unnecessary indexes, and deleting data or restarting does not fix the query.

5. Question 5Monitor and optimize operational resources

   A team wants to find which queries consumed the most CPU over the last week and whether their plans changed. Which feature provides this?

   1. AQuery Store
   2. BApplication logs only
   3. CThe database's file size on disk
   4. DThe server's time zone setting
   Show answer and explanationHide answer

   Correct answer: A

   Query Store records query runtime statistics and plan history over time, which shows heavy queries and plan changes. File size, application logs, and time zone do not capture query execution history.