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 DP-300 Exam - Topic 2 Question 129 Discussion

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL Which service should you use?
A) SQL Server on Azure VM
B) Azure SQL Database
C) Azure SQL Managed Instance
D) Azure Database for MySQL

Microsoft DP-300 Exam - Topic 2 Question 129 Discussion

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

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL Which service should you use?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters
Anissa
4 days ago
I feel like B is too limiting for this scenario.
upvoted 0 times
...
Ellsworth
9 days ago
A is also a good option, but it’s more complex.
upvoted 0 times
...
Gearldine
14 days ago
Agreed! C makes sense for compatibility.
upvoted 0 times
...
Shonda
19 days ago
I think C is the best choice. Managed Instance supports FileTables.
upvoted 0 times
...
Edna
25 days ago
I'm surprised there's no option for just a straight migration!
upvoted 0 times
...
Mable
30 days ago
Wait, does that mean we can't use FileTables in Azure SQL Database?
upvoted 0 times
...
Fidelia
1 month ago
Definitely agree with Managed Instance, it supports FileTables!
upvoted 0 times
...
Bobbye
1 month ago
I thought Azure SQL Database could handle it too?
upvoted 0 times
...
Slyvia
2 months ago
C) Azure SQL Managed Instance is the way to go!
upvoted 0 times
...
Anna
2 months ago
A) SQL Server on Azure VM could work, but it's more complex.
upvoted 0 times
...
Aileen
2 months ago
Definitely not D, that's for MySQL!
upvoted 0 times
...
Olga
2 months ago
Wait, are you sure? I thought Azure SQL Database could handle it too.
upvoted 0 times
...
Ozell
2 months ago
Totally agree, Managed Instance supports those features!
upvoted 0 times
...
Aracelis
2 months ago
C) Azure SQL Managed Instance is the best choice for FileTables.
upvoted 0 times
...
Vinnie
3 months ago
I vaguely recall that SQL Server on Azure VM is more like a lift-and-shift option, but I think Managed Instance is better for compatibility with on-prem features.
upvoted 0 times
...
Jolanda
3 months ago
I’m not entirely sure, but I feel like Azure SQL Database might not support FileTables, so that might not be the right choice.
upvoted 0 times
...
Rolande
3 months ago
I remember practicing a question about migrating SQL Server features, and I think Azure SQL Managed Instance was the answer because it supports more SQL Server features.
upvoted 0 times
...
Hannah
4 months ago
I think we discussed that FileTables and Filestream are specific to SQL Server, so I’m leaning towards options that support those features.
upvoted 0 times
...

Save Cancel