All of the Following Are Ways to Handle Changing Dimensions

question 68

Multiple Choice

All of the following are ways to handle changing dimensions EXCEPT:

• A) overwrite the current value with the new value.
• B) for each dimension attribute that changes, create a current value field and as many old value fields as we wish.
• C) create a new dimension table row each time the dimension object changes.
• D) create a snowflake schema.

---

Definitions:

Low-Cost

A pricing strategy or characteristic indicating that something is relatively inexpensive or cheaper than alternatives.

Economies Of Scale

The cost advantages that enterprises obtain due to their scale of operation, with cost per unit of output generally decreasing with increasing scale.

Attracting New Buyers

The strategies and practices employed by businesses to appeal to and engage individuals or entities that have not previously purchased their products or services.

Repeat Buyers

Consumers who make multiple purchases from the same brand or vendor, demonstrating brand loyalty or satisfaction with the product or service.