A company is importing a file into a data extension. The file contains a field 'Status' that can be 'Active' or 'Inactive'. They want to ensure that only 'Active' records are imported. What is the best practice?

Use the API to import only 'Active' records.

Import all records and then use a SQL query to delete 'Inactive' records.

Filter the file before importing to include only 'Active' records.

Use a SQL query in the Import Activity to filter the data.

A company has a complex data model with multiple related data extensions (e.g., Customers, Orders, Products). They need to send personalized emails based on customer purchase history. They also need to track unsubscribes and manage preferences. What is the best approach?

Use a list with custom fields for purchase history.

Use multiple related data extensions and a SQL query to join them for segmentation.

Use a single data extension with all customer and order data.

Use a data extension for customers and a list for orders.

A company needs to import a file that is generated by an external system and placed on an FTP site every hour. The file contains transactional data that must be imported into a data extension for real-time personalization. What is the best approach?

Use the API to import the file every hour.

Use a SQL query to import the file from FTP.

Use Automation Studio with an Import Activity scheduled to run every hour.

Use Data Loader to import the file hourly.

A company is importing a file that contains a date field in the format 'MM/DD/YYYY'. The data extension field is defined as a date type. What should the administrator do to ensure the dates are imported correctly?

Import the file as is; Marketing Cloud will auto-detect the format.

Format the dates in the file to 'YYYY-MM-DD' before importing.

Change the data extension field to text type.

Use the API to import the file with a date format parameter.

A marketing team needs to send a targeted email to customers who purchased a specific product in the last 30 days. The purchase data is stored in a data extension. What is the best way to create the audience for the send?

Create a suppression list to exclude non-purchasers.

Use the data extension directly in the send without filtering.

Use a SQL query to filter the data extension and create a new data extension for the audience.

Create a list and import the customer emails from the data extension.

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

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 6–10

6expert · hard
A company is importing a file into a data extension. The file contains a field 'Status' that can be 'Active' or 'Inactive'. They want to ensure that only 'Active' records are imported. What is the best practice?
Select an answer first
7expert · hard
A company has a complex data model with multiple related data extensions (e.g., Customers, Orders, Products). They need to send personalized emails based on customer purchase history. They also need to track unsubscribes and manage preferences. What is the best approach?
Select an answer first
8application · medium
A company needs to import a file that is generated by an external system and placed on an FTP site every hour. The file contains transactional data that must be imported into a data extension for real-time personalization. What is the best approach?
Select an answer first
9application · medium
A company is importing a file that contains a date field in the format 'MM/DD/YYYY'. The data extension field is defined as a date type. What should the administrator do to ensure the dates are imported correctly?
Select an answer first
10application · medium
A marketing team needs to send a targeted email to customers who purchased a specific product in the last 30 days. The purchase data is stored in a data extension. What is the best way to create the audience for the send?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.