A retail company needs to import a one-time list of 500,000 email addresses from a CSV file into Marketing Cloud for a single promotional send. The file is stored on an FTP site. The marketing team wants to run this import manually, without setting up automation. What should the administrator recommend?

Use the Data Loader to import the file into a data extension.

Use the API to import the file into a list.

Use the Import Activity in Email Studio to import the file into a data extension.

Use Automation Studio with a SQL query to import the file into a list.

A company needs to import a file that contains transactional data (e.g., order details) that is linked to customer data in another data extension. The file is large (1 GB) and is delivered via API. The import must be automated and run every 15 minutes. What is the best approach?

Use Automation Studio with an Import Activity that pulls from an FTP site.

Use a SQL query in Automation Studio to pull data from the API.

Use the API to insert the transactional data into a data extension, and use Automation Studio to run a SQL query to join with customer data.

Use Data Loader to import the data every 15 minutes.

A client needs to import a large data file (over 10 million records) into a data extension on a nightly basis. Which import method should be recommended?

Automation Studio with Import Activity

SalesforceCertified Marketing Cloud Engagement Consultant

Domain 6Objective 4

Given a Customer Scenario, Recommend Appropriate Import Method with Lists or Data Extensions. MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 4)

Part of the DATA DESIGN domain, which accounts for 10% of the MARKETING-CLOUD-ENGAGEMENT-CONSULTANT exam. Salesforce does not publish an official question count, but from its 105-minute exam (~40–70 total, ~4–7 in this domain), expect 1–1 from this objective — we provide 19 practice questions to prepare you well beyond it. (estimate)

19questions here

4free pages

5concepts

10%of the exam

Questions 16–19

16application · medium
A retail company needs to import a one-time list of 500,000 email addresses from a CSV file into Marketing Cloud for a single promotional send. The file is stored on an FTP site. The marketing team wants to run this import manually, without setting up automation. What should the administrator recommend?
Select an answer first
17foundation · easy
A Marketing Cloud administrator needs to import a one-time CSV file containing 500 subscriber records into a data extension. Which import method is most appropriate for this scenario?
Select an answer first
18expert · hard
A company needs to import a file that contains transactional data (e.g., order details) that is linked to customer data in another data extension. The file is large (1 GB) and is delivered via API. The import must be automated and run every 15 minutes. What is the best approach?
Select an answer first
19foundation · easy
A client needs to import a large data file (over 10 million records) into a data extension on a nightly basis. Which import method should be recommended?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to MARKETING-CLOUD-ENGAGEMENT-CONSULTANT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “MARKETING-CLOUD-ENGAGEMENT-CONSULTANT” is a trademark of its owner, used for identification only.

Given a Customer Scenario, Recommend Appropriate Import Method with Lists or Data Extensions. MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 4)

Questions 16–19

A Marketing Cloud administrator needs to import a one-time CSV file containing 500 subscriber records into a data extension. Which import method is most appropriate for this scenario?

A company needs to import a file that contains transactional data (e.g., order details) that is linked to customer data in another data extension. The file is large (1 GB) and is delivered via API. The import must be automated and run every 15 minutes. What is the best approach?

A client needs to import a large data file (over 10 million records) into a data extension on a nightly basis. Which import method should be recommended?

Keep studying — DATA DESIGN