DRAG DROP
You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2
thatwill have the following specifications:
Table1 will contain a date column named Column1 that will contain a nullvalue
approximately 80 percent of the time.
Table2 will contain a column named Column2 that is the product of twoother 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
mustminimize 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.
Explanation:
http://msdn.microsoft.com/en-us/library/cc280604.aspx
http://msdn.microsoft.com/en-us/library/ms186241.aspx
Col1:Sparse
Col2:Persisted computed
similar question:70-465 (v.1) Q25
Sorry
“minimize the storage requirements”
Col2 is computed,not Persisted computed