Answer-first summary for fast verification
Answer: Use Azure Monitor to track query response times and Azure Synapse Analytics built-in query store to analyze query execution plans.
Measuring query performance in Azure Synapse Analytics involves using both 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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a data engineer, you need to measure the query performance of a large-scale data warehouse in Azure Synapse Analytics. The queries are critical for generating daily reports for management. What strategies would you employ to measure and optimize query performance, and how would you use Azure Monitor to assist in this process?
A
Use SQL Profiler to trace query execution and Azure Monitor to track query response times.
B
Only use Azure Synapse Analytics built-in query store to track query performance and ignore Azure Monitor.
C
Use Azure Monitor to track query response times and Azure Synapse Analytics built-in query store to analyze query execution plans.
D
Only use SQL Profiler to trace query execution and ignore Azure Monitor and Azure Synapse Analytics built-in query store.
No comments yet.