Administering a SQL Database Infrastructure — Question 165

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.

Answer options

• A. Disable FILESTREAM on the Database.
• B. Enable FILESTREAM on the Server Instance.
• C. Configure the Database for Partial Containment.
• D. Create a non-empty FILESTREAM file group.
• E. Enable Contained Databases on the Server Instance.
• F. Set the FILESTREAM directory name on the Database.

Correct answer: B, D, F

Explanation

The correct answer includes enabling FILESTREAM on the server instance, creating a non-empty FILESTREAM file group, and setting the FILESTREAM directory name for the database. Disabling FILESTREAM is incorrect as it would prevent FILETABLES from functioning. Partial containment configuration and enabling contained databases are not necessary for FILETABLE support.