You have an Azure SQL database named DB1 that contains multiple tables.
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?
A . automatic tuning
B . Azure Advisor
C . Azure Monitor
D . Query Performance Insight
Answer: A
Explanation:
Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning.
Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their performance.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview