Provisioning SQL Databases — Question 52

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You install the Elastic Database jobs PowerShell package, and then you create an Elastic Database job.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not meet the goal because while the Elastic Database jobs PowerShell package is helpful, it does not inherently schedule the job to run at the specified time. Azure SQL Database requires a scheduling mechanism, such as Azure Logic Apps or Azure Functions, to automate the execution of Transact-SQL scripts at a specific time.