PrepAway - Latest Free Exam Questions & Answers

You need to configure a new database to support FILETABLES

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.

PrepAway - Latest Free Exam Questions & Answers

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.

Explanation:
B: FileTables extend the capabilities of the FILESTREAM feature of SQL Server. Therefore you have to enable
FILESTREAM for file I/O access at the Windows level and on the instance of SQL Server before you can create
and use FileTables.
D: Before you can create FileTables in a database, the database must have a FILESTREAM filegroup.
F: Specifying a Directory for FileTables at the Database Level
When you enable non-transactional access to files at the database level, you can optionally provide a directory
name at the same time by using the DIRECTORY_NAME option. If you do not provide a directory name when
you enable non-transactional access, then you have to provide it later before you can create FileTables in the
database.
https://docs.microsoft.com/en-us/sql/relational-databases/blob/enable-the-prerequisites-forfiletable


Leave a Reply