exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 5 question 33 discussion

Actual exam question from Microsoft's DP-300
Question #: 33
Topic #: 5
[All DP-300 Questions]

You have 25 Azure SQL databases.

You need to implement a centralized database management solution that uses Transact-SQL.

What should you include in the solution?

  • A. elastic jobs
  • B. an Azure Automation runbook
  • C. Azure Functions
  • D. Azure Logic Apps
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
voodoo_sh
5 months, 1 week ago
Elastic jobs: These are specifically designed for managing multiple Azure SQL databases at scale. They allow you to run Transact-SQL scripts across multiple databases, making it easier to manage and automate tasks such as maintenance, monitoring, and updates. Elastic Jobs provide a centralized way to manage and execute jobs across your databases.
upvoted 2 times
...
bingomutant
6 months, 2 weeks ago
A - elastic jobs - Elastic jobs are designed specifically for managing multiple Azure SQL databases using Transact-SQL in a centralized manner. They allow you to automate and schedule tasks like index maintenance, statistics updates, or query executions across multiple databases, which is exactly what is required in this scenario. Elastic jobs can target multiple databases in an Azure SQL Database environment, which makes them ideal for managing the 25 Azure SQL databases centrally
upvoted 1 times
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago