70-465 Question #106: Real Exam Question with Answer & Explanation

Question

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.

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.

Explanation

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.

Common mistakes.

• A. Disabling FILESTREAM on the database would prevent FileTables from functioning, as FileTables depend on FILESTREAM being active, not disabled.
• C. Partial containment is a database containment model related to user authentication and portability, and has no relationship to the FILESTREAM or FileTable configuration requirements.
• E. 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.

Concept tested. Configuring SQL Server FileTables with FILESTREAM prerequisites

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/blob/enable-the-prerequisites-for-filetable?view=sql-server-2017

No community discussion yet for this question.