Your question is Design a CRM Data Integrity Pipeline. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are working on a data pipeline for an investment CRM used by financial analysts to track clients, households, opportunities, and activity history. The main concern is data integrity across source systems, where duplicate records, missing required fields, and inconsistent account mappings can distort reporting and follow-up workflows.
Describe your experience with investment CRM systems. How do you ensure data integrity?