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.

ASee the solution below in explanation

Show Suggested 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

1 months ago

I heard that Azure SQL Database Advisor can also provide index recommendations to improve query performance.

upvoted 0 times

...

Santos

1 months ago

Finally, a chance to unleash the power of the Azure portal. Time to channel my inner database wizard!

upvoted 0 times

Rosendo

5 days ago

User2: Let's make sure we focus on tuning queries for db1 specifically.

upvoted 0 times

...

Tamar

7 days ago

User1: I'm excited to dive into the Azure portal and optimize my SQLDatabase queries!

upvoted 0 times

...

Shawna

1 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

1 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

4 days ago

User2: Exactly! It takes the hassle out of manually tuning queries.

upvoted 0 times

...

Elli

5 days ago

User1: That's great! It's like having a SQL performance tuning wizard working for you.

upvoted 0 times

...

Dyan

6 days ago

User2: Yes, I have. It helps optimize query performance over time.

upvoted 0 times

...

Sommer

7 days ago

User1: Have you tried enabling Automatic tuning for db1 in Azure SQL Database?

upvoted 0 times

...

Laquita

10 days ago

That sounds like a great tool to optimize our database queries.

upvoted 0 times

...

Malinda

12 days ago

Yes, it provides recommendations for improving query performance over time.

upvoted 0 times

...

Jules

17 days ago

Have you tried using the Query Performance Insight feature in Azure SQL Database?

upvoted 0 times

...

Annice

19 days ago

I know, tuning queries can make a huge difference in performance.

upvoted 0 times

...