Role-Playing Dimensions Quiz

What you'll be asked

1. What is a 'role-playing dimension' in a data model?
2. When modeling a 'Flight' fact table that tracks 'Departure Airport' and 'Arrival Airport', what is the most efficient way to handle the Airport dimension?
3. In a star schema, how are role-playing dimensions typically implemented in the BI layer (e.g., Power BI or Tableau)?
4. Which of the following is a potential downside of creating separate physical tables instead of using role-playing dimensions?
5. If you have a 'Sales' fact table and you implement a role-playing 'Date' dimension (e.g., Order Date, Due Date, Ship Date), what must be true to allow users to slice data by both Order Date and Ship Date in a single report?

Answers and explanations come after you submit.