DP-300 Certification Practice Question #26

Question

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?

Accepted Answer

FileStream and FileTable are SQL Server features that depend on Windows file-system integration and are not available in either Azure SQL Database or Azure SQL Managed Instance (both PaaS services that abstract the file system). Microsoft's own migration guide explicitly calls this out as a scenario requiring SQL Server on an Azure Virtual Machine. All community votes and the suggested answer agree on B, with zero dissent.

More DP-300 practice questions