Microsoft Exam DP-300 Topic 12 Question 94 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 94
Topic #: 12

[All DP-300 Questions]

You have an Azure SQL database named DB1.

You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.

During a database audit, you discover that none of the fields contain more than 150 characters.

You need to ensure that you can apply page compression to Table1.

What should you do?

AConfigure the columns as sparse.

BChange the column type to nvarchar (MAX).

CChange the column type to varchar (MAX).

DChange the column type to varchar (200).

Show Suggested Answer

Suggested Answer: D, E

by Lenny at Jun 29, 2024, 01:57 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Marci

18 days ago

I'm no database expert, but I'm pretty sure option A, configuring the columns as sparse, is a completely different feature. Someone's trying to trick us here!

upvoted 0 times

...

Ona

19 days ago

Hold up, why are we even using CHAR in the first place? Shouldn't we be using VARCHAR to begin with? I'd go with option C and change it to varchar (MAX).

upvoted 0 times

...

Tammy

23 days ago

Woah, 400 characters for a CHAR field? That's overkill! I'd go with option D and change it to varchar (200). Less memory usage, and it still covers the 150 character limit.

upvoted 0 times

...

2 months ago

I think we should change the column type to varchar (200) to apply page compression.

upvoted 0 times

...