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

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Antonio at Jun 20, 2024, 07:55 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Marsha
4 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
4 months ago
A SQL Server Agent job? Seriously? That's so 2000s. Azure Function all the way, baby!
upvoted 0 times
Arleen
3 months ago
B: I agree, Azure Function would be a more modern choice for scheduling the statement.
upvoted 0 times
...
Levi
3 months ago
Azure Function all the way, baby!
upvoted 0 times
...
Lazaro
3 months ago
A: Azure Automation sounds like the way to go for this.
upvoted 0 times
...
Serina
4 months ago
A SQL Server Agent job? Seriously? That's so 2000s.
upvoted 0 times
...
...
Veta
4 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
3 months ago
Yeah, I agree. It's specifically designed for tasks like this.
upvoted 0 times
...
Jamey
4 months ago
I think Azure Automation would be the best choice for scheduling the statement.
upvoted 0 times
...
...
Abel
4 months ago
I agree with Mila, a SQL Server Agent job provides more flexibility and control for scheduling tasks.
upvoted 0 times
...
Jess
4 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
4 months ago
I think Azure Automation could also work well for scheduling the statement to run daily.
upvoted 0 times
...
Dolores
4 months ago
I agree, an elastic job does seem like the best option for this scenario.
upvoted 0 times
...
...
Mila
4 months ago
I disagree, I believe a SQL Server Agent job would be more appropriate for this task.
upvoted 0 times
...
Karl
5 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
4 months ago
An elastic job might be a good choice for this scenario as well.
upvoted 0 times
...
Lacey
4 months ago
I think Azure Automation could also work well for scheduling the Transact-SQL statement.
upvoted 0 times
...
Gwenn
4 months ago
I agree, a SQL Server Agent job is the best option for scheduling tasks like this.
upvoted 0 times
...
...
Merilyn
5 months ago
I think we should use Azure Automation to schedule the statement.
upvoted 0 times
...

Save Cancel