Microsoft
70-451 · Question #116
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…
The correct answer is D. Use a deterministic common language runtime (CLR) scalar-valued function. See the full explanation below for the reasoning.
Question
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?
Options
- AUse a nondeterministic Transact-SQL table-valued function.
- BUse a deterministic Transact-SQL table-valued function.
- CUse a nondeterministic common language runtime (CLR) scalar-valued function.
- DUse a deterministic common language runtime (CLR) scalar-valued function.
How the community answered
(21 responses)- A5% (1)
- B14% (3)
- C5% (1)
- D76% (16)
Community Discussion
No community discussion yet for this question.