Answer-first summary for fast verification
Answer: A table where no changes are allowed.
Type 0 SCD tables are characterized by their static nature, meaning no changes are allowed once the data is recorded. These tables are typically used for static lookup tables where the information does not change over time. Reference: [Slowly Changing Dimension - Wikipedia](https://en.wikipedia.org/wiki/Slowly_changing_dimension)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What accurately defines a Slowly Changing Dimension (SCD) of Type 0?
A
A table that maintains current records, while older records are stored in another table.
B
A table where the new arriving data overwrites the existing one.
C
A table where history will be kept in the additional column.
D
A table where no changes are allowed.
E
A table that stores and manages both current and historical data over time.
No comments yet.