What should you include in the design?

Correct Answer for the following Question is given below

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 definedYou need to design a single table for the application. The solution must use the minimum amount of storage space.What should you include in the design?Taking into account that we need to design a single table, this table will containt rows most of which will have NULL in more than 20 columns. Because our solution must use the minimum amount of storage space, we should use sparse columns.Sparse columns are ordinary columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values. Consider using sparse columns when the space saved is at least 20 percent to 40 percent.


What should you include in the design?


an XML data type

nvarchar() null

sparse columns

varchar(max) not null

Correct Answer

The Correct Answer for this Question is

sparse columns


The Question – What should you include in the design? has been answered correctly and answers for the question is sparse columns

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *