Microsoft
70-457 · Question #21
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…
The correct answer is F. Use the VARBINARY data type. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the CAST function.
- BUse the DATE data type.
- CUse the FORMAT function.
- DUse an appropriate collation.
- EUse a user-defined table type.
- FUse the VARBINARY data type.
- GUse the DATETIME data type.
- HUse the DATETIME2 data type.
- JUse the TODATETIMEOFFSET function.
How the community answered
(61 responses)- C2% (1)
- E2% (1)
- F84% (51)
- G8% (5)
- H5% (3)
Community Discussion
No community discussion yet for this question.