MENU
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?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
BE
Beth
11 months ago
Managed Instance seems like the perfect fit for minimizing effort.
TI
Tijuana
11 months ago
SQL Server on Azure VMs is too much hassle for this.
LE
Lennie
12 months ago
Wait, can Azure SQL Database really handle all that?
KI
Kina
12 months ago
Definitely agree, it supports SQL Server Agent!
OZ
Ozell
1 year ago
I think Azure SQL Managed Instance is the best choice here.
SE
Selene
1 year ago
I’m leaning towards D as well, but I wonder if there are any specific limitations with Azure SQL Managed Instance that might affect our migration.
JE
Jerry
1 year ago
I practiced a similar question, and I feel like SQL Server on Azure Virtual Machines could work, but it might require more management than we want.
VI
Vi
1 year ago
I'm not entirely sure, but I remember that Azure SQL Database doesn't support SQL Server Agent, so it can't be the right choice.
MA
Madalyn
1 year ago
I think the answer might be D, Azure SQL Managed Instance, since it supports SQL Server Agent and is closer to the full SQL Server experience.
AL
Alline
1 year ago
Okay, let me see. The Export command creates a file, and I think option C is correct - you do have to give the file a name. I'm not sure about the other options though, so I'll have to double-check those.
AI
Aileen
1 year ago
I think the answer is A. The arp command is used to display the ARP cache, which contains the MAC addresses of devices on the local network.
MA
Maryann
1 year ago
This seems like a straightforward data recovery question. I'd start by looking at the tools related to email and file recovery, like FINALeMAIL and R-mail.
PH
Phung
1 year ago
Wait, what's the difference between Mobility Express and a regular wireless controller? I need to make sure I understand that first.
JU
Julie
1 year 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.
NE
Nettie
1 year ago
D) Azure SQL Managed Instance
AL
Almeta
1 year ago
Managed Instance is definitely the best choice for this scenario.
SH
Shalon
1 year ago
D) Azure SQL Managed Instance
CA
Carlee
1 year ago
C) an Azure SQL Database elastic pool
AL
Alisha
1 year ago
B) Azure SQL Database
JU
Juliann
1 year ago
A) SQL Server on Azure Virtual Machines
NO
Novella
1 year ago
SQL Database is a no-go for me. Gotta have that SQL Server Agent support, am I right? *winks*
TA
Tanesha
1 year ago
Definitely D) Azure SQL Managed Instance. It supports SQL Server Agent service.
OR
Orville
1 year ago
D) Azure SQL Managed Instance
KR
Kristin
1 year ago
A) SQL Server on Azure Virtual Machines
LE
Leota
1 year 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.
SC
Scarlet
2 years ago
But wouldn't Azure SQL Database also meet the requirements? It's a fully managed service and would minimize administrative effort.
KA
Kaycee
2 years ago
I agree with Barbra. Azure SQL Managed Instance supports the latest version of SQL Server and the SQL Server Agent service.
MA
Margart
2 years ago
Azure SQL Managed Instance is the way to go! It meets all the requirements and minimizes administrative effort.
JO
Josephine
1 year ago
Azure SQL Managed Instance is the way to go! It meets all the requirements and minimizes administrative effort.
LA
Lai
1 year ago
D) Azure SQL Managed Instance
AB
Abel
1 year ago
C) an Azure SQL Database elastic pool
LO
Loren
1 year ago
B) Azure SQL Database
RE
Reyes
1 year ago
A) SQL Server on Azure Virtual Machines
BA
Barbra
2 years ago
I think we should use Azure SQL Managed Instance for the migration.