Exam AZ-301 topic 17 question 2 discussion

I think the answer should be dynamic management views: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs

Repeated question of Question #9 @ https://www.examtopics.com/exams/microsoft/az-301/view/2/ Requirements summarized: - Multiple SQL DB & SQL MI Instances requiring monitoring - Support long-term analysis (maintained for up to two weeks) - Support current-state analysis that collects metric real-time (maintained for up to one hour) - Monitor concurrent logins and sessions What should you include in the recommendation? A. dynamic management views > Effortful and unclear on how to retain and analyse information gathered, so ruled out. B. trace flags > Seems to be very effortful to set on all DB engines. Although unclear on how to retain and analyse that amount of data. Ruled out. C. Azure Monitor > Only viable option left! D. SQL Server Profiler > Low level debugging tool. Doesn't make sense to use for longer term analysis. Also it's deprecated, so ruled out! Links: https://techcommunity.microsoft.com/t5/azure-sql-database/monitoring-options-available-for-azure-sql-managed-instance/ba-p/1065416

C is correct answer.

with Monitor we can not get the metrics for less than a minute, since it says real time, and multiple times a minute it would be DMV i..e. option A

Here is the repeated question : https://www.examtopics.com/exams/microsoft/az-301/view/2/

D. SQL Server Profiler Common SQL Profiler use-cases: Stepping through problem queries to find the cause of the problem. Finding and diagnosing slow-running queries. Capturing the series of Transact-SQL statements that lead to a problem. Monitoring the performance of SQL Server to tune workloads. Correlating performance counters to diagnose problems.

Answer C is correct.

This is a repeated question: https://www.examtopics.com/exams/microsoft/az-301/view/9