Salesforce Marketing-Cloud-Consultant - Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25)

Field-Level Encryption in Marketing Cloud encrypts specific fields at rest but restricts operations such as filtering, querying, or segmentation on those fields. You cannot perform SQL queries or create filtered sends directly using encrypted fields.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Field-Level Encryption Overview

→ "You cannot use encrypted fields in segmentation activities, query activities, or filters in Marketing Cloud. These fields are encrypted at rest and are only decrypted at send time."

—

To prevent duplicate Contact records, the customer needs to update the current All Subscribers list and Contact model by migrating the Subscriber Key to match the Sales Cloud ContactID or LeadID (B).

Uploading a CSV with the new Subscriber Keys mapped appropriately will ensure that existing records are updated (A).

Simply continuing as normal (C) will not prevent duplicates because Email Address is not unique enough across Salesforce objects. Full purge (D) is unnecessary and risks data loss.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Subscriber Key and Contact Key Best Practices

→ "When integrating Sales Cloud, update existing Marketing Cloud subscribers to match the Salesforce ContactID or LeadID as Subscriber Key to prevent duplicate contacts."

Source: Salesforce Implementation Guide – Marketing Cloud Connect Setup

→ "Migrating existing contacts requires careful key management to align records across systems without duplication."

—

The simplest and most efficient method to report on the number of Contacts is to schedule thebuilt-in "Contacts Counts" Standard Report. This report summarizes the total number of Contacts and can be scheduled for automatic email delivery to stakeholders like the CMO.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Contact Count Standard Report

→ "The Contacts Counts report shows the number of Contacts in the account and can be scheduled to email automatically on a recurring basis."

Source: Salesforce Help – Standard Reports Overview

→ "Use Standard Reports like Contact Counts to quickly view and schedule basic statistics without needing custom queries or Automation Studio."

—

✅Comprehensive and Detailed Explanation:

Here’s the breakdown of what’s happening in this automation process:

The file is placed (encrypted) in the SFTP location.

File Transfer activity decrypts the file and moves it to the Safehouse.

Import File activity imports the data into a staging data extension.

Data Extract activity converts the DE to a format usable by All Subscribers (e.g., unsubscribe list extract).

File Transfer activity moves that extract file to a designated folder.

Final Import File activity uses that extract to unsubscribe subscribers from All Subscribers.

This full chain ensures secure file processing and proper unsubscription based on Subscriber Key.

❌Why Other Options Are Incorrect:

A. Lacks the initial File Transfer step to decrypt and move the encrypted file.

B & C. Include unnecessary Query activities that are not relevant for direct unsubscription processing from a clean unsubscribe file.

Exact Extracts from Salesforce Documentation:

File Transfer & Data Extract for Unsubscribe: "Use File Transfer activity to decrypt and move encrypted files into Safehouse. Use Import File and Data Extract to populate unsubscribe lists with Subscriber Keys."

— Source:https://help.salesforce.com/s/articleView?id=sf.mc_as_activities_file_transfer.htm

— Source:https://help.salesforce.com/s/articleView?id=sf.mc_as_data_extract.htm

All Subscriber List Management: "If your account uses Subscriber Key, the unsubscribed file must contain the Subscriber Key and can be processed using Data Extract and Import File activities."

— Source:https://help.salesforce.com/s/articleView?id=sf.mc_subscribers_all_subscribers.htm

Since immediate ingestion is not required and there are potentially thousands of records per minute, the most efficient and scalable method is to aggregate the data in a daily export file and then import it via Automation Studio from the SFTP location.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Best Practices for Large Data Imports

→ "For high-volume data collection scenarios where real-time processing is not required, use daily bulk file imports through SFTP and schedule Automation Studio activities."

Source: Salesforce Help – Automation Studio Import Activities

→ "Use Automation Studio Import Activities to bring in large amounts of data from Enhanced FTP locations on a scheduled basis."

—

A Multi-Step Journey in Journey Builder is best suited to handle dynamic behaviors like:

Sending a series of emails.

Evaluating engagement (opens, clicks).

Removing subscribers from the journey if engagement criteria are met.

Data Extension/Automation entry source allows for automated injection of contacts based on updated records (like non-engagers).

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Journey Builder Multi-Step Journeys

→ "Multi-Step Journeys allow you to send multiple communications, wait for engagement, and adjust the journey path based on subscriber behavior."

—

Knowing if the file is a delta (only new/updated records) or historical (full set) impacts how imports and updates should be configured (A).

Consistency of the file drop time affects whether to use Scheduled or File Drop Automations (D).

Error notification is critical to quickly address any issues with file import (E).

File size over 5,000 rows (C) is not a problem — Marketing Cloud handles millions of records per automation. Data Relationships (B) are more relevant to segmentation after import, not the automation itself.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – File Import Automation Planning

→ "Determine if files are incremental or full to properly set import methods. Confirm expected file timing to design scheduled or triggered automations."

Source: Salesforce Help – Automation Studio Best Practices

→ "Always configure error notifications on Import Activities to ensure prompt action in case of import failures."

—

✅Comprehensive and Detailed Explanation: The correct approach isone Parent Business Unit (corporate) with one Child Business Unit per franchise owner. This setup allows:

Corporate to control global assets, subscriber management, and brand compliance.

Franchise owners to localize messages within their own Business Unit, without accessing or changing corporate-controlled assets.

❌Why Other Options Are Incorrect:

A: “Franchise owners” (plural) need individualized control; a single child BU won't be sufficient.

C: One Business Unit won't provide separation between different franchise operations.

D: Having a separate parent BU for each franchise is excessive, costly, and not scalable.

Exact Extract: Salesforce Help:Business Unit Overview

"Use Business Units to manage assets, permissions, and subscribers separately while maintaining corporate brand control across an enterprise."

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."

—

Distributed Marketing is specifically designed to allow centralized marketing teams to control messaging and branding while empowering field teams (subsidiaries, partners) to personalize andsend communications. It ensures consistency, compliance, and unified branding across campaigns.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Distributed Marketing Overview

→ "Distributed Marketing helps central teams create standardized messaging while allowing local teams to personalize and send communications — ensuring branding consistency."

Source: Salesforce Product Documentation – Distributed Marketing for Salesforce

→ "Unify your brand experience across every customer communication while enabling personalization and local customization."