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 1)

Questions 1–5

1. 1expert · hard

   A company has a data extension 'Orders' with fields: OrderID (primary key), CustomerID, OrderDate. They also have a 'Customers' data extension with CustomerID (primary key) and CustomerName. The company receives a file of new orders that includes some CustomerIDs that do not exist in the 'Customers' data extension. The business wants to import all orders, but also wants to maintain referential integrity. What should the administrator do?

   • AUse a SQL query to join the orders file with the 'Customers' data extension and only import valid orders.
   • BSet CustomerID as a foreign key to the 'Customers' data extension and import the file; any invalid CustomerIDs will be rejected.
   • CImport the orders file into the 'Orders' data extension without setting a foreign key relationship.
   • DFirst import the missing CustomerIDs into the 'Customers' data extension, then import the orders file with a foreign key relationship.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   An administrator attempts to import a CSV file into a data extension. The import fails with an error message stating that a field contains an invalid data type. The file has a column named 'BirthDate' that contains values like '1990-01-01' and also some values like 'N/A'. The data extension field 'BirthDate' is defined as a Date field. What is the most likely cause of the error?

   • AThe 'N/A' values cannot be converted to a Date data type.
   • BThe file is not saved in UTF-8 encoding.
   • CThe file size exceeds the maximum allowed for imports.
   • DThe column header 'BirthDate' does not match the field name exactly.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which field is typically used as the unique identifier to prevent duplicate records during import?

   • AEmail Address
   • BLast Name
   • CFirst Name
   • DSubscriber Key
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which tool in Marketing Cloud is used to schedule and automate data imports?

   • AContent Builder
   • BAudience Builder
   • CJourney Builder
   • DAutomation Studio
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A business requires that subscriber data be imported from an external system every night at 2 AM. Which import method should be used?

   • AManual Import Activity
   • BAPI Integration
   • CData Stream
   • DAutomation Studio with an Import Activity
   Reveal Solution Discussion Select an answer first