Salesforce-Marketing-Cloud-Engagement-Consultant Practice Test

Salesforce Spring 25 Release -
Updated On 1-Jan-2026

293 Questions

A customer has a robust Sales Cloud org with several custom objects. Historically, they have created complex reports, referencing many custom objects, to target subscribers and exported them to another email system for deployment. With the implementation of Marketing Cloud Connect, the customer wants to simplify the sending process using Marketing Cloud with as little additional setup as possible. What should a consultant recommend to meet this criteria?

A. Continue to build reports in Sales Cloud and import it to Marketing Cloud for sending.

B. Create a Journey and use Salesforce Data and the Reports object as the Entry Source.

C. Sync all custom objects to Marketing Cloud and recreate the reports for sending.

D. Continue to build reports in Sales Cloud and select the reports in Marketing Cloud

D.   Continue to build reports in Sales Cloud and select the reports in Marketing Cloud

Explanation:

Here’s why.

The customer:
Already has complex Salesforce reports built on many custom objects
Wants to simplify sending using Marketing Cloud
Wants as little additional setup as possible
With Marketing Cloud Connect, you can:
Keep building those same reports in Sales Cloud
In Marketing Cloud, use Salesforce Data as the source for an Email Send or a Journey

Specifically, you can select a Salesforce Report directly as the audience for the send – no need to sync all objects or recreate queries in Marketing Cloud
That means no file exports/imports, and no need to rebuild all that logic in Marketing Cloud. You’re simply reusing the work already done in Sales Cloud.

So option D is exactly that:
Keep building reports in Sales Cloud and just select those reports in Marketing Cloud as the send audience.

Why the others are not as good
A. Continue to build reports in Sales Cloud and import it to Marketing Cloud for sending.
Still requires manual export/import of files.
Does not simplify the process; it just keeps the old workflow.

B. Create a Journey and use Salesforce Data and the Reports object as the Entry Source.
Possible, but overkill if the goal is simply to replace “export → upload → send” with a simpler send.
Journeys require more setup and maintenance than a straightforward send using Salesforce Data.

C. Sync all custom objects to Marketing Cloud and recreate the reports for sending.
This is a big setup effort (syncing many custom objects, rebuilding logic as queries).
Completely opposite of “as little additional setup as possible.”

So the best fit is:
✅ D. Continue to build reports in Sales Cloud and select the reports in Marketing Cloud.

Northern Trail Outfitters wants to suppress their highly engaged email subscribers (multiple opens and clicks for a target campaign) from active display campaigns to reduce overall cost and eliminate unnecessary targeting to the user. What should be recommended?

A. Mobile Studio

B. Advertising Studio

C. Google Analytics 360

D. Einstein Engagement Scoring

B.    Advertising Studio

Explanation:

Advertising Studio allows marketers to create audiences from Marketing Cloud data (such as engagement metrics) and sync them to advertising platforms (Google, Facebook, LinkedIn, etc.).

In this case, NTO can build an audience of highly engaged email subscribers and then suppress them from display campaigns, ensuring they don’t waste budget targeting users who are already engaged.

This directly meets the requirement: reduce cost and eliminate unnecessary targeting.

Why Others are Incorrect
A. Mobile Studio: Used for SMS/MMS and push notifications, not for managing display ad suppression.

C. Google Analytics 360: Provides web analytics and attribution, but does not manage suppression of audiences in display campaigns.

D. Einstein Engagement Scoring: Predicts likelihood of engagement (open, click, unsubscribe), but does not connect to ad platforms for suppression. It’s more about predictive segmentation, not cross-channel suppression.

References
Salesforce Help: Advertising Studio Overview
Trailhead: Marketing Cloud Advertising Studio Basics

Northern Trail Outfitters wants to connect relational data Into their Journey without overloading the entry data. How should they connect the data?

A. Entry Source Data Extension

B. Contact Configuration

C. Data Designer

D. Data Relationships

D.    Data Relationships

Explanation:

This question tests a critical architectural concept in Marketing Cloud Journey Builder: how to efficiently bring in related data (e.g., Order Items related to an Order, Cases related to a Contact) without denormalizing everything into a single, massive entry Data Extension.

Core Problem: "Without overloading the entry data"

The phrase "overloading the entry data" refers to the poor practice of using a single, flat Data Extension as the journey entry source that contains all related data fields from multiple tables, often joined via a large, complex SQL query.

This causes several issues:

Performance: The entry DE becomes huge and slow to query/update.
Data Freshness: The data is static at the point of entry. If a related record (like an Order Status) changes after the contact enters the journey, the journey uses the outdated snapshot.
Management Complexity: Maintaining a monolithic DE with dozens of joined columns is cumbersome and error-prone.

Solution: Dynamic Data Lookups at Decision Points

The optimal pattern is to keep the Journey Entry Source Data Extension lean, containing only the essential keys and attributes needed to identify the contact and trigger the journey (e.g., SubscriberKey, ContactId, JourneyEntryDate).

Then, at specific points within the journey (like before a decision split, or when personalizing an email), you dynamically look up the related data from other Data Extensions. This ensures you are using the most current data.

Why Answer D is Correct:

Data Relationships is the specific Journey Builder feature built for this purpose. It allows you to define a lookup relationship from your entry source Data Extension (the "primary" object) to one or more related Data Extensions (the "related" objects).

How it works: You configure the relationship (e.g., EntrySource.ContactId = Orders.ContactId). Then, within a journey activity (like a Decision Split), you can reference fields from the related Orders DE as if they were part of the entry data, using dot notation (e.g., Orders.TotalAmount).

Key Benefit: The lookup happens in real-time when the contact reaches that activity. There is no need to pre-join all order data into the entry source, thus avoiding "overloading" it. The entry source remains lean, and the data used is fresh.

Why the Other Answers are Incorrect:

A. Entry Source Data Extension: This is the opposite of the requirement. Populating all relational data directly into the entry source DE is the "overloading" practice the question warns against.

B. Contact Configuration: This refers to the core Contact Builder setup that defines the Contact Key and links to the All Subscribers list. It's about the fundamental subscriber identity, not about dynamically relating transactional data within a journey.

C. Data Designer: This is a Contact Builder tool used to create the data model itself (linking Data Extensions to the Contact record via Primary and Foreign Keys). While Data Designer establishes the relationships in the data model, it is the Data Relationships feature within Journey Builder that actively leverages those relationships for real-time lookups during journey execution. Data Designer is the foundation; Data Relationships is the functional application of that foundation in the journey context.

Key Reference Points for Study (Legitimate Sources):
Journey Builder Documentation: Focus on the section for "Data Relationships" (sometimes labeled "Journey Data" or "Lookup Relationships"). Understand how to configure them and reference related fields in decision splits.

Architecture Best Practices: Look for guidance on "Journey Performance" and "Data Architecture for Personalization." These resources will advocate for the lean entry source + real-time lookup pattern.

Trailhead Module: "Add Personalized Decisions in Journey Builder" or modules on advanced Journey Builder configuration.

Critical Distinction: Know the difference between Data Designer (modeling tool in Contact Builder) and Data Relationships (execution feature in Journey Builder). The exam often tests this.

Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).

The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value.
A Customer Reference DE is updated daily and holds subscriber information.
The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items.
The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.
If the web analytics file is empty, NTO does not want the automation to finish running.

Which order of activities should be used to fulfill this requirement?

A. Scheduled Automation > Import File Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

B. File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one > Query Activity for file two > Data Extension Entry

C. File Drop Automation > Verification Activity > Query Activity for file one > Data Extension Entry > Query Activity for file two

D. Scheduled Automation > Import File Activity > Verification Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

B.    File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one > Query Activity for file two > Data Extension Entry

Explanation:

The required sequence must meet three critical requirements:

Immediate Trigger: The journey is triggered by a file drop, but the question implies the entire automation should start when the first file (Web Analytics) arrives. A File Drop Automation is the correct starting source to initiate the process immediately upon the file's arrival in the SFTP.

Halt on Empty File: "If the web analytics file is empty, NTO does not want the automation to finish running." This is the function of the Verification Activity, which stops the automation if the file does not meet specific criteria (e.g., minimum number of rows or column values). This must occur after the file has been imported.

Data Joining/Transformation: The core challenge is that the first and third DEs lack the Subscriber Key or Email Address, which is essential for entry into Journey Builder and for the Decision Split. The data must be joined with the Customer Reference DE (which holds the subscriber information). This joining is accomplished using Query Activities (SQL). Since the data from the Web Analytics file needs to be joined with the Customer Reference DE, a Query Activity is required. The second Query Activity is needed later to prepare the data for the decision split.

Breakdown of Correct Sequence (B):
- File Drop Automation: Starts the automation immediately when the Web Analytics file lands on the SFTP.
- Import File Activity: Imports the raw Web Analytics data into its dedicated Data Extension (DE 1).
- Verification Activity: Checks the newly imported Web Analytics DE (DE 1). If the DE is empty, the automation stops.
- Query Activity for file one (Join 1): Joins DE 1 (Web Analytics) with the Customer Reference DE (DE 2) to get the required Subscriber Key and Email Address. This creates the final, target Journey Entry DE.
- Query Activity for file two (Join 2/Decision Data): Joins the final Journey Entry DE with DE 3 (the data for the Decision Split) to ensure all decision data is available in a single location for Journey Builder.
- Data Extension Entry: The target Data Extension, now containing the Subscriber Key, Email Address, and all necessary data (including the Decision Split data from DE 3), is configured as the entry source for the Abandon Cart Journey.

❌ Analysis of Incorrect Answers
A. Scheduled Automation...: Incorrect. The file drops intermittently, requiring an immediate trigger, which a Scheduled Automation (fixed time interval) does not provide.

C. File Drop Automation > Verification Activity > Query Activity...: Incorrect. The Verification Activity must run after the file has been successfully imported into a Data Extension by the Import File Activity. It cannot verify a raw file on the SFTP.

D. Scheduled Automation...: Incorrect. Same reason as A—Scheduled Automation does not meet the requirement for immediate processing upon file drop.

📚 References
File Drop Automation: Salesforce Help: Automation Studio Starting Sources (Confirms File Drop as the required starting mechanism for immediate SFTP file processing).

Verification Activity: Salesforce Help: Verification Activity (Confirms its use for conditionally stopping an automation based on data extension record counts or specific data values).

Query Activity: Trailhead Module: Build Automations in Marketing Cloud (Confirms Query Activities are used to combine and transform data for use in journeys).

Northern Trail Outfitters recently upgraded their preference center to allow customers to indicate which products they are interested in and to have the ability to opt up and down in send volume. They would like to configure the Delivery Options in a Journey Builder Email Activity to take these new data points into account. Which two options could allow them to meet the requirement? (Choose 2 answers)

A. Suppression List

B. Publication List

C. Auto-Suppression List

D. Domain Exclusion

A.    Suppression List
B.    Publication List

Explanation:

Northern Trail Outfitters wants Journey Builder Delivery Options to respect:
- Product interest preferences
- Opt up / opt down on send volume

Those are subscriber-level preferences, so we want tools that work at that level and are available directly in the Email Activity → Delivery Options.

✅ A. Suppression List
A Suppression List can be used to exclude subscribers who, for example:
- Have opted down from high-frequency emails
- Do not want certain product categories
- Should not receive this particular campaign type

You can:
- Maintain a DE-based suppression list powered by your preference center logic (e.g., via SQL or filters).
- In the Journey Email Activity → Delivery Options, select that list under Suppression Lists so those contacts are automatically excluded.
This ties directly to the new preferences if you populate the list based on their “send volume” or product rules.

✅ B. Publication List
A Publication List is designed to manage subscription preferences by message type or category, which is perfect for:
- “I want emails about Product A, but not Product B”
- “I only want this type of communication occasionally”

In Journey Builder:
On the Email Activity, under Delivery Options, you can assign a Publication List.
Your upgraded preference center can subscribe/unsubscribe people to different Publication Lists based on product interest and volume preference.
This lets the journey respect topic-based and frequency-based opt-ins/opt-outs at send time.

❌ Why the others are not the best fit
C. Auto-Suppression List
Configured at the Send Classification or account level.
Typically used for broad rules (e.g., legal compliance, global opt-outs), not dynamic, per-product or per-volume preferences.
Not directly configured in the Journey Email Activity → Delivery Options for preference-center logic.

D. Domain Exclusion
Used to block or limit sending to specific domains (e.g., internal domains, competitors, test domains).
Has nothing to do with per-contact product interests or volume preferences.

So, the two Delivery Options that can be leveraged to incorporate the new preference center data are:

✅ A. Suppression List
✅ B. Publication List

Salesforce-Marketing-Cloud-Engagement-Consultant Exam Questions - Home Previous
Page 6 out of 59 Pages