DP-300 Certification Practice Question #142

Question

You have an Azure subscription that contains an Azure SQL database named db1.

You need to implement SQL insights for db1.

Which two resources should you create first? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Accepted Answer

SQL Insights (the Azure Monitor solution) uses a two-component architecture: (1) a dedicated **virtual machine** running the Azure Monitor agent and Workload Insights extension that remotely connects to and collects data from SQL resources, and (2) a **Log Analytics workspace** where that data is stored and analyzed. Although SQL Insights was retired on December 31, 2024, the exam question tests this original required architecture. A storage account, logic app, or Azure function are not prerequisites for SQL Insights setup.

More DP-300 practice questions