Deal of The Day! 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 DP-300 Exam - Topic 10 Question 93 Discussion

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?
A) Azure Automation
B) an elastic job
C) a SQL Server Agent job
D) an Azure function

Microsoft DP-300 Exam - 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:

0/2000 characters
Submit Cancel
Avery
6 months ago
I thought Azure Functions could handle scheduling too, but not sure.
upvoted 0 times
...
Justa
7 months ago
Wait, can you really use Azure Automation for this? Seems off.
upvoted 0 times
...
Georgeanna
7 months ago
SQL Server Agent jobs won't work in Azure SQL Database, just a heads up.
upvoted 0 times
...
Justa
7 months ago
Totally agree, elastic jobs are perfect for this!
upvoted 0 times
...
Natalie
7 months ago
I think an elastic job is the way to go for multiple databases.
upvoted 0 times
...
Veronika
8 months ago
I vaguely recall that Azure Functions can be used for automation, but I don't think they are meant for scheduling SQL tasks like this.
upvoted 0 times
...
Yolande
8 months ago
I feel like SQL Server Agent jobs are more common in on-prem setups, so I'm uncertain if they apply here in Azure.
upvoted 0 times
...
Melissa
8 months ago
I practiced a similar question where we had to schedule jobs, and I think elastic jobs might be the right choice for running tasks across multiple databases.
upvoted 0 times
...
Aimee
8 months ago
I think I remember something about Azure Automation, but I'm not sure if that's the best option for scheduling tasks like this.
upvoted 0 times
...
Jules
8 months ago
I think the answer is B - an elastic job. That's the Azure service designed for running Transact-SQL statements across multiple databases on a schedule. The question is pretty straightforward, so I'm feeling good about this one.
upvoted 0 times
...
Lauran
8 months ago
I'm a little confused by the options. Azure Automation and Azure Functions both seem like they could work, but I'm not sure which one is the most appropriate for this specific use case. I'll need to review the details of each option more carefully.
upvoted 0 times
...
Nickolas
8 months ago
Okay, let's see. We need to run a Transact-SQL statement daily against 20 databases. That sounds like a job for an elastic job to me. I'm pretty confident that's the right solution here.
upvoted 0 times
...
Antonio
8 months ago
This looks like a straightforward question about scheduling a Transact-SQL statement to run against multiple Azure SQL databases. I think the key is to identify the best Azure service or tool for scheduling this type of task.
upvoted 0 times
...
Thurman
8 months ago
Hmm, I'm a bit unsure about this one. I know Azure Automation can be used for scheduling tasks, but I'm not sure if that's the best option here. I'll need to think through the pros and cons of the different choices.
upvoted 0 times
...
Carlee
8 months ago
Hmm, I'm not sure if that's the best approach. Debugging the third-party code might be a better way to go, to see if there are any performance issues we can fix directly.
upvoted 0 times
...
Leonardo
8 months ago
This is a tricky one. I'll need to review my notes on AWS networking and how the VM-Series NGFW integrates with the cloud infrastructure.
upvoted 0 times
...
Royal
8 months ago
I think the PUT command is used for modifying configurations based on similar practice questions we went over.
upvoted 0 times
...
Blondell
8 months ago
Could it be C? I vaguely remember discussions about JMX and server management, but I'm not sure what operations are specifically allowed.
upvoted 0 times
...
Marsha
2 years 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
2 years ago
A SQL Server Agent job? Seriously? That's so 2000s. Azure Function all the way, baby!
upvoted 0 times
Arleen
2 years ago
B: I agree, Azure Function would be a more modern choice for scheduling the statement.
upvoted 0 times
...
Levi
2 years ago
Azure Function all the way, baby!
upvoted 0 times
...
Lazaro
2 years ago
A: Azure Automation sounds like the way to go for this.
upvoted 0 times
...
Serina
2 years ago
A SQL Server Agent job? Seriously? That's so 2000s.
upvoted 0 times
...
...
Veta
2 years 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
2 years ago
Yeah, I agree. It's specifically designed for tasks like this.
upvoted 0 times
...
Jamey
2 years ago
I think Azure Automation would be the best choice for scheduling the statement.
upvoted 0 times
...
...
Abel
2 years ago
I agree with Mila, a SQL Server Agent job provides more flexibility and control for scheduling tasks.
upvoted 0 times
...
Jess
2 years ago
Hmm, an elastic job seems like the modern solution. It probably scales better and integrates more seamlessly with Azure.
upvoted 0 times
Armando
2 years ago
I think Azure Automation could also work well for scheduling the statement to run daily.
upvoted 0 times
...
Dolores
2 years ago
I agree, an elastic job does seem like the best option for this scenario.
upvoted 0 times
...
...
Mila
2 years ago
I disagree, I believe a SQL Server Agent job would be more appropriate for this task.
upvoted 0 times
...
Karl
2 years 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
2 years ago
An elastic job might be a good choice for this scenario as well.
upvoted 0 times
...
Lacey
2 years ago
I think Azure Automation could also work well for scheduling the Transact-SQL statement.
upvoted 0 times
...
Gwenn
2 years ago
I agree, a SQL Server Agent job is the best option for scheduling tasks like this.
upvoted 0 times
...
...
Merilyn
2 years ago
I think we should use Azure Automation to schedule the statement.
upvoted 0 times
...

Save Cancel