Which options should you recommend?

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the
following specifications:
Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of
the time.
Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the
storage requirements for the tables. Which options should you recommend? To answer, drag the appropriate
options to the correct column in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the
following specifications:
Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of
the time.
Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the
storage requirements for the tables. Which options should you recommend? To answer, drag the appropriate
options to the correct column in the answer area.
Select and Place:

Answer:

Explanation:
http://msdn.microsoft.com/en-us/library/cc280604.aspx
http://msdn.microsoft.com/en-us/library/ms186241.aspx



Leave a Reply 0

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