ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 1 question 4 discussion

Actual exam question from Microsoft's DP-300
Question #: 4
Topic #: 1
[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?

  • A. Clustered columnstore indexes
  • B. PolyBase
  • C. Change tracking
  • D. Automatic tuning
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by ovokpus at Aug. 28, 2021, 3:05 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
pozdrotechno
Highly Voted 1 year, 1 month ago
Selected Answer: B
B is correct. PolyBase is not supported by Azure SQL Database according to https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary
upvoted 9 times
...
sincerebb
Most Recent 3 weeks, 5 days ago
Selected Answer: B
answer b
upvoted 1 times
...
Backy
9 months, 3 weeks ago
Polybase has many features and installs differently on different variants of SQL server. The table shows that SQL Database supports one of the features meaning it does partially supports Polybase. Probably, the issue here is that Azure SQL Database has its own Polybase which is different than on-premises Polybase and this could create some errors during migration
upvoted 2 times
...
ladywhiteadder
1 year ago
Selected Answer: B
B is correct
upvoted 3 times
...
matongax
1 year, 7 months ago
looks correct according to the pic above
upvoted 3 times
...
o2091
1 year, 7 months ago
for me this is correct
upvoted 4 times
...
ovokpus
1 year, 8 months ago
No comments?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago