An e-commerce company wants to track changes in customer addresses but doesn't want to retain the history of previous addresses. What type of SCD should be implemented?
- SCD Type 1
- SCD Type 2
- SCD Type 3
- SCD Type 4
To track changes in customer addresses without retaining the history of previous addresses, you should implement SCD Type 1. This type overwrites existing data with the new address information, ensuring that only the most recent data is retained. SCD Type 2, 3, and 4 involve preserving historical data, which is not necessary in this scenario.
Loading...
Related Quiz
- Which of the following is a benefit of scalability in system design?
- What is the primary purpose of an ERP system?
- Which of the following is typically smaller in scope and focuses on a specific business area or department?
- You are designing a database for a retail company that wants to keep track of daily price changes for products. What type of SCD would be most appropriate to capture this requirement?
- As organizations transitioned from traditional data warehousing solutions to more modern architectures, they faced challenges in processing vast amounts of streaming data. Which technology or approach emerged as a solution for this challenge?