Exam AZ-301 topic 1 question 9 discussion

c: is correct ....It uses Azure Diagnostic metrics along with Azure Monitor views to present data about all your Azure SQL databases, elastic pools, and databases in Managed Instances in a single Log Analytics workspace. Azure Monitor helps you to collect, correlate, and visualize structured and unstructured data. https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql

Correct answer is A- dynamic management views. For current state analysis you'd use sys.dm_db_resource_stats view. And for longer term analysis you have to use sys.resource_stats view which collects data every 5 minutes and maintains it for 14 days. You are welcome!

DMV is more useful for historical analysis rather than near-real-time analysis. So DMV is not the correct answer. Azure Monitor looks good to me.

C. Azure Monitor

azure monitor can be used for long term by pinning the report to dashboard

C is correct answer

Answer A is correct, DMV: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs#maximum-concurrent-logins

A! https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs sys.dm_db_resource_stats You can use the sys.dm_db_resource_stats view in every database. The sys.dm_db_resource_stats view shows recent resource use data relative to the service tier. Average percentages for CPU, data IO, log writes, and memory are recorded every 15 seconds and are maintained for 1 hour.

Read thru the entire discussion and reviewed links. Close call, but I think Azure Monitor is answer. The mention of keyword "metrics" influenced me -- although to achieve multiple sampling per minute will require custom metrics.

A. Dynamic Management Views seems to the correct answer for this question.

answer is A https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs

101% certain the answer is a) dynamic management views Refer to: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs

Ans is correct: "based on metrics collected near real-time, multiple times per minute". it doesn't have to be realtime but NEAR realtime

Only Azure Monitor provide metric data https://docs.microsoft.com/en-us/azure/azure-monitor/platform/data-platform-metrics

Correct Answer A. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs DMV applies to both Azure SQL Database & Azure SQL Managed Instance You can use the sys.dm_db_resource_stats view in every database. The sys.dm_db_resource_stats view shows recent resource use data relative to the service tier. Average percentages for CPU, data IO, log writes, and memory are recorded every 15 seconds and are maintained for 1 hour. You can use sys.server_resource_stats to return CPU usage, IO, and storage data for an Azure SQL Managed Instance. The data is collected and aggregated within five-minute intervals. There is one row for every 15 seconds reporting. The data returned includes CPU usage, storage size, IO utilization, and managed instance SKU. Historical data is retained for approximately 14 days. Because this view provides a more granular look at resource use, use sys.dm_db_resource_stats first for any current-state analysis or troubleshooting

Answer "Azure Monitor" is correct. Dynamic Management View's data is removed when SQL Server is restarted. Please note the requeriment: "Support longer term analysis based on metrics collected"

Answer C) Azure Monitor is the correct answer. See this link for more details https://techcommunity.microsoft.com/t5/azure-sql-database/monitoring-options-available-for-azure-sql-managed-instance/ba-p/1065416