You have a computed column that is implemented with a userdefined
function. The userdefined
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 userdefined
function.
Which combination should you use?
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