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

Questions 6–10

1. 6expert · hard

   A company is building a data model to support a referral program. Each customer can refer multiple friends, and each referral can result in a reward for the referrer. They want to track the referral relationships and the rewards earned. What is the most appropriate data model?

   • ACreate a separate data extension for each referral
   • BStore referral information in a single text field in the customer data extension
   • CCreate a referral data extension with fields for referrer customer ID, referred customer ID, and reward status
   • DAdd a field to the customer data extension for 'referred by' customer ID
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A marketing team wants to send a campaign to customers who have purchased a specific product. They have a customer data extension and a purchase data extension. The purchase data extension contains one record per purchase, with customer email and product ID. What is the best way to segment the audience for this campaign?

   • AUse a SQL query to join the customer and purchase data extensions on customer email, filtering by product ID
   • BAdd a product ID field to the customer data extension and filter on that field
   • CUse a data filter on the purchase data extension to select records with the product ID
   • DCreate a new data extension with one record per customer and product combination
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   When designing a data model, a many-to-many relationship between 'Products' and 'Orders' is identified. What is the typical design solution in Contact Builder?

   • AAdd a foreign key field to the 'Products' data extension that references 'Orders'.
   • BAdd a foreign key field to the 'Orders' data extension that references 'Products'.
   • CMerge the two data extensions into a single data extension.
   • DCreate a junction data extension that holds the foreign keys from both 'Products' and 'Orders'.
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   A company has a customer data extension with 2 million records and a transaction data extension with 50 million records. They need to run a daily query to calculate the total spend per customer for the last 30 days. The query currently takes over an hour to run and is causing performance issues. What is the most effective way to improve query performance?

   • ACreate a summary data extension that stores daily totals per customer and incrementally update it
   • BRun the query less frequently, such as weekly
   • CUse a data filter to limit the transaction data extension to the last 30 days before running the query
   • DAdd an index on the transaction date field in the transaction data extension
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company has a data model with a customer data extension and an order data extension. They want to send a birthday email to customers who have placed an order in the last 30 days. What is the most efficient way to build this audience?

   • ACreate a SQL query that joins the customer and order data extensions, filters by birthday and order date, and outputs a target data extension
   • BUse a data filter on the order data extension to select orders in the last 30 days
   • CUse a data filter on the customer data extension to select customers with a birthday this month
   • DCreate a separate data extension for customers with birthdays and another for recent orders, then send to both
   Reveal Solution Discussion Select an answer first