Given the Desired Output Requirements, Setup Subscriber Lists and Data Extensions in the Marketing Cloud. MARKETING-CLOUD-ENGAGEMENT-SPECIALIST Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   An administrator is importing a CSV file into a Data Extension. The CSV file has columns: EmailAddress, FirstName, LastName, and CustomerID. The Data Extension has fields: EmailAddress, FirstName, LastName, and CustomerID (Primary Key). During the import, the administrator notices that the CustomerID column in the CSV is not mapping correctly. What is the most likely cause?

   • AThe CSV file has a header row that does not match the Data Extension field names.
   • BThe Data Extension is not marked as Sendable.
   • CThe CSV file contains more rows than the Data Extension can handle.
   • DThe CustomerID field is not set as a Primary Key.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which of the following is an example of a profile attribute in Marketing Cloud?

   • AEmail Address
   • BFirst Name
   • CSubscriber Key
   • DSend ID
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which practice is recommended for maintaining data hygiene in Marketing Cloud?

   • ARegularly import new data without checking for duplicates
   • BPeriodically clean and update subscriber data
   • CStore all data in a single Data Extension
   • DAvoid using suppression lists
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A company uses Salesforce as their CRM and wants to send an email to a segment of their Salesforce Contacts based on a custom field. They want the audience to be automatically updated when the Salesforce data changes. Which Data Extension type should they use?

   • ARandom Data Extension
   • BFilter Data Extension
   • CStandard Data Extension
   • DSalesforce Data Extension
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company has a Data Extension for Orders (OrderID, CustomerID, OrderDate) and a Data Extension for Customers (CustomerID, FirstName, LastName, Email). They want to send an email to customers that includes their order details. What is the most efficient way to relate the Orders Data Extension to the Customers Data Extension?

   • ACreate a Random Data Extension to combine the data.
   • BAdd a CustomerID field to the Orders Data Extension and use a lookup to the Customers Data Extension.
   • CCopy all customer fields into the Orders Data Extension.
   • DUse a Subscriber List for Orders and a Data Extension for Customers.
   Reveal Solution Discussion Select an answer first