You have a table named Table1 that stores customer data.
Each customer has a credit limit that can only be discovered by querying multiple tables.
You need to ensure that the value of the credit limit is returned by executing a query on
Table1.
What should you create?
A.
A trigger that uses a ranking function
B.
A trigger that uses a table-valued function
C.
A calculated column that uses a table-valued function
D.
A calculated column that uses a scalar function
Same question as Q101
Explanation states that correct answer is: C
(Not D: A scalar function would only be able to use other columns from the same table.)
D is correct, the answer of Q101 is wrong.
D is write. CreditLimit a calucated column based on function that runs a scalar function. Why table-value it should run?
D
D