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.
Question
Exhibit
Options
- AClustered columnstore indexes
- BPolyBase
- CChange tracking
- DAutomatic tuning
How the community answered
(44 responses)- B95% (42)
- C2% (1)
- D2% (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.
