How would you accomplish this?

You work as a SQL Server 2012 database developer at ABC.com. You are developing a stored
procedure for ABC.com’s e-Commerce application.
Your stored procedure must display unique values from one column in multiple columns in the
result set.
How would you accomplish this?

A.
You should make use of the OUTER APPLY operator.

B.
You should make use of a dynamic cursor.

C.
You should make use of the PIVOT operator.

D.
You should make use of the CROSS APPLY operator.

E.
You should make use of the UNPIVOT operator.

F.
You should make use of a keyset cursor.

Explanation: