You use Microsoft SQL Server to develop a database application.

You need to implement a computed column that references a lookup table.

What should you do?

A. Reference a user-defined function within the

computed column.

B. Create a BEFORE trigger that maintains the state of the computed column.

C. Add a default value to the computed column that implements hard-coded values.

D. Add a default value to the computed column that implements hard-coded CASE stat

ements.

Explanation:

You use

Microsoft SQL Server to develop a database application.

You need to create an object that meets the following requirements:

Takes an input parameter

Returns a table of values

Can be referenced within a view

Which object should you use?

A. inline table-

valued function

B. user-defined data type

C. stored procedure

D. scalar-valued function

Explanation: