What should you do?

Note: This question is part of a series of questions that use the same set of answer choices. An

answer choice may be correct for more than one question in the series.

You develop a database for a travel application. You need to design tables and other database objects.

You create the Historical_Events table.

You need to store dates by using the smallest possible storage size.

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.

View Answer

Answer: B

Explanation:

The size of a column with the DATE format is 3 bytes fixed.