MENU
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.
Suggested Answer: A
Get Premium AZ-400 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
33 comments · newest first
NI
Nickie
10 months ago
I’m not convinced it’ll make a big difference though.
LO
Loreen
10 months ago
Yup, it optimizes over time, pretty cool!
ES
Esteban
10 months ago
Totally agree, it's super easy to set up!
EV
Eveline
11 months ago
Wait, does that really work for all queries?
ED
Eden
11 months ago
Just enable automatic tuning for db1 in the Azure portal.
NI
Nicholle
11 months ago
I believe we have to look for the "Automatic tuning" option specifically for db1, but I might be mixing it up with other Azure services.
SH
Sheridan
11 months ago
I feel like there was something about setting up recommendations for query tuning, but I can't recall the exact steps.
TE
Teddy
12 months ago
I remember practicing a similar question where we had to configure performance tuning settings. I think it involved going into the database settings in the Azure portal.
RO
Rory
12 months ago
I think we need to enable automatic tuning for db1, but I'm not entirely sure if it applies to just one database or all databases in the server.
LU
Lura
12 months ago
I'm not entirely sure where to start on this one. I'll need to do some research on how Azure handles automatic query tuning before I can tackle this question.
BR
Brynn
1 year ago
This seems like a pretty standard task. I'm confident I can figure it out by exploring the Azure portal and the database settings.
MA
Margret
1 year ago
Okay, I think I've got a plan. I'll log into the Azure portal, navigate to the db1 database, and look for any settings or features related to automatic query tuning or optimization.
BR
Breana
1 year ago
I'm a bit confused on the specifics here. Do I need to configure any settings in the database itself, or is it all done through the Azure portal?
IR
Iraida
1 year ago
Hmm, this seems straightforward. I'll start by checking the Azure portal to see if there are any options for automatic query tuning on the db1 database.
LO
Loreta
1 year ago
I heard that Azure SQL Database Advisor can also provide index recommendations to improve query performance.
SA
Santos
1 year ago
Finally, a chance to unleash the power of the Azure portal. Time to channel my inner database wizard!
BL
Blondell
1 year ago
User1: Absolutely, we want to ensure that Azure is optimizing our database performance over time.
RO
Rosendo
1 year ago
User2: Let's make sure we focus on tuning queries for db1 specifically.
TA
Tamar
1 year ago
User1: I'm excited to dive into the Azure portal and optimize my SQLDatabase queries!
SH
Shawna
1 year ago
I agree with you, Antione. Azure SQL Database Advisor can analyze query performance and recommend improvements.
AN
Antione
2 years ago
I think we should use Azure SQL Database Advisor for tuning queries.
LA
Lai
2 years ago
Tuning queries? Piece of cake! Just make sure to leave some room for the database fairies to work their wonders.
GE
Georgeanna
1 year ago
User 2: You can use Azure to help with that over time.
SH
Sherron
1 year ago
User 1: I think I need to tune my queries for db1.
KA
Kara
2 years ago
Ahh, the age-old quest for optimized Azure SQL Database queries. I can already smell the SQL magic happening in the background.
GR
Gretchen
1 year ago
User2: Exactly! It takes the hassle out of manually tuning queries.
EL
Elli
1 year ago
User1: That's great! It's like having a SQL performance tuning wizard working for you.
DY
Dyan
1 year ago
User2: Yes, I have. It helps optimize query performance over time.
SO
Sommer
1 year ago
User1: Have you tried enabling Automatic tuning for db1 in Azure SQL Database?
LA
Laquita
1 year ago
That sounds like a great tool to optimize our database queries.
MA
Malinda
1 year ago
Yes, it provides recommendations for improving query performance over time.
JU
Jules
1 year ago
Have you tried using the Query Performance Insight feature in Azure SQL Database?
AN
Annice
1 year ago
I know, tuning queries can make a huge difference in performance.