Microsoft
70-451 · Question #16
You are a database developer. You plan to design a database solution by using SQL Server 2008. A table in a database will store large image files (20-50 MB in size). You have the following business…
The correct answer is C. Use the varbinary(max) data type along with the FILESTREAM attribute. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. A table in a database will store large image files (20-50 MB in size). You have the following business requirements:
- The image files are accessible by applications that use Win32 APIs.
- The image files are part of the database backup.
- You need to identify an appropriate strategy to store the image
files. Which strategy should you use?
Options
- AUse an image data type.
- BUse the varbinary(max) data type.
- CUse the varbinary(max) data type along with the FILESTREAM attribute.
- DStore the image file in a file system. Use a varchar data type to store the file location in the
How the community answered
(33 responses)- A6% (2)
- B3% (1)
- C76% (25)
- D15% (5)
Community Discussion
No community discussion yet for this question.