Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 6 Question 7 Discussion

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

Microsoft DP-300 Exam - Topic 6 Question 7 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 7
Topic #: 6
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
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

by Zona at May 05, 2022, 11:03 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Kiley
10 months ago
Surprised to hear about PolyBase, I thought it was more flexible!
upvoted 0 times
...
Alesia
10 months ago
Automatic tuning is fine, right? No need to remove that!
upvoted 0 times
...
Nada
11 months ago
Wait, I thought Change tracking was the issue?
upvoted 0 times
...
Cassie
11 months ago
Totally agree, PolyBase isn't supported in Azure SQL.
upvoted 0 times
...
Elbert
11 months ago
PolyBase needs to go before migration.
upvoted 0 times
...
Sabra
11 months 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.
upvoted 0 times
...
Franklyn
11 months 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.
upvoted 0 times
...
Evangelina
11 months ago
I'm not entirely sure, but I remember something about clustered columnstore indexes being supported in Azure SQL.
upvoted 0 times
...
Dahlia
11 months ago
I think PolyBase might be the one that needs to be replaced since it has limited support in Azure SQL Database.
upvoted 0 times
...
Brock
11 months 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.
upvoted 0 times
...
Leslie
11 months 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.
upvoted 0 times
...
Arleen
11 months 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.
upvoted 0 times
...
Frankie
11 months 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.
upvoted 0 times
...

Save Cancel