Understand How Cardinality Impacts Data Modeling. MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   How does a one-to-many relationship between 'Subscribers' and 'Orders' affect the ability to segment subscribers based on their order history?

   • AIt prevents segmentation based on order data because each subscriber can have multiple orders.
   • BIt allows segmentation based on attributes of any related order, such as total purchase amount.
   • CIt requires that all subscribers have at least one order to be included in any segment.
   • DIt limits segmentation to only the most recent order for each subscriber.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which cardinality type describes a relationship where each record in Data Extension A can be associated with at most one record in Data Extension B, and each record in Data Extension B can be associated with at most one record in Data Extension A?

   • AMany-to-many
   • BOne-to-one
   • CZero-to-many
   • DOne-to-many
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A company has a data model with a customer data extension and an order data extension. They want to send a cart abandonment email to customers who have items in their cart but have not placed an order. They have a cart data extension that stores the cart contents. What is the best way to identify these customers?

   • ACreate a data extension of customers with carts and exclude those with orders
   • BUse a data filter on the cart data extension to select customers with items in their cart
   • CAdd a field to the customer data extension indicating if they have an abandoned cart
   • DUse a SQL query to join the cart data extension with the order data extension and find customers with carts but no orders
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   How does a one-to-many relationship between a 'Subscriber' data extension and an 'Orders' data extension affect data storage in Marketing Cloud?

   • AA separate data extension is created for each order to avoid data conflicts.
   • BEach order record is stored separately, and the subscriber information is not duplicated for each order.
   • CSubscriber information is duplicated in every order record to ensure data integrity.
   • DOrders are stored inside the subscriber record as a nested structure.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company has a data model with a customer data extension and a transaction data extension. They need to run a daily query that calculates the total spend per customer. The transaction data extension has millions of records. What is the most efficient way to improve query performance?

   • ACreate a summary data extension that is updated monthly
   • BUse a data filter to limit the transaction data extension to the last 30 days
   • CAdd an index on the customer key field in the transaction data extension
   • DStore the total spend in the customer data extension and update it after each transaction
   Reveal Solution Discussion Select an answer first