FEFreeExamDumps.in

Administering Microsoft Azure SQL Solutions

28 / 296← PrevNext →
Topic 1

Question 28

DP-300 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.

Details →

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).

More DP-300 practice questions