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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Lenna at Apr 09, 2025, 03:29 AM

Limited Time Offer

25%

Off

Get Premium AZ-400 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Loreta
2 months ago
I heard that Azure SQL Database Advisor can also provide index recommendations to improve query performance.
upvoted 0 times
...
Santos
2 months ago
Finally, a chance to unleash the power of the Azure portal. Time to channel my inner database wizard!
upvoted 0 times
Blondell
4 days ago
User1: Absolutely, we want to ensure that Azure is optimizing our database performance over time.
upvoted 0 times
...
Rosendo
11 days ago
User2: Let's make sure we focus on tuning queries for db1 specifically.
upvoted 0 times
...
Tamar
13 days ago
User1: I'm excited to dive into the Azure portal and optimize my SQLDatabase queries!
upvoted 0 times
...
...
Shawna
2 months ago
I agree with you, Antione. Azure SQL Database Advisor can analyze query performance and recommend improvements.
upvoted 0 times
...
Antione
2 months ago
I think we should use Azure SQL Database Advisor for tuning queries.
upvoted 0 times
...
Lai
2 months ago
Tuning queries? Piece of cake! Just make sure to leave some room for the database fairies to work their wonders.
upvoted 0 times
Georgeanna
1 months ago
User 2: You can use Azure to help with that over time.
upvoted 0 times
...
Sherron
2 months ago
User 1: I think I need to tune my queries for db1.
upvoted 0 times
...
...
Kara
2 months 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
Gretchen
10 days ago
User2: Exactly! It takes the hassle out of manually tuning queries.
upvoted 0 times
...
Elli
11 days ago
User1: That's great! It's like having a SQL performance tuning wizard working for you.
upvoted 0 times
...
Dyan
12 days ago
User2: Yes, I have. It helps optimize query performance over time.
upvoted 0 times
...
Sommer
13 days ago
User1: Have you tried enabling Automatic tuning for db1 in Azure SQL Database?
upvoted 0 times
...
Laquita
16 days ago
That sounds like a great tool to optimize our database queries.
upvoted 0 times
...
Malinda
18 days ago
Yes, it provides recommendations for improving query performance over time.
upvoted 0 times
...
Jules
23 days ago
Have you tried using the Query Performance Insight feature in Azure SQL Database?
upvoted 0 times
...
Annice
26 days ago
I know, tuning queries can make a huge difference in performance.
upvoted 0 times
...
...

Save Cancel
a