Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam AZ-400 Topic 2 Question 119 Discussion

Actual exam question for Microsoft's AZ-400 exam
Question #: 119
Topic #: 2
[All AZ-400 Questions]

SIMULATION

You have several apps that use an Azure SQLDatabase 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.

Show Suggested Answer Hide Answer
Suggested Answer: A

1. To enable automatictuning on a single database, navigate to the database in the Azure portal and select Automatic tuning.

2. Select the automatic tuning options you want to enable and select Apply.

Note: Individual automatic tuning settings can be separately configuredfor each database. You can manually configure an individual automatic tuning option, or specify that an option inherits its settings from the server.


https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

Contribute your Thoughts:

Antione
4 days ago
I think we should use Azure SQL Database Advisor for tuning queries.
upvoted 0 times
...
Lai
10 days ago
Tuning queries? Piece of cake! Just make sure to leave some room for the database fairies to work their wonders.
upvoted 0 times
...
Kara
17 days ago
Ahh, the age-old quest for optimized Azure SQL Database queries. I can already smell the SQL magic happening in the background.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77