
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.