Administering a SQL Database Infrastructure — Question 211

You work as a Developer at ABC.com.
All databases are hosted on Windows Server 2012 servers running SQL Server 2012.
The company has a database named Products.
Tables in the Products database contain data including part numbers, product name, color, type and size.
Users in the Marketing department have created brochures for each product.
The brochures have been created in the XML Paper Specification (XPS) format.
You have been asked to add a table to the Products database to store the product brochures.
The brochures need to be stored in a folder structure.
Company users will also need to access the brochures from Windows applications using UNC paths. How can you meet these requirements?

Answer options

• A. By implementing the XMLNAMESPACES feature.
• B. By implementing the FILEGROUP feature.
• C. By implementing the FILETABLE feature.
• D. By implementing the FILESTREAM feature.

Correct answer: C

Explanation

The correct answer is C, as the FILETABLE feature allows for storing files in a structured format that can be accessed using UNC paths, meeting the requirement for brochure storage. Options A and B do not provide the necessary file system integration, while D, although related to file storage, does not offer the same folder structure and accessibility features as FILETABLE.