PrepAway - Latest Free Exam Questions & Answers

What should you include in the design?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
an XML data type

B.
nvarchar() null

C.
sparse columns

D.
varchar(max) not null


Leave a Reply