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?

AAzure Automation

Ban elastic job

Ca SQL Server Agent job

Dan Azure function

Show Suggested 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

6 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

6 months ago

A SQL Server Agent job? Seriously? That's so 2000s. Azure Function all the way, baby!

upvoted 0 times

Arleen

5 months ago

B: I agree, Azure Function would be a more modern choice for scheduling the statement.

upvoted 0 times

...

Levi

5 months ago

Azure Function all the way, baby!

upvoted 0 times

...

Lazaro

5 months ago

A: Azure Automation sounds like the way to go for this.

upvoted 0 times

...

Serina

6 months ago

A SQL Server Agent job? Seriously? That's so 2000s.

upvoted 0 times

...

Veta

6 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

6 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

6 months ago

I think Azure Automation could also work well for scheduling the statement to run daily.

upvoted 0 times

...

Dolores

6 months ago

I agree, an elastic job does seem like the best option for this scenario.

upvoted 0 times

...

Mila

7 months ago

I disagree, I believe a SQL Server Agent job would be more appropriate for this task.

upvoted 0 times

...

Karl

7 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

6 months ago

An elastic job might be a good choice for this scenario as well.

upvoted 0 times

...

Lacey

6 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

7 months ago

I think we should use Azure Automation to schedule the statement.

upvoted 0 times

...