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?

Aan Azure Automation runbook

Ba SQL Agent job

CAzure SQL Analytics

Dautomatic tuning in Azure SQL Database

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

Submit Cancel

Rosalia

4 months ago

Definitely need to use an Azure Automation runbook (option A) for multiple subs.

upvoted 0 times

...

Lauryn

4 months ago

Surprised that people think automatic tuning can handle this!

upvoted 0 times

...

Rosio

4 months ago

Azure SQL Analytics (option C) is useful, but not for updating stats.

upvoted 0 times

...

Wade

5 months ago

I disagree, a SQL Agent job (option B) is more reliable for this.

upvoted 0 times

...

Herminia

5 months ago

I think option D is the way to go for automatic updates.

upvoted 0 times

...

Freeman

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...