What should you do?

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.
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.

View Answer

Answer: B, D, F

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/gg509097.aspx