MENU
You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.
You need to update the column and index statistics for the databases.
What should you use?
Suggested Answer: A
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
RO
Rosalia
12 months ago
Definitely need to use an Azure Automation runbook (option A) for multiple subs.
LA
Lauryn
1 year ago
Surprised that people think automatic tuning can handle this!
RO
Rosio
1 year ago
Azure SQL Analytics (option C) is useful, but not for updating stats.
WA
Wade
1 year ago
I disagree, a SQL Agent job (option B) is more reliable for this.
HE
Herminia
1 year ago
I think option D is the way to go for automatic updates.
FR
Freeman
1 year ago
I recall practicing with Azure SQL Analytics, but I don't think it directly updates statistics. I might lean towards the runbook option.
GA
Gabriele
1 year ago
Automatic tuning sounds familiar, and I think it can help with statistics, but I’m not convinced it’s the right choice for manual updates.
PR
Princess
1 year ago
I feel like SQL Agent jobs are more for on-premises SQL Server, but I might be mixing that up with Azure SQL Database features.
LE
Lelia
1 year ago
I think I remember something about using Azure Automation runbooks for scheduled tasks, but I'm not entirely sure if that's the best option here.
NI
Nicholle
1 year ago
Hmm, I'm a bit unsure about this one. I know asthma has something to do with the airways, but I can't quite remember if it's narrowing or something else. I'll have to think this through carefully.
BE
Bette
1 year ago
This one seems straightforward. The payroll expense account should be debited for the gross earnings, which is $300,000.
NA
Nakita
1 year ago
Option A looks like the way to go. Creating a single managed instance group in a region with multiple zones should give me the availability and autoscaling I need.