PrepAway - Latest Free Exam Questions & Answers

Which strategy should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the varbinary(max) data type.

B.
Use the varbinary(max) data type along with the FILESTREAM attribute.

C.
Use an image data type.

D.
Store the image file in a file system. Use a varchar data type to store the file location in
the database.


Leave a Reply