You are designing a document repository application that will contain over 100,000
documents. The repository will have the following specifications: ·Documents can be
associated to 30 different properties ·Most documents will have less than 10 properties
defined You need to design a single table for the application. The solution must use the
minimum the amount of storage space. What should you include in the design?
A.
varchar(max) not null
B.
an XML data type
C.
nvarchar() null
D.
sparse columns