nerdexam
Microsoft

70-465 · Question #95

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…

The correct answer is C. By implementing the FILETABLE feature. This question tests knowledge of SQL Server's FILETABLE feature, which enables storing unstructured files in SQL Server while allowing Windows application access via UNC paths and a folder hierarchy.

Submitted by ahmad_uae· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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?

Options

  • ABy implementing the XMLNAMESPACES feature.
  • BBy implementing the FILEGROUP feature.
  • CBy implementing the FILETABLE feature.
  • DBy implementing the FILESTREAM feature.

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    8% (3)
  • C
    74% (28)
  • D
    16% (6)

Why each option

This question tests knowledge of SQL Server's FILETABLE feature, which enables storing unstructured files in SQL Server while allowing Windows application access via UNC paths and a folder hierarchy.

ABy implementing the XMLNAMESPACES feature.

XMLNAMESPACES is a T-SQL clause used to declare XML namespaces in XQuery expressions and has no capability to store files, create folder structures, or provide UNC path access.

BBy implementing the FILEGROUP feature.

FILEGROUP is a logical database storage grouping used to organize data files for administrative and performance purposes, but it does not provide a folder structure for storing documents or UNC path access for Windows applications.

CBy implementing the FILETABLE feature.Correct

FILETABLE is a specialized table type built on top of FILESTREAM that stores files and documents in a hierarchical folder structure within SQL Server. It exposes the stored files via a Windows UNC path (e.g., \\server\instance\FiletableDirectory\TableName), allowing Windows applications to access the XPS brochures directly using standard file I/O without any SQL knowledge, which satisfies both the folder structure and UNC path access requirements.

DBy implementing the FILESTREAM feature.

FILESTREAM enables storing unstructured binary data (BLOBs) in the file system integrated with SQL Server, but unlike FILETABLE it does not automatically create a Windows-accessible folder hierarchy or expose files via UNC paths for direct Windows application access without custom code.

Concept tested: SQL Server FILETABLE for file storage and UNC access

Source: https://learn.microsoft.com/en-us/sql/relational-databases/blob/filetables-sql-server

Topics

#FILETABLE#FILESTREAM#Unstructured data storage#SQL Server integration

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice