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

Questions 16–20

1. 16application · medium

   A company has a customer data extension with 1 million records. They want to store order history for each customer. Each customer can have up to 100 orders. They are considering two designs: (1) add order fields to the customer data extension, or (2) create a separate order data extension. What is the primary advantage of the separate order data extension in terms of storage and retrieval?

   • AIt allows for more flexible querying by storing all data in a single data extension
   • BIt makes retrieval faster by keeping all data in one table
   • CIt reduces storage by eliminating duplicate customer information in each order record
   • DIt eliminates the need for relationships between data extensions
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A company has a data model with a customer data extension and a survey response data extension. Each customer can respond to multiple surveys, and each survey has multiple questions. They want to analyze survey responses by customer and question. What is the most appropriate data model?

   • ACreate a survey response data extension with fields for customer ID, survey ID, question ID, and response
   • BAdd survey response fields to the customer data extension
   • CCreate a separate data extension for each survey
   • DStore all responses in a single text field in the customer data extension
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   When building a data model in Contact Builder, a consultant discovers that a 'Student' data extension and a 'Course' data extension have a many-to-many relationship. What is the most appropriate next step?

   • AAdd a StudentID field to the Course data extension to link students.
   • BCreate a junction data extension, such as 'Enrollment', to link Students and Courses.
   • CAdd a CourseID field to the Student data extension to link courses.
   • DRemove the relationship because many-to-many relationships are not supported in Contact Builder.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   In the context of data modeling in Marketing Cloud Contact Builder, what does the term 'cardinality' refer to?

   • AThe number of records that can be associated between two data objects in a relationship.
   • BThe speed at which data can be retrieved from a data extension.
   • CThe total number of fields defined in a data extension.
   • DThe process of removing duplicate records from a data extension.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   How does a one-to-many relationship typically influence the design of data extensions in Contact Builder?

   • ABoth data extensions must have identical fields.
   • BThe 'one' side data extension includes a foreign key field that references the primary key of the 'many' side.
   • CThe 'many' side data extension includes a foreign key field that references the primary key of the 'one' side.
   • DA separate junction data extension is required to link the two data extensions.
   Reveal Solution Discussion Select an answer first