DP-300 Certification Practice Question #208

Question

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?

Accepted Answer

To centrally manage and run Transact-SQL scripts across multiple (25) Azure SQL databases, **Elastic Jobs** are the designated native feature. Elastic Jobs allow you to define jobs composed of T-SQL steps and execute them in parallel against a target group of databases, which is ideal for schema updates, index rebuilds, and data collection. Although Azure Automation runbooks (option B), Azure Functions (option C), and Azure Logic Apps (option D) can interact with SQL databases, they are not native T-SQL-based database management tools and require additional custom coding and scheduling overhead.

More DP-300 practice questions