You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will contain a view. The view will contain a computed column that will
be indexed. The computed column will use a user-defined scalar function. The function will
perform complex string manipulations. You need to identify the appropriate function to use.
What should you do?

A.
Use a deterministic common language runtime (CLR) scalar-valued function.

B.
Use a nondeterministic Transact-SQL table-valued function.

C.
Use a deterministic Transact-SQL table-valued function.

D.
Use a nondeterministic common language runtime (CLR) scalar-valued function.