You develop a database for a travel application. You need to design tables and other database objects.
You need to store media files in several tables.
Each media file is less than 1 MB in size. The media files will require fast access and will be retrieved frequently.
What should you do?
A . Use the CAST function.
B . Use the DATE data type.
C . Use the FORMAT function.
D . Use an appropriate collation.
E . Use a user-defined table type.
F . Use the VARBINARY data type.
G . Use the DATETIME data type.
H . Use the DATETIME2 data type.
. Use the DATETIMEOFFSET data type.
. Use the TODATETIMEOFFSET function.
Answer: F
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms188362.aspx