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

Question

Options

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

• A
  4% (1)
• B
  4% (1)
• C
  9% (2)
• D
  83% (19)

Explanation

We reduce the max length of the column from 400 to 200. Not A: Sparse column is useful when there are many null columns. The SQL Server Database Engine uses the SPARSE keyword in a column definition to optimize the storage of values in that column. Therefore, when the column value is NULL for any row in the table, the values require no storage. Not B, Not C: SQL Server 2005 got around the limitation of 8KB storage size and provided a workaround with varchar(max). It is a non-Unicode large variable- length character data type and can store a maximum of 2^31-1 bytes (2 GB) of non-Unicode characters. https://36chambers.wordpress.com/2020/06/18/nvarchar-everywhere-a-thought-experiment/

No community discussion yet for this question.