dp-900 Practice Question 1826
Exam: dp-900
Domain: Describe how to work with relational data on Azure
Topic: Describe relational Azure data services
Difficulty: medium
A developer at Contoso Ltd is experiencing slow query performance in an Azure SQL Database. The team suspects that the issue might be related to the underlying hardware configuration. What should the developer check first to optimize the performance?
Answer Options
A
Memory usage
B
CPU utilization
C
Network latency
D
DTU
Correct Answer
B: CPU utilization
Explanation
The correct answer is B: CPU utilization. Checking the CPU utilization can help identify if the server is underpowered or if there are specific queries causing high CPU usage.