DP-300 Administering Microsoft Azure SQL Solutions EXAM READINESS GUIDE Q & S 2026/2027

DP-300 Administering Microsoft Azure SQL Solutions EXAM READINESS GUIDE Q & S 2026/2027

1. When configuring Azure SQL Database, which
performance metric should be prioritized for OLTP
workloads?
 a) Disk size
 b) Memory
 c) I/O throughput
 d) CPU
 Correct Answer: c) I/O throughput
2. In Azure SQL Managed Instance, what is the
recommended method for automating the scaling of
compute resources based on workload?
 a) Manual scaling
 b) Autoscaling with Azure Automation
 c) Scaling with Azure Functions
 d) Scheduled scaling with Azure Logic Apps
 Correct Answer: b) Autoscaling with Azure Automation
3. Which Azure service provides real-time monitoring and
performance metrics for Azure SQL resources?
 a) Azure Monitor
 b) Azure Advisor
 c) Azure Service Health
 d) Azure SQL Analytics
 Correct Answer: a) Azure Monitor
4. What is the primary benefit of implementing Azure SQL
Database's In-Memory OLTP feature for a high-transaction
database?