Microsoft
70-451 · Question #17
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…
The correct answer is C. sparse columns. See the full explanation below for the reasoning.
Question
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?
Options
- Aan XML data type
- Bnvarchar() null
- Csparse columns
- Dvarchar(max) not null
How the community answered
(38 responses)- A3% (1)
- B5% (2)
- C82% (31)
- D11% (4)
Community Discussion
No community discussion yet for this question.