You need to recommend a solution for the planned changes to the customer classifications. What should you recommend? (Each correct answer presents part of the solution. Choose all that apply.)

The correct answer is A. Add a table to track any changes made to the classification of each customer. E. Add a column to the Classifications table to track the status of each classification.. 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. Not E: Change data capture provides information about DML changes on a table and a database. By

Implement a database

Question

You need to recommend a solution for the planned changes to the customer classifications. What should you recommend? (Each correct answer presents part of the solution. Choose all that apply.)

Options

AAdd a table to track any changes made to the classification of each customer.
BAdd columns for each classification to the Customers table.
CImplement change data capture.
DAdd a row to the Customers table each time a classification changes.
EAdd a column to the Classifications table to track the status of each classification.

How the community answered

(39 responses)

A
74% (29)
B
15% (6)
C
8% (3)
D
3% (1)

Explanation

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. Not E: Change data capture provides information about DML changes on a table and a database. By using change data capture, you eliminate expensive techniques such as user triggers, timestamp columns, and join queries.

Topics

#schema design#data tracking#customer classification#SCD

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice