You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance. The SQL Server 2008 R2 instance contains a database named ABC_DB.
You have employed the SQL Server service to configure the FILESTREAM data container in the
ABC_DB database.
Which of the following options are TRUE with regards to FILESTREAM data? (Choose all that
apply.)
A.
FILESTREAM data is not encrypted even though you have enabled transparent data
encryption.
B.
FILESTREAM data is only encrypted when you have transparent data encryption enabled.
C.
FILESTREAM data must be stored in FILESTREAM filegroups contains file system directories
instead of the files themselves.
D.
FILESTREAM data must be stored in a stored procedure.
Explanation: