You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will store multilingual data. The database will contain a table that has
100 million rows. The table will contain 1,000 columns that are based on the nvarchar(max)
data type. For each column, only 2 percent of the rows will be populated. You need to
design the table to optimize storage space. What should you do?
A.
Use row compression.
B.
Use NTFS file system compression to reduce the disk space used.
C.
Define the columns as sparse columns.
D.
Change the column data types to varchar(max).