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?
- A. Clustered columnstore indexes
- B. PolyBase Correct
- C. Change tracking
- D. Automatic tuning
Explanation
PolyBase is not supported in Azure SQL Database, so it must be removed or replaced, for example by using the data virtualization capabilities of OPENROWSET and external tables. Columnstore indexes are supported on the Premium, Standard S3 and above, General Purpose, Business Critical and Hyperscale tiers. Change tracking and automatic tuning are also available in Azure SQL Database.
