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 DP-300 Exam - Topic 6 Question 51 Discussion

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?
A) an Azure Automation runbook
B) a SQL Agent job
C) Azure SQL Analytics
D) automatic tuning in Azure SQL Database

Microsoft DP-300 Exam - Topic 6 Question 51 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 51
Topic #: 6
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/

by Mozell at May 07, 2022, 09:38 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rosalia
7 months ago
Definitely need to use an Azure Automation runbook (option A) for multiple subs.
upvoted 0 times
...
Lauryn
7 months ago
Surprised that people think automatic tuning can handle this!
upvoted 0 times
...
Rosio
8 months ago
Azure SQL Analytics (option C) is useful, but not for updating stats.
upvoted 0 times
...
Wade
8 months ago
I disagree, a SQL Agent job (option B) is more reliable for this.
upvoted 0 times
...
Herminia
8 months ago
I think option D is the way to go for automatic updates.
upvoted 0 times
...
Freeman
8 months ago
I recall practicing with Azure SQL Analytics, but I don't think it directly updates statistics. I might lean towards the runbook option.
upvoted 0 times
...
Gabriele
8 months 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.
upvoted 0 times
...
Princess
8 months 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.
upvoted 0 times
...
Lelia
8 months 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.
upvoted 0 times
...
Nicholle
8 months 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.
upvoted 0 times
...
Bette
8 months ago
This one seems straightforward. The payroll expense account should be debited for the gross earnings, which is $300,000.
upvoted 0 times
...
Nakita
8 months 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.
upvoted 0 times
...

Save Cancel