What is a role-playing dimension?

• A. A dimension that rotates between facts.
• B. A separate table for each date role.
• C. A virtual dimension with no physical table.
• D. A single physical dimension reused in multiple analytic roles.

Answer: (D)

A role-playing dimension is one physical dimension that is reused in more than one analytic role within a fact table. This means you have a single date dimension table, but you reference it multiple times in the facts with different roles—such as order date, ship date, and delivery date—so you can drill into the same calendar attributes consistently for each role.

For example, the fact table might join to the same date_dim table three times, using aliases like order_date, ship_date, and delivery_date, each pulling in year, month, day, etc. This avoids duplicating the date data and keeps a single source of truth for calendar attributes.

The other options don’t fit because they imply separate tables for each role or no physical table at all, whereas a role-playing dimension relies on one physical dimension being reused in multiple contexts.