Developing Microsoft SQL Server Databases — Question 29

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.

Answer options

Correct answer: D

Explanation

The correct answer is FileStream because it allows for the storage of large binary data, supports access from .NET applications, and provides a file system-like structure. While FileTable can also store files, it is specifically designed for integration with SQL Server, making FileStream a better option for simulating a file system with large images.