DP-300 Certification Practice Question #4

Question

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
✑ Clustered columnstore indexes
✑ Automatic tuning
✑ Change tracking
✑ PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?

Accepted Answer

PolyBase is a feature used in SQL Server on-premises and Azure Synapse Analytics for querying external data sources, but it is not supported in Azure SQL Database. Therefore, PolyBase must be removed or replaced (for example, with Elastic Query or `OPENROWSET` for file querying) before migrating DB1. The other listed features (clustered columnstore indexes, change tracking, and automatic tuning) are natively supported in Azure SQL Database.

More DP-300 practice questions