Marketing needs local campaign attributes joined to a certified sales model this week. Would you extend the shared model or build a composite model?

Instruction: Senior-level, open-ended case. Several approaches can be defensible; explain your assumptions, recommendation, tradeoffs and what evidence would change your choice. Choose a real departmental extension you understand. Explain its grain, useful lifetime, permission boundaries and who owns it; describe this as a proposed design unless you have personally delivered it. For a mock interview, allow two minutes for your first answer, then 30 seconds to respond to the pressure-test twist. State what changed, your next action and what you cannot safely promise.

Context: This open-ended senior case assesses decision quality. Makes centralization and local extension both viable, with concrete selection criteria and checks for relationship semantics, security boundaries, performance and future reuse.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

My decision would depend on whether these attributes are an experiment or a shared business definition. I’d establish their grain first: one current campaign label per customer is different from several campaign memberships with effective dates. We also need stable customer keys, ownership, and agreement on how a campaign filter should change the sales measures. Adding governed attributes to the shared source and model is attractive when several teams will reuse them...

Upgrade to view official answer

Related Questions