You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common
language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?
A.
Run the following statement:
EXEC sp_configure ‘show advanced options’, 1
RECONFIGURE
GO
EXEC sp_configure ‘clr enabled’, 1
RECONFIGURE
GO
B.
• Open Microsoft SQL Server Management Studio and connect to the server.
• Right-click the server and select Properties.
• Browse to the Advanced tab.
• Configure the CLRIntegration property to True.
C.
• Open Microsoft SQL Server Management Studio and connect to the server.
• Right-click the server and select Facets.
• Choose the Server Configuration facet.
• Configure the AweEnabled property to True.
D.
• open Microsoft SQL Server Management Studio and connect to the server.
• Right-click the server and select Properties.
• Browse to the Advanced tab.
• Configure the Filestream Access Level option to Full access enabled.