DRAG DROP
You have a SQL Azure database named Database1. You need to design the schema for a
table named table1.
Table1 will have less than one million rows. Table1 will contain the following information
for each row:
The solution must minimize the amount of space used to store each row. Which data
types should you recommend for each column? To answer, drag the appropriate data type to
the correct column in the answer area.
Answer: 
Explanation:
http://msdn.microsoft.com/en-US/library/ms187752.aspx
modified date is the tricky one here . smalldatetime is smaller than date but the accuracy is not the same so I don’t really know here . i would go for smalldatetime cause we care more about size !
Accuracy
DateTime is accurate to three-hundredths of a second.
SmallDateTime is accurate to one minute.
Size
DateTime takes up 8 bytes of storage space.
SmallDateTime takes up 4 bytes of storage space.
0
0
Sorry it is Date and not datetime… Date is smaller off course
1
0
Hello,
I think there is an issue with the question “Table1 will contain the following information for each row:” is followed by nothing.
Without information, for name I would go for nvarchar because naming could use unicode characters like in Chinese, Russian, etc.
a+,=)
-=Clement=-
1
0
Hello,
The name column should be support distinct languages, nvarchar
1
0