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 CustomerNumber column as the key.
D. Concatenate the CustomerName and CustomerNumber columns and use the concatenated string as the key.
E. Use the CustomerName column as the key.
