Azure SQL Analytics Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Performance Monitoring

Azure SQL Analytics Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which Azure service is primarily used to collect and visualize telemetry data from Azure SQL databases for performance monitoring?

  2. 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. 3

    When configuring diagnostic settings for an Azure SQL Database, which destination is required to enable advanced log analytics and custom KQL querying?

  4. 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. 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?