Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer
Task 10:

Build a unified customer view across systems

A pipeline loads customer data from a CRM, billing system, and product database, but the same customer has different IDs in each system. How would you design the data model and matching logic so analytics teams can use one reliable customer view?

Write your answer in the field below and click the "Check answer" button.

Answers are checked by AI, so checking needs an account. New accounts get free AI tokens.
The AI feedback on your answer will appear here.

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.