Slowly changing dimensions are handled by a(n)________.
A) operational database
B) dimensional database
C) structured storage
D) either A or B
E) distributed database

Question

Quizplus · Accepted Answer

Slowly changing dimensions (SCD) are managed in a dimensional database. An SCD is a design pattern that is used in data warehousing to handle data that changes at a slow rate, such as customer information. A dimensional database is designed to support complex queries and analysis of large volumes of data in a multidimensional model. In contrast, operational databases are designed to handle everyday transactions efficiently. Therefore, the best option is B) dimensional database.

Slowly Changing Dimensions Are Handled by A(n)________