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?

The correct answer is B. SQL Server on an Azure Virtual Machine. SQL Server VM alternative. Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database. If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM)…

Submitted by anjalisingh· Mar 6, 2026Plan and implement data platform resources

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?

Options

AAzure SQL Database
BSQL Server on an Azure Virtual Machine
CAzure SQL Managed Instance
DAzure Database for MySQL

How the community answered

(24 responses)

A
8% (2)
B
71% (17)
C
17% (4)
D
4% (1)

Explanation

SQL Server VM alternative. Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database. If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead: * You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions. https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql- database-overview

Topics

#FileTables#Filestream#SQL Server on Azure VMs#feature compatibility

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice