nerdexam
Microsoft

DP-300 · Question #71

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 - Poly

The correct answer is B. PolyBase. This table lists the key features for PolyBase and the products in which they're available. Incorrect Answers: C: Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications. It applies to both Azure SQL Database and SQL Server.

Submitted by emma.c· Mar 6, 2026Plan and implement data platform resources

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?

Exhibit

DP-300 question #71 exhibit

Options

  • AClustered columnstore indexes
  • BPolyBase
  • CChange tracking
  • DAutomatic tuning

How the community answered

(44 responses)
  • B
    95% (42)
  • C
    2% (1)
  • D
    2% (1)

Explanation

This table lists the key features for PolyBase and the products in which they're available. Incorrect Answers: C: Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications. It applies to both Azure SQL Database and SQL Server. D: Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak and stable workloads through continuous performance tuning based on AI and machine learning. https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice