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?
Suggested Answer:D🗳️
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
If we need to improve prformance of query then we can use Query Performance insight to identify and improve long running queris but the question is to improve the performance of db hence given answer is correct as this can be achieved by different ways like AI, ML etc
This section is not available anymore. Please use the main Exam Page.AZ-301 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
smsulai
4 years, 11 months agoShunya
4 years, 11 months ago