Exam DP-300 topic 3 question 38 discussion

correct, a VM and a Log Analytics Workspace: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-enable?view=azuresql

Just a heads up that SQL Insights is retired on 31 December 2024 . Microsoft recommends transitioning to Database Watcher for Azure SQL (preview) or another database monitoring solution. So this question will probably be removed from Exam. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-enable?view=azuresql&tabs=sqldb

its such a shame from Microsoft to create VM as shown in youtube video, wish they could have used azure storage, its hard to use SQL insights due to high cost https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-enable?view=azuresql

BE based off this: There's no direct cost for SQL Insights (preview). All costs are incurred by the virtual machines that gather the data, the Log Analytics workspaces that store the data, and any alert rules configured on the data. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql#pricing

The answer is correct

A,E are the correct answers

Please be aware ChatGPT can be wrong and it won’t tell you it is wrong until you tell it. In other words lets stick with answers from real users please!

ChatGPT answer - A. Storage Account B. Log Analytics Workspace

A. a storage account E. a Log Analytics workspace Azure SQL insights is a feature of Azure Monitor that collects, aggregates, and serves SQL performance metrics. It uses a Log Analytics workspace to store and provide advanced analytics on the performance data. You also need a storage account to maintain the SQL assessment data over time. These two resources are essential for setting up SQL insights. A virtual machine, an Azure logic app, and an Azure function are not necessary for this particular task.