
Ultimate access to all questions.
You are tasked with measuring the query performance of a data warehouse in Azure Synapse Analytics. The queries are used to generate real-time analytics for a high-traffic e-commerce website. Describe the strategies you would employ to measure and optimize query performance, and how you would use Azure Monitor to assist in this process.
A
Use Azure Monitor to track query response times and Azure Synapse Analytics built-in query store to analyze query execution plans.
B
Only use SQL Profiler to trace query execution and ignore Azure Monitor and Azure Synapse Analytics built-in query store.
C
Use Azure Monitor to track storage usage metrics and ignore query performance metrics.
D
Only use Azure Synapse Analytics built-in query store to track query performance and ignore Azure Monitor.