Microsoft
70-433 · Question #98
You have a computed column that is implemented with a user-defined function. The user-defined function returns a formatted account number. The column must be indexed to provide adequate search…
The correct answer is A. IsDeterministic = True. See the full explanation below for the reasoning.
Question
You have a computed column that is implemented with a user-defined function. The user-defined function returns a formatted account number. The column must be indexed to provide adequate search performance. You plan to create an index on the computed column. You need to identify the valid combination of ObjectPropertyEX values for the user-defined function. Which combination should you use?
Options
- AIsDeterministic = True
- BIsDeterministic = True
- CIsDeterministic = False
- DIsDeterministic = False
How the community answered
(32 responses)- A75% (24)
- B13% (4)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.