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

Microsoft Exam DP-300 Topic 11 Question 67 Discussion

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

You have a Microsoft SQL Server 2017 server.

You need to migrate the server to Azure. The solution must meet the following requirements:

* Ensure that the latest version of SQL Server is used.

* Support the SQL Server Agent service.

Minimize administrative effort.

What should you use?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Julie
1 months ago
Haha, can you imagine trying to run SQL Server Agent on an Azure SQL Database? Talk about a headache! Managed Instance is the clear winner here.
upvoted 0 times
Alisha
3 days ago
B) Azure SQL Database
upvoted 0 times
...
Juliann
15 days ago
A) SQL Server on Azure Virtual Machines
upvoted 0 times
...
...
Novella
1 months ago
SQL Database is a no-go for me. Gotta have that SQL Server Agent support, am I right? *winks*
upvoted 0 times
Kristin
1 months ago
A) SQL Server on Azure Virtual Machines
upvoted 0 times
...
...
Leota
1 months ago
I'm torn between SQL Server on Azure VMs and Azure SQL Managed Instance. Both seem viable, but I'm leaning towards Managed Instance for the lower maintenance.
upvoted 0 times
...
Scarlet
2 months ago
But wouldn't Azure SQL Database also meet the requirements? It's a fully managed service and would minimize administrative effort.
upvoted 0 times
...
Kaycee
2 months ago
I agree with Barbra. Azure SQL Managed Instance supports the latest version of SQL Server and the SQL Server Agent service.
upvoted 0 times
...
Margart
2 months ago
Azure SQL Managed Instance is the way to go! It meets all the requirements and minimizes administrative effort.
upvoted 0 times
Josephine
11 days ago
Azure SQL Managed Instance is the way to go! It meets all the requirements and minimizes administrative effort.
upvoted 0 times
...
Lai
13 days ago
D) Azure SQL Managed Instance
upvoted 0 times
...
Abel
17 days ago
C) an Azure SQL Database elastic pool
upvoted 0 times
...
Loren
30 days ago
B) Azure SQL Database
upvoted 0 times
...
Reyes
1 months ago
A) SQL Server on Azure Virtual Machines
upvoted 0 times
...
...
Barbra
2 months ago
I think we should use Azure SQL Managed Instance for the migration.
upvoted 0 times
...

Save Cancel