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🗳️
You can create a runbook for index maintenance in an Azure SQL database. Reference: https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/
A. an Azure Automation runbook CORRECT
B. a SQL Agent job - AZURE SQL Database doesn't have SQL Agent, only elastic jobs.
C. Azure SQL Analytics - Not related with statistics
D. automatic tuning in Azure SQL Database - Not related with statistics, only execution plan and indexes.
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
HSQL
Highly Voted 1 year, 8 months agoPranava_GCP
1 year, 6 months agoDalamain
7 months agobsk1983
Most Recent 1 year, 2 months agoCiupaz
2 years ago