You need to choose the appropriate key to use when designing a dimension table based on the Customer table.
What should you do?
A . Use a surrogate key.
B . Use a natural key.
C . Use the Customer Number column as the key.
D . Concatenate the Customer Name and Customer Number columns and use the concatenated string as the key.
E . Use the Customer Name column as the key.