SIMULATION - You have several apps that use an Azure SQL Database named db1. You need to ensure that queries to db1 are tuned by Azure over time. The solution m...


Microsoft AZ-400 Exam

Questions Number: 438 out of 535 Questions
81.87%

Question 438
SIMULATION -
You have several apps that use an Azure SQL Database named db1.
You need to ensure that queries to db1 are tuned by Azure over time. The solution must only apply to db1.
To complete this task, sign in to the Microsoft Azure portal.



1. To enable automatic tuning on a single database, navigate to the database in the Azure portal and select Automatic tuning.
AZ-400_438E.jpg related to the Microsoft AZ-400 Exam
2. Select the automatic tuning options you want to enable and select Apply.
Note: Individual automatic tuning settings can be separately configured for each database. You can manually configure an individual automatic tuning option, or specify that an option inherits its settings from the server.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable





Previous Questions Next Questions