PrepAway - Latest Free Exam Questions & Answers

Which combination should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
IsDeterministic = True
IsSystemVerified = True
UserDataAccess = False
SystemDataAccess = False

B.
IsDeterministic = True
IsSystemVerified = True
IsPrecise = True
IsTableFunction = True

C.
IsDeterministic = False
IsSystemVerified = True
UserDataAccess = False
SystemDataAccess = False

D.
IsDeterministic = False
IsSystemVerified = True
IsPrecise = True
SystemDataAccess = False


Leave a Reply