Uplift

multiple choice

Which change needs a Type 2 dimension

SQL & Data Modeling · Schema Design · medium · Original Uplift question · 6 min

You maintain a customer dimension. The business asks: 'we need to see what a customer's loyalty tier WAS at the time of each historical order, even after they change tiers.' Which modeling choice satisfies this?

Evaluation criteria

  • Picks the option the reasoning in the prompt supports

Detailed grading feedback appears after you submit.

Source

Original Uplift question based on a common interview pattern.

Your answer

Options

You get one graded attempt here without an account. Create a free account for unlimited attempts, saved progress and community write-ups.

Answers stay hidden until you ask. Reveal the full model write-up when you are ready to compare.

Community

How other people solved this

There is rarely one right query or one right framing. Read how others approached it, and share your own once you have submitted an answer.

Reading is open to everyone. Sign in to share your approach or mark a write-up as helpful.

Loading write-ups…