Explanation:
Measuring and optimizing query performance in Azure Synapse Analytics involves using Azure Monitor to track query response times and the built-in query store to analyze query execution plans. This comprehensive approach ensures that you can identify bottlenecks and optimize query performance effectively.
Ultimate access to all questions.
No comments yet.
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.