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:

MC

An abbreviation often used for Marginal Cost, which represents the cost of producing one more unit of a good.

AP

Advanced Placement, a program in the United States and Canada offering college-level curriculum and examinations to high school students.

AVC

Average Variable Cost; the total variable costs divided by the number of units produced, indicating the variable expense per unit of output.

MP

Marginal Product, which refers to the increase in output that results from employing an additional unit of input, holding all other inputs constant.