DP-300 · Question #301
DP-300 Question #301: Real Exam Question with Answer & Explanation
The correct answer is C: an elastic job. With Azure Automation, you can manage databases in Azure SQL Database by using the latest Az PowerShell cmdlets that are available in Azure Az PowerShell. Elastic jobs would use T-SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic- jobs-tsql-create-manage?vie
Question
You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statement to run once daily against each database by using Transact- SQL commands. What should you use to schedule the statement?
Options
- Aan Azure function
- Ba SQL Server Agent Job
- Can elastic job
- DAzure Automation
Explanation
With Azure Automation, you can manage databases in Azure SQL Database by using the latest Az PowerShell cmdlets that are available in Azure Az PowerShell. Elastic jobs would use T-SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic- jobs-tsql-create-manage?view=azuresql-db
Community Discussion
No community discussion yet for this question.