Salesforce MCE-Con-201 Exam Questions Instant Access

Question 1

A customer wants to integrate a new dataset with pre-existing contacts. This data will be updated via separate data feeds from the main contact information.

What data model configuration should be recommended?

ACreate additional attribute fields in the main contact data extension.

BCreate a new data extension and link it to the other data extension.

CCreate new Salesforce data and link it to the other data extensions.

DCreate a new data extension and link it as a new population.

Answer : B

Comprehensive and Detailed Explanation

The correct answer is B --- Create a new data extension and link it to the other data extension.

Best practice is to separate different data streams into different Data Extensions and use relationships (via Contact Builder Attribute Groups) to link them logically.

This allows independent updates from different sources without risking overwriting primary contact data.

Why others are wrong:

A: Adding more fields to the main DE would make the model heavy and harder to manage, especially with separate feeds.

C: Salesforce Data Extensions are specific to CRM integration and not mentioned here.

D: New populations are used when contacts are fully separate audiences, which is not the case here (it's the same contact base).

Exact Extract from Salesforce Official Documentation:

Salesforce Help --- Contact Builder Data Relationships:

'Use separate data extensions for distinct types of information and create relationships between them to build a scalable contact data model.'

(Source: https://help.salesforce.com/s/articleView?id=sf.mc_cb_data_model.htm)

---

Question 2

Northern Trail Outfitters wants to query Marketing Cloud for send data across SMS, Push, and Email.

What would a consultant recommend?

ASend Logs

BTracking Extracts

CContact History

D_Send Data Views

Answer : D

_Send Data Views are built-in system tables in Marketing Cloud that capture detailed tracking data across multiple channels including Email, SMS, and Push. They can be queried via SQL Query Activities to extract insights about sends, clicks, opens, bounces, and more.

---

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help -- Data Views in Marketing Cloud

'_Send Data Views provide detailed tracking data for sends across all messaging channels, including Email, Mobile, and Push. Query these views for advanced reporting.'

---

Question 3

Northern Trail Outfitters wants to import their Sales Cloud data into Marketing Cloud to leverage it within Journey Builder. They have approximately 10 million customers and the data needs to be available with a delay of no more than 30 minutes. Only customers where the consent checkbox is selected in Sales Cloud should be imported, which represents approximately half of their customer database.

What should they implement?

AAll Subscribers, since these are synchronized in real time

BImport from Salesforce Report in Automation Studio

CEvent Data from the Entry Event in Journey Builder

DSynchronized Data Extensions with a filter

Answer : D

Synchronized Data Extensions via Marketing Cloud Connect allow syncing Salesforce objects (such as Leads, Contacts) into Marketing Cloud at near real-time speeds (approximately every 15--30 minutes). To filter only customers with consent selected, they can configure a Filtered Data Extension based on the synchronized object.

---

Exact Extract from Salesforce Documentation:

Source: Salesforce Help -- Synchronized Data Sources Overview

'Synchronized Data Sources allow you to automatically sync Salesforce object data into Marketing Cloud. The sync interval can be configured up to every 15 minutes.'

Source: Marketing Cloud Connect Implementation Guide

'To target a subset of synchronized records, configure Filtered Data Extensions based on specific criteria, such as opt-in status or custom fields.'

---

Question 4

Northern Trail Outfitters has started the process of integrating its Marketing Cloud account and Sales Cloud org through Marketing Cloud Connect.

Which configuration should be utilized for the API user created in Marketing Cloud?

AAPI User checkbox is selected; no roles are assigned to user.

BAPI User checkbox is selected; Administrator & Marketing Cloud Administrator roles are applied.

CAPI User checkbox is deselected; Marketing Cloud Viewer role is applied.

DAPI User checkbox is deselected; all available roles are assigned to user.

Answer : B

For integrating Marketing Cloud with Sales Cloud via Marketing Cloud Connect, the API user in Marketing Cloud should have the 'API User' checkbox selected. Additionally, assigning both the 'Administrator' and 'Marketing Cloud Administrator' roles ensures the user has the necessary permissions to facilitate the integration effectively.

Salesforce Help: Create a Marketing Cloud API UserSalesforce

Question 5

Northern Trail Outfitters (NTO) has been storing web behavior in a data extension for several years. They have indicated that with several hundred million rows, there has been an impact on performance. NTO indicates they only need to store data from the previous twelve months, which will not exceed eighty million rows.

Which two methods would allow them to utilize a Retention Policy?

Choose 2 answers

AClear data from the current data extension completely, then reconfigure a Retention Period via Email Studio.

BDelete data from the data extension prior to twelve months ago, then configure a Retention Period via Contact Builder.

CReconfigure the current data extension as-is with a Retention Period via Contact Builder.

DReplace the current data extension with a new data extension configured with a Retention Period.

Answer : B, D

Comprehensive

In Salesforce Marketing Cloud, applying a Retention Policy to a data extension helps manage data storage by automatically deleting records after a specified period.

Option B: By deleting data older than twelve months, NTO ensures that only relevant data remains. Subsequently, configuring a Retention Policy via Contact Builder will automate the deletion of records beyond the desired retention period moving forward.

Option D: Creating a new data extension with a predefined Retention Policy is a proactive approach. This ensures that only data within the desired retention period is stored, and it avoids potential issues with applying retention policies to existing data extensions that have exceeded certain thresholds.

Salesforce Help: Manage Data Retention Policy

Question 6

A customer wants to send an email confirming opt-in when someone signs up for their emails via a form on their website. The email should arrive within a few minutes of completing the form, and all of the form data needs to be stored in Marketing Cloud to personalize the outgoing email. The customer has access to a developer for working with APIs, but they want to be able to change the email creative without involving the developer.

What should a consultant recommend?

AUse the WSProxy via SSJS to deploy the email after capturing form data.

BUse a SQL Query activity in Automation Studio to run hourly and deploy emails.

CUse a Send Email activity in Automation Studio to run hourly and deploy emails.

DUse a Triggered Send Data Extension to capture form data and deploy the email.

Answer : D

The best solution is to use a Triggered Send linked to a Triggered Send Data Extension. The developer can configure the API to insert data into the TSDE, and Marketing Cloud automatically sends the appropriate email without further developer involvement. Creative changes can be managed easily through Content Builder by marketers.

---

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help -- Triggered Sends

'Triggered Sends enable near real-time email sending when an action occurs, using Triggered Send Data Extensions to personalize emails dynamically.'

Source: Salesforce Developer Documentation -- TriggeredSendDefinition

'Triggered Sends can be managed independently of API calls, allowing marketing teams to control email creative updates.'

---

Question 7

Northern Trail Outfitters is looking to personalize their SMS messages.

Which data source is supported to personalize messages?

APopulation in Contact Builder

BMobileConnect Demographics

CData Designer Attribute Group

DProfile Attributes

Answer : D

Comprehensive

Profile Attributes in MobileConnect are used to store subscriber-specific information, such as first name, last name, or preferences. These attributes can be utilized to personalize SMS messages, enhancing engagement and relevance.

Salesforce Help: MobileConnect Demographics and Profile Attributes

Salesforce Certified Marketing Cloud Engagement Consultant MCE-Con-201 Exam Questions