You work as the database administrator for an IT training company named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Training that stores training data for the company. You are instructed to create checklists that lecturers can use to prepare training courses. You must use information from text files stored on Certkiller -DB01’s hard disk drive to create the checklists for the different certifications that Domain.com offers training for. You want to use Visual Studio .NET 2005 to build the checklists by implementing a common language runtime (CLR) function.
What should you do?
A.
Use the CREATE FUNCTION Transact-SQL statement to reference the assembly.
B.
Use the CREATE ASSEMBLY Transact-SQL statement to register the assembly.
C.
Register the assembly in the global assembly cache (GAC).
D.
Sign the assembly with a strong name.
Explanation:
You need to register the assembly by using the CREATE ASSEMBLY statement.
Incorrect Answers:
A: You need to register the assembly before you can reference it.
C: You do not need to register an assembly in the global assembly cache (GAC). The GAC is used to allow multiple applications to share an assembly.
D: You need to sign the assembly with a strong name if it is to be registered in the global assembly cache (GAC). However, you do not need to register an assembly in the global assembly cache (GAC). The GAC is used to allow multiple applications to share an assembly.
Reference:
Microsoft SQL Server 2005 Books Online (2007), Index: CREATE ASSEMBLY statement
Microsoft SQL Server 2005 Books Online (2007), Index: CREATE FUNCTION statement
Microsoft SQL Server 2005 Books Online (2007), Index: assemblies