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?
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.
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview
https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/automatic-tuning?view=sql-server-ver15
notifies you whenever a potential performance issue is detected and lets you apply corrective actions, or lets the Database Engine automatically fix performance problems.
Because the question also states that it must minimize administrative effort. Query Performance Insights requires an admin to interpret the results and take action while Automatic Tuning is.... Automatic.
Correct!
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.
This section is not available anymore. Please use the main Exam Page.AZ-304 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.
AustinY
Highly Voted 4 years, 1 month agoMeedeh
Highly Voted 4 years agoTeringzooi
Most Recent 3 years agoDawn7
3 years, 2 months agoJcbrow27
3 years, 2 months agoplmmsg
3 years, 2 months agoAzure_daemon
3 years, 3 months agoDawn7
3 years, 4 months agomoon2351
3 years, 7 months agosyu31svc
3 years, 8 months agoAndres_P
3 years, 8 months agoImNotReallyHere
3 years, 6 months agoManish03Nov
3 years, 9 months agoDinya_jui
3 years, 10 months agoheamgu
3 years, 11 months ago