Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 10 Question 93 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 93
Topic #: 10
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Marsha
5 months ago
Well, if you want to keep things old-school, go with the SQL Server Agent job. But if you're feeling adventurous, try an Azure Automation solution. Just don't forget to update your resume with the latest Azure buzzwords.
upvoted 0 times
...
Eve
5 months ago
A SQL Server Agent job? Seriously? That's so 2000s. Azure Function all the way, baby!
upvoted 0 times
Arleen
4 months ago
B: I agree, Azure Function would be a more modern choice for scheduling the statement.
upvoted 0 times
...
Levi
4 months ago
Azure Function all the way, baby!
upvoted 0 times
...
Lazaro
4 months ago
A: Azure Automation sounds like the way to go for this.
upvoted 0 times
...
Serina
5 months ago
A SQL Server Agent job? Seriously? That's so 2000s.
upvoted 0 times
...
...
Veta
5 months ago
I'd go with the Azure Automation option. It's cloud-native and might have some cool features we're not even aware of.
upvoted 0 times
Aaron
5 months ago
Yeah, I agree. It's specifically designed for tasks like this.
upvoted 0 times
...
Jamey
5 months ago
I think Azure Automation would be the best choice for scheduling the statement.
upvoted 0 times
...
...
Abel
6 months ago
I agree with Mila, a SQL Server Agent job provides more flexibility and control for scheduling tasks.
upvoted 0 times
...
Jess
6 months ago
Hmm, an elastic job seems like the modern solution. It probably scales better and integrates more seamlessly with Azure.
upvoted 0 times
Armando
5 months ago
I think Azure Automation could also work well for scheduling the statement to run daily.
upvoted 0 times
...
Dolores
5 months ago
I agree, an elastic job does seem like the best option for this scenario.
upvoted 0 times
...
...
Mila
6 months ago
I disagree, I believe a SQL Server Agent job would be more appropriate for this task.
upvoted 0 times
...
Karl
6 months ago
A SQL Server Agent job sounds like the way to go. It's a tried and true method for scheduling maintenance tasks in SQL Server.
upvoted 0 times
Wilbert
5 months ago
An elastic job might be a good choice for this scenario as well.
upvoted 0 times
...
Lacey
5 months ago
I think Azure Automation could also work well for scheduling the Transact-SQL statement.
upvoted 0 times
...
Gwenn
6 months ago
I agree, a SQL Server Agent job is the best option for scheduling tasks like this.
upvoted 0 times
...
...
Merilyn
6 months ago
I think we should use Azure Automation to schedule the statement.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77