PrepAway - Latest Free Exam Questions & Answers

Which service is used when you configure the FILESTREAM data container in the ABC_DB database?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains a database named ABC_DB.
Which service is used when you configure the FILESTREAM data container in the ABC_DB
database?

PrepAway - Latest Free Exam Questions & Answers

A.
The IIS Service.

B.
SQL Server Agent service

C.
SQL Server Integration Services

D.
Microsoft Search service

E.
The SQL Server service.

F.
The SQL Server VSS Writer.

G.
The Web Service.

H.
MSDTC service

Explanation:

Only the account under which the SQL Server service account runs is granted NTFS permissions
to the FILESTREAM container.


Leave a Reply