Administering a SQL Database Infrastructure — Question 230

You need to address the Sales Director's requirements regarding the customer classification. You need to recommend a solution for changing the classifications.
What should you recommend?

Answer options

• A. Add each classification change to a new row in the Customers table.
• B. Record each change to the classification of each customer in a new row in the Customers table.
• C. Add a new row to the Customers table for each new classification.
• D. Record each change to the classification of each customer in a new table in the Customers database.

Correct answer: D

Explanation

The correct answer is D because creating a new table allows for better organization and tracking of classification changes without cluttering the original Customers table. Options A, B, and C suggest adding rows to the existing table, which could lead to confusion and inefficiency in managing historical classification data.