What should you do?

Posted by: Pdfprep Category: 70-467 Tags: , ,

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.

Answer: A

Leave a Reply

Your email address will not be published.