Analyze Customer Data to Determine the Appropriate Data Model (I.e. List Model, Data Extensions). MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A retail company wants to send a birthday discount email to customers on their birthday. They have customer data including birth date, email, and purchase history. They want to use Journey Builder to automate this send. What data model should the consultant recommend as the entry source?

   • AA List with birth date field
   • BA Data Extension with customer and purchase history fields
   • CA triggered Data Extension for birthday sends
   • DA filtered Data Extension based on birth date
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which scenario represents a many-to-many relationship in customer data?

   • AA customer can have multiple subscriptions, and each subscription can include multiple customers.
   • BA customer has a single loyalty number.
   • CA customer has multiple orders, and each order belongs to one customer.
   • DA customer has one profile and one email address.
   Reveal Solution Discussion Select an answer first
4. 13application · hard

   An e-commerce company wants to send a post-purchase email that includes the list of items purchased. A customer can have multiple orders, and each order can contain multiple products. They need to model this data to support sending a single email per order with all items listed. What data model should the consultant recommend?

   • AA single Data Extension with order and product fields flattened
   • BA triggered Data Extension for each order
   • CMultiple Data Extensions: Customer, Order, and OrderItem, linked by foreign keys
   • DA List with order and product fields
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   When designing a data model, which practice best supports data privacy and consent management?

   • ANot storing consent data at all to avoid complexity
   • BStoring consent data in a free-text field in the subscriber record
   • CStoring consent status in a separate Data Extension and linking it to subscriber records
   • DStoring consent status as a field in the List Model
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which type of Data Extension is created by applying a filter to an existing Data Extension?

   • AStandard Data Extension
   • BRandom Data Extension
   • CFiltered Data Extension
   • DTriggered Data Extension
   Reveal Solution Discussion Select an answer first