What should you include in the recommendation?

You need to recommend a solution that addresses the file storage requirements.

What should you include in the recommendation?
A . FileStream
B . FileTable
C . The varbinary data type
D . The image data type

View Answer

Answer: B

Explanation:

* Scenario: File Storage Requirements

The ERP database stores scanned documents that are larger than 2 MB. These files must only be accessed through the ERP application. File access must have the best possible read and write performance.

* FileTables remove a significant barrier to the use of SQL Server for the storage and management of unstructured data that is currently residing as files on file servers. Enterprises can move this data from file servers into FileTables to take advantage of integrated administration and services provided by SQL Server. At the same time, they can maintain Windows application compatibility for their existing Windows applications that see this data as files in the file system.