Given a Customer's Business Requirements, Determine How to Import Data into Marketing Cloud as per Best Practices. MARKETING-CLOUD-ENGAGEMENT-SPECIALIST Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A company has a data extension named 'PurchaseHistory' with fields: PurchaseID (primary key), CustomerID, ProductID, PurchaseDate. They also have a 'Products' data extension with ProductID (primary key) and ProductName. They receive a file of new purchases. To ensure that only valid product IDs are imported, what should the administrator configure?

   • AUse a SQL query to validate ProductID values before import.
   • BDo nothing; the import will automatically validate foreign keys.
   • CSet ProductID in 'PurchaseHistory' as a foreign key to the 'Products' data extension.
   • DSet PurchaseID as a foreign key to the 'Products' data extension.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A marketing analyst receives a CSV file from a vendor that contains subscriber data. The file has no header row, uses semicolons as delimiters, and includes a column with dates formatted as MM/DD/YYYY. The administrator needs to import this file into a data extension that has fields: SubscriberKey (Text), EmailAddress (EmailAddress), DateAdded (Date). What should the administrator do to ensure a successful import?

   • AImport the file using the 'Tab' delimiter because semicolons are not supported in Marketing Cloud imports.
   • BUse the file as-is, but in the Import Activity set the delimiter to semicolon and manually map the columns in the correct order.
   • CAsk the vendor to add a header row and change the delimiter to comma, then import the file with default settings.
   • DOpen the file in a text editor, add a header row, and save it as UTF-8 with comma delimiters, then import normally.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What should you check if an import fails because a required field is missing?

   • AThe file is in the correct folder
   • BThe file contains the required column and values
   • CThe file is not too large
   • DThe data extension has a primary key
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   A company imports a file of 50,000 records into a data extension that has a primary key on SubscriberKey. The file contains 1,000 records with duplicate SubscriberKeys, but the rest of the fields differ (e.g., different FirstName). The company wants to keep the most recent record for each SubscriberKey based on a LastModified field in the file. What should the administrator do?

   • AImport the file using the 'Overwrite' action to replace the entire data extension.
   • BPre-process the file to remove duplicates, keeping the record with the latest LastModified, then import using 'Add and Update'.
   • CUse a SQL query after the import to deduplicate the data extension, keeping the record with the latest LastModified.
   • DUse an Import Activity with the action 'Add and Update' and set SubscriberKey as the matching field.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the purpose of setting user permissions for data imports?

   • ATo control who can import data and access sensitive information
   • BTo speed up the import process
   • CTo automatically clean data
   • DTo increase the file size limit
   Reveal Solution Discussion Select an answer first