You plan to create a new column in a table. The column must meet the following
requirements:
Be able to store images that are larger than 1 MB each.
Be able to access the images from Microsoft .NET Framework applications.
You need to recommend which data type must be used in the column.
Which data type should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A.
nvarchar
B.
varbinary
C.
image
D.
FileStream
FIleStram is not a data type.
https://msdn.microsoft.com/en-us/library/ms187752.aspx
[Chart] VARBINARY(MAX) FILESTREAM NULL
But:
https://msdn.microsoft.com/en-us/library/gg471497.aspx?f=255&MSPPError=-2147217396#Anchor_1
and here we have a condition of storinh images that are larger than 1 MB each.
In this case MSDN says:
If the following conditions are true, you should consider using FILESTREAM:
-Objects that are being stored are, on average, larger than 1 MB.
-Fast read access is important.
-You are developing applications that use a middle tier for application logic.
To store images filestream should be used, that’s true. BUT filestream is not a datatype.
FILESTREAM storage is implemented as a varbinary(max) column in which the data is stored as BLOBs in the file system.
B is correct – VARBINARY
FILESTREAM is not a data type; instead, it is an attribute that can be assigned to a VARBINARY (MAX) column. When the FILESTREAM attribute of a VARBINARY (MAX) column is set, it becomes a ‘FILESTREAM enabled’ column