Administering Microsoft SQL Server 2012/2014 Databases — Question 64

You plan to install a Microsoft SQL Server 2012 instance.
The instance will support a database that has the following requirements:
✑ Store Excel workbooks on the file system.
✑ Access the workbooks through Transact-SQL.
✑ Include the workbooks in database backups.
During installation, you need to ensure that the requirements will be met.
Which feature should you use?

Answer options

Correct answer: B

Explanation

The correct answer is B, FILESTREAM, as it allows SQL Server to store large binary files, such as Excel workbooks, directly in the file system while still being able to access them through Transact-SQL and include them in database backups. The other options, while related to data management, do not fulfill all the specified requirements: Excel Services focuses on web-based Excel applications, SSIS is primarily for data integration and transformation, and OpenXML is a format for manipulating Office documents rather than a storage solution.