Azure SQL Analytics Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Performance Monitoring

What you'll be asked

  1. Which Azure service is primarily used to collect and visualize telemetry data from Azure SQL databases for performance monitoring?
  2. You notice a sudden spike in CPU usage on your Azure SQL Database. Which dynamic management view (DMV) should you query to identify the top resource-consuming queries?
  3. When configuring diagnostic settings for an Azure SQL Database, which destination is required to enable advanced log analytics and custom KQL querying?
  4. Which metric in Azure SQL Database indicates that the database is reaching the limits of its current service tier and may require scaling?
  5. You are troubleshooting a performance issue where queries are running slowly due to blocking. Which KQL query would best help you identify active blocking sessions in your Log Analytics workspace if you have enabled SQL Insights?

Answers and explanations come after you submit.