Discuss Microsoft DP-300 Exam Topic 6 Question 7

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?

AClustered columnstore indexes

BPolyBase

CChange tracking

DAutomatic tuning

Suggested Answer: B

This table lists the key features for PolyBase and the products in which they're available.

https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

13 comments · newest first

Kiley 12 months ago

Surprised to hear about PolyBase, I thought it was more flexible!

Alesia 1 year ago

Automatic tuning is fine, right? No need to remove that!

Nada 1 year ago

Wait, I thought Change tracking was the issue?

Cassie 1 year ago

Totally agree, PolyBase isn't supported in Azure SQL.

Elbert 1 year ago

PolyBase needs to go before migration.

Sabra 1 year ago

Change tracking seems like it could be okay to keep, but I can't recall if there are any specific limitations in Azure SQL.

Franklyn 1 year ago

I practiced a similar question, and I feel like automatic tuning is actually supported in Azure SQL, so it shouldn't be the one to remove.

Evangelina 1 year ago

I'm not entirely sure, but I remember something about clustered columnstore indexes being supported in Azure SQL.

Dahlia 1 year ago

I think PolyBase might be the one that needs to be replaced since it has limited support in Azure SQL Database.

Brock 1 year ago

This seems like a straightforward question about CCMM tools. I'll focus on remembering the key functionality of each tool and match it to the question.

Leslie 1 year ago

The question mentions the "default" behavior, so I'm guessing the ENIs don't get hibernated or paused. I'll eliminate those options and go with either A or B.

Arleen 1 year ago

I remember we discussed how unresolved conflicts usually lead to one side taking precedence, but I can't quite recall if it's supply or demand.

Frankie 1 year ago

Hmm, I'm not totally sure how to do the indent part. I'll need to look around in the alignment options to figure that out.

Microsoft DP-300 Exam - Topic 6 Question 7 Discussion