Question 1 of 30
A company is designing a data model for a new customer relationship management (CRM) system. They want to ensure that they can track customer interactions across multiple channels (e.g., email, phone, social media) while maintaining a clear relationship between customers and their respective interactions. The data model must also accommodate future growth, allowing for the addition of new interaction types without significant restructuring. Which approach would best facilitate this requirement while adhering to normalization principles?
Use a single table for all customer interactions, with columns for customer ID, interaction type, and interaction details.
Create separate tables for each interaction type, linking them to a central customer table through foreign keys.
Implement a denormalized structure that combines customer and interaction data into one large table to improve query performance.
Utilize a star schema design that separates customer data from interaction data but requires complex joins for reporting.

Preparing for SalesForce Certified Data Architect Certified Data Architect? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free