Scenario: Split Monolithic Table

Interviewer prompt: customer_profile table has wide sparse columns and slow writes. Propose SQL schema split strategy with compatibility plan.

customer_profile(customer_id, core fields, optional preference/marketing columns)