Exam DP-300 topic 3 question 52 discussion

Actual exam question from Microsoft's DP-300

Question #: 52
Topic #: 3

You have five instances of SQL Server on Azure Virtual Machines.

You need to monitor Microsoft SQL Server performance for all the instances by consolidating metrics into a single graphic display. The solution must minimize administrative effort.

What should you use?

A. Azure Monitor
B. Log Analytics
C. SQL Insights
D. Azure SQL Analytics

Show Suggested Answer

Suggested Answer: A 🗳️

by pjfunner at April 25, 2024, 5:48 p.m.

Comments

Submit Cancel

pjfunner

Highly Voted 1 year, 2 months ago

Selected Answer: A

I think it's Azure Monitor Agent since: The Log Analytics agent is on a deprecation path and won't be supported after August 31, 2024. Any new data centers brought online after January 1 2024 will not support the Log Analytics agent. If you use the Log Analytics agent to ingest data to Azure Monitor, migrate to the new Azure Monitor agent prior to that date. https://learn.microsoft.com/en-us/azure/azure-monitor/agents/log-analytics-agent

upvoted 5 times

...

bingomutant

Most Recent 8 months, 2 weeks ago

Its A - why not C? - because SQL Insights is primarily used for monitoring SQL Server database performance and workloads. While it can help with detailed SQL performance insights, Azure Monitor provides a broader scope for consolidating metrics across multiple SQL instances.

upvoted 2 times

...

dorwai

9 months, 4 weeks ago

Selected Answer: C

SQL Insight is the best choice here

upvoted 1 times

...

dorwai

10 months ago

Selected Answer: C

SQL Insights is the optimal choice for monitoring SQL Server performance across multiple instances on Azure VMs, as it provides a consolidated view with minimal administrative overhead.

upvoted 1 times

...

6064c2e

1 year ago

Selected Answer: A

A：Azure Monitor. Not B

upvoted 1 times

...

ae8a90c

1 year ago

Selected Answer: A

I think Azure Monitor is the right answer

upvoted 1 times

...