You plan to create a new column in a disk-based 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.
Be able to simulate a file system.
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.
FileTable
B.
varbinary
C.
image
D.
FileStream
B – To specify that a column contains FILESTREAM data, you create a varbinary(max) column and add the FILESTREAM attribute.
https://docs.microsoft.com/en-us/sql/relational-databases/blob/create-a-table-for-storing-filestream-data?view=sql-server-2017
2
0