70-465 · Question #106
You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.
The correct answer is B. Enable FILESTREAM on the Server Instance. D. Create a non-empty FILESTREAM file group. F. Set the FILESTREAM directory name on the Database. FileTables in SQL Server 2012 require a specific three-part configuration: FILESTREAM must be enabled at the instance level, a FILESTREAM filegroup must exist in the database, and a directory name must be set on the database to support the NT file namespace.
Question
Options
- ADisable FILESTREAM on the Database.
- BEnable FILESTREAM on the Server Instance.
- CConfigure the Database for Partial Containment.
- DCreate a non-empty FILESTREAM file group.
- EEnable Contained Databases on the Server Instance.
- FSet the FILESTREAM directory name on the Database.
How the community answered
(27 responses)- A7% (2)
- B78% (21)
- C4% (1)
- E11% (3)
Why each option
FileTables in SQL Server 2012 require a specific three-part configuration: FILESTREAM must be enabled at the instance level, a FILESTREAM filegroup must exist in the database, and a directory name must be set on the database to support the NT file namespace.
Disabling FILESTREAM on the database would prevent FileTables from functioning, as FileTables depend on FILESTREAM being active, not disabled.
FILESTREAM must be enabled on the SQL Server instance (via SQL Server Configuration Manager and instance-level FILESTREAM access level settings) before any FILESTREAM or FileTable features can be used, as FileTables are built on top of the FILESTREAM storage engine.
Partial containment is a database containment model related to user authentication and portability, and has no relationship to the FILESTREAM or FileTable configuration requirements.
FileTables require the database to have at least one non-empty FILESTREAM filegroup, which provides the underlying storage container for the unstructured file data managed by the FileTable.
Enabling contained databases is a server-level setting for database containment (allowing logins within the database) and is not a prerequisite or component of FileTable configuration.
A FILESTREAM directory name must be set at the database level (using ALTER DATABASE ... SET FILESTREAM (DIRECTORY_NAME = '...')) to establish the NT file system namespace path that allows Windows applications to access FileTable data as a file share.
Concept tested: Configuring SQL Server FileTables with FILESTREAM prerequisites
Source: https://learn.microsoft.com/en-us/sql/relational-databases/blob/enable-the-prerequisites-for-filetable?view=sql-server-2017
Topics
Community Discussion
No community discussion yet for this question.