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

Questions 11–15

1. 11foundation · easy

   What is a common cause of an import error in Marketing Cloud?

   • AIncluding column headers
   • BUsing a CSV file format
   • CHaving a small file size
   • DMismatched data types between the file and the data extension
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A marketer needs to import a one-time CSV file containing 500 records into a data extension. Which import method should they use?

   • AData Stream
   • BImport Activity
   • CAutomation Studio
   • DAPI Integration
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A marketing administrator receives a CSV file from a data provider. The file uses a comma delimiter and has a header row. However, some fields contain commas within quoted values, such as "Smith, John". When importing this file, what should the administrator do to ensure the data is imported correctly?

   • AImport the file as a tab-delimited file instead.
   • BRemove all commas from the file before importing.
   • CChange the delimiter to a pipe (|) and re-save the file.
   • DUse the default import settings, as Marketing Cloud automatically handles quoted commas.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is the recommended character encoding for CSV files imported into Marketing Cloud?

   • AASCII
   • BISO-8859-1
   • CUTF-8
   • DUTF-16
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   An administrator is importing a CSV file with 100,000 records. The import fails with an error stating that the file exceeds the maximum file size limit. The file is 150 MB. The administrator needs to import the data as soon as possible. What should the administrator do?

   • ACompress the file into a ZIP file and import the ZIP.
   • BUse the API to import the file directly, bypassing the file size limit.
   • CIncrease the file size limit in the Import Activity settings.
   • DSplit the file into smaller CSV files and import them sequentially.
   Reveal Solution Discussion Select an answer first