Microsoft
70-465 · Question #57
You need to recommend a solution that addresses the file storage requirements. What should you include in the recommendation?
The correct answer is B. FileTable. 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…
Submitted by certguy· Mar 5, 2026Design and implement database solutions for SQL Server
Question
You need to recommend a solution that addresses the file storage requirements. What should you include in the recommendation?
Options
- AFileStream
- BFileTable
- CThe varbinary data type
- DThe image data type
How the community answered
(33 responses)- A3% (1)
- B76% (25)
- C6% (2)
- D15% (5)
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.
Topics
#FileTable#FILESTREAM#Large object storage#File system integration
Community Discussion
No community discussion yet for this question.