Question 1 of 30
In a marketing campaign, a company wants to analyze the relationship between its customers and their purchases. Each customer can make multiple purchases, and each purchase can belong to a specific product category. If the company uses a relational database to store this information, how should they structure the data to effectively represent these relationships?
Create a Customers table, a Purchases table, and a Product Categories table, linking them through foreign keys.
Store all customer information in a single table, including purchases and product categories.
Use a single table for purchases that includes customer details and product categories as separate columns.
Create a Products table that includes customer information and purchase details in one record.

Preparing for SalesForce Certified Marketing Cloud Consultant Certified Marketing Cloud Consultant? 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