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

Sophia

6 days ago

Hmm, I'm thinking option B. Changing the column type to nvarchar (MAX) seems like the way to go. That'll allow for the page compression to work its magic.

upvoted 0 times

...

Lorita

9 days ago

I'm not sure, maybe we should consider configuring the columns as sparse instead.

upvoted 0 times

...

Arthur

10 days ago

I agree with Chantell, changing the column type to varchar (200) seems like the right choice.

upvoted 0 times

...

Chantell

14 days ago

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

upvoted 0 times

...