Microsoft
70-451 · Question #89
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a common language runtime (CLR) user-defined scalar function. The function…
The correct answer is A. 1. Ensure that the logic of the function returns the same value for the same input values. 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 common language runtime (CLR) user-defined scalar function. The function will return an integer value. You need to ensure that the computed columns that use the result from this function can be indexed. What should you do?
Options
- A
- Ensure that the logic of the function returns the same value for the same input values
- B
- Ensure that the logic of the function returns a different value for the same input values
- C
- Ensure that the logic of the function returns the same value for the same input values
- D
- Ensure that the logic of the function returns a different value for the same input values
How the community answered
(42 responses)- A71% (30)
- B10% (4)
- C14% (6)
- D5% (2)
Community Discussion
No community discussion yet for this question.