70-465 Question #355: Real Exam Question with Answer & Explanation

Question

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

Options

• AAdd each classification change to a new row in the Customers table.
• BRecord each change to the classification of each customer in a new row in the Customers
• CAdd a new row to the Customers table for each new classification.
• DRecord each change to the classification of each customer in a new table in the Customers

Explanation

The question asks how to track changes to customer classifications over time, requiring a solution that maintains a history of classification changes while keeping the main Customers table clean.

Common mistakes.

• A. Adding each classification change as a new row in the Customers table would create duplicate customer records, leading to data redundancy and integrity issues in the main table.
• B. Recording each change as a new row in the Customers table would bloat the Customers table with multiple rows per customer, making it difficult to identify the current classification and complicating queries against the main entity table.
• C. Adding a new row to the Customers table for each new classification would create duplicate customer entries and does not properly track which customer had which classification change over time.

Concept tested. Slowly changing dimensions and historical data tracking in data modeling

Reference. https://learn.microsoft.com/en-us/power-bi/guidance/star-schema#slowly-changing-dimensions

No community discussion yet for this question.