PrepAway - Latest Free Exam Questions & Answers

You need to ensure that CLR assemblies can be used

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply