A B2B sales startup is creating a customer dimension table. This will be a part of their star schema model. And it is used to track customer relations. They collect details like Tax Registration number, mobile phone number, email-id, pincode, etc. There are some instances where the email-id and mobile phone numbers change. Whenever the Customer updates the data at source, it should overwrite the value in this table. Which of the following options says about the most suitable method?

Answer options:

A.Use Type 2 SCD.B.Use Type 1 SCD.C.Use Type 3 SCD.D.Use Type 6 SCD.

Correct Answer: B
In this type of table, there will be some columns where data once entered will not change. But here, we have to focus on the columns where data will change later. In the question, we have entities like email-id and phone number that should be changed as per the requirement of the customer. This is clearly pointing to the usage of a Slowly Changing Dimension (SCD). 
Type 1 will reflect the latest changes in the table once it is updated in the source.
Option A is incorrect: Type to SCDs is mainly for versioning.
Option B is correct: This will update the latest values as the source changes.
Option C is incorrect: Its main purpose is to store the data versions in different columns.
Option D is incorrect: This is a combination of Type 1, 2, and 3 and is not a suitable method.
Reference: 
To know more about SCD Types, please refer to the doc below: 

https://docs.microsoft.com/en-us/learn/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/3-choose-between-dimension-types