Exam 70-765 topic 4 question 33 discussion

Actual exam question from Microsoft's 70-765

Question #: 33
Topic #: 4

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?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by jolsca at Sept. 11, 2020, 4:38 a.m.

Comments

Submit Cancel

munro1900

4 years, 5 months ago

Tricky because the Elastic Job cmdlets come with the Az.Sql module so technically there isn't an "Elastic Database jobs PowerShell package" per se. To schedule 1 job running on 1 instance you have the native SQL jobs available in Azure as well so you don't need to add extra functionality for this.

upvoted 2 times

...

jolsca

4 years, 9 months ago

Correct is YES. Elastic Database Jobs (preview) are Job Scheduling services that execute custom jobs on one or many databases in Azure SQL Database. https://docs.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview

upvoted 3 times

...