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
Ozell
4 days ago
Totally agree, Managed Instance supports those features!
upvoted 0 times
...
Aracelis
10 days ago
C) Azure SQL Managed Instance is the best choice for FileTables.
upvoted 0 times
...
Vinnie
15 days 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
20 days 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
25 days 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
2 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