You manage a SQL Server 2008 computer that has a default instance of SQL Server 2008 installed. You want tointegrate the Database Engine on the server with the NTFS file system. You enable FILESTREAM on the server.You need to enable FILESTREAM for Transact-SQL and Win32 streaming access. Which Transact-SQL code should you run?
A.
EXEC sp_configure filestream_access_level, 0
RECONFIGURE
B.
EXEC sp_configure filestream_access_level, 1
RECONFIGURE
C.
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
D.
EXEC sp_configure filestream_access_level, 3
RECONFIGURE
Explanation:
You should run the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
The FILESTREAM feature integrates applications that use SQL Server with the NTFS file system. It stores varbinary(max) binary large object (BLOB) data as files on the file system. To be able to use FILESTREAM, youmust enable it on the SQL Server instance that is running the Database Engine. To enable FILESTREAM, youshould perform the following steps:1. Open SQL Server Configuration Manager.2. Right-click the SQL Server Services node, and select the Open option.3. Right-click the instance of SQL Server on which you want to enable FILESTREAM, and select the Properties option.4. Click the FILESTREAM tab in the SQL Server Properties dialog box of the SQL Server.5. Select the
Enable FILESTREAM for Transact-SQL access check box.6. To read and write FILESTREAM data from Windows, select the Enable FILESTREAM for file I/Ostreaming access
option and type the name of the shared folder in the Windows Share Name field.7. To enable remote clients to access the FILESTREAM data stored in the shared folder, select the Allowremote clients to have streaming access to FILESTREAM data option. 8. Click the Apply button.9. Open SQL Server Management Studio, and click the New Query button.10. Type the following Transact-SQL in the Query Editor and click the Execute button:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
The value 2 for the filestream_access_level configuration option is used to enable FILESTREAM forTransact-SQL and Win32 streaming access. You should not run the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 0
RECONFIGURE
Specifying the value for the filestream_access_level configuration option as 0 disables FILESTREAMsupport for the instance. You should not run the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 1
RECONFIGURE
Specifying the value for the filestream_access_level configuration option as 1 enables FILESTREAM onlyfor Transact-SQL access. You should not run the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 3
RECONFIGURE
The value 3 is not a valid value for the filestream_access_level configuration option.Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure SQL Server services.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > ManagingServers > Setting Server Configuration Options > filestream access level MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Development > Designing andImplementing FILESTREAM Storage > Designing and Implementing FILESTREAM How-to Topics > How to:Enable FILESTREAM