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?
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.
Just for clarifying the question:
Classification Changes
You plan to change the way customers are classified. The new classifications will have four levels based
on the number of orders.
Classifications may be removed or added in the future.
Management requests that historical data be maintained for the previous classifications.
Security A group of junior database
administrators must be able to manage security for the Sales database.
The junior database administrators will not have any other administrative rights.
ADatum Corporation wants to track which users run each stored
procedure.