Salesforce CRT-550 - Salesforce Certified Marketing Cloud Consultant Exam (SP25)

A File Drop Automation triggers automatically when a file is placed in a specified SFTP folder, allowing immediate processing. After importing the data, a SQL Query can segment the data based on specific criteria, preparing it for entry into a journey.​

Distributed Marketing is specifically designed to allow centralized marketing teams to control messaging and branding while empowering field teams (subsidiaries, partners) to personalize and send 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."

To centralize analytics data from Marketing Cloud, Sales Cloud, and a third-party warehouse service for efficient analysis and to drive better return on investment (ROI) and growth, Datorama (now part of Salesforce Marketing Cloud Intelligence) is the recommended product.

Datorama Overview: Datorama is a marketing intelligence platform that integrates data from multiple sources, including Marketing Cloud, Sales Cloud, and external systems like third-party data warehouses. It provides advanced analytics, visualization, and reporting capabilities to measure campaign performance, optimize ROI, and drive growth.

Why it fits the use case:

Centralized Analytics: Datorama can ingest and harmonize data from Marketing Cloud (email, SMS, push metrics), Sales Cloud (CRM data), and third-party warehouse services, creating a unified view of marketing performance.

Efficient Analysis: It offers pre-built dashboards, AI-driven insights, and customizable reports to analyze campaign effectiveness across channels.

ROI and Growth: Datorama’s ability to correlate marketing activities with sales outcomes (via Sales Cloud integration) and external data helps NTO identify high-ROI campaigns and opportunities for growth.

Why the other options are incorrect:

A. Web Analytics Connector: This connector integrates Marketing Cloud with web analytics platforms like Google Analytics to track web behavior. It is limited to web data and does not provide comprehensive cross-platform analytics or integration with Sales Cloud and third-party warehouses.

B. Report Studio: Report Studio does not exist as a standalone Salesforce product. Marketing Cloud’s native reporting tools (e.g., Email Studio Reports) are limited and cannot centralize data from Sales Cloud or external systems.

C. Interaction Studio: Interaction Studio (now part of Salesforce Marketing Cloud Personalization) focuses on real-time personalization and customer journey orchestration. While it can use data for personalization, it is not designed for centralized analytics or ROI analysis across multiple platforms.

Exact Extract from Salesforce Documentation:

Datorama Overview: "Marketing Cloud Intelligence (Datorama) connects and unifies data from Marketing Cloud, Sales Cloud, Service Cloud, and external sources to deliver actionable insights. It helps marketers optimize campaigns, improve ROI, and drive growth through advanced analytics and AI."(Source: Salesforce Help - Marketing Cloud Intelligence (Datorama))

Cross-Platform Integration: "Datorama integrates with Salesforce platforms and third-party data sources to provide a holistic view of marketing performance, enabling data-driven decisions."(Source: Salesforce Help - Datorama Integration)

Each File Drop Automation must monitor a unique directory, and that directory cannot be shared across multiple File Drop Automations (B).

The file trigger directory must be inside the import folder structure for Enhanced FTP (C).

Using an external FTP site is not supported for File Drop Automations — it must be Salesforce's Enhanced FTP. The limitation on the number of triggers is not five; it's based on system and licensing limits.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – File Drop Automation Requirements

→ "Each File Drop Automation must have its own unique directory. The directory must reside within the Import directory."

Source: Salesforce Help – Enhanced FTP File Drop Automations

→ "File Drop Automations require files to be dropped into a directory under the Import folder on Marketing Cloud’s Enhanced FTP."

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

—

Comprehensive and Detailed Explanation:

The correct answer is C — Data Extract Activity.

Specifically, a Tracking Extract (a type of Data Extract) can pull all Not Sent events within the past 24 hours.

After extracting, the data can be moved to SFTP via a File Transfer Activity.

❌ Why others are wrong:

A: Report Definition Activity runs standard reports — it doesn't create extract files for automation.

B: SendLog Extract extracts SendLog DEs, not Not Sent tracking events.

D: SQL Query Activity manipulates DE data but doesn't extract system event data directly.

Exact Extract from Salesforce Official Documentation:

Salesforce Help — Data Extract Activity Overview:

"Data Extract Activities allow you to retrieve tracking event data such as Sends, Deliveries, Bounces, Not Sent, Opens, Clicks, etc. Use a Tracking Extract type to pull these events into a file for export."

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

—

Tokenized Sending allows PII (such as email addresses) to stay external until send time; however, once pulled in via personalization strings, PII can still be displayed within emails.

Since Tokenized Sending relies on live API calls to an external database during sends, Salesforce Marketing Cloud's normal service-level guarantees (e.g., send speed and reliability) no longer apply because they now depend on third-party system response times.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Tokenized Sending Overview

→ "Tokenized Sending retrieves sensitive customer data at send time, reducing Marketing Cloud's data storage liability. However, if personalization strings reference retrieved fields, PII can still be displayed in the email."

Source: Salesforce Help – Tokenized Sending Limitations

→ "Marketing Cloud does not guarantee service levels for sends that rely on external Tokenized Sending lookups."

—

Comprehensive and Detailed Explanation:

The correct answer is B — Use an info capture message template to capture the response.

Info Capture templates are designed specifically to collect information via SMS (like survey responses, open text feedback, or registrations).

MobileConnect automatically writes the captured information to a selected Data Extension when using this template type.

❌ Why others are wrong:

A: Text-response messages are simple replies and do not auto-capture or save open-ended feedback to Data Extensions.

C: Outbound templates are designed for sending messages, not capturing replies.

D: Vote/survey templates are for fixed response options (e.g., 1 for Yes, 2 for No) — not open-ended text.

Exact Extract from Salesforce Official Documentation:

Salesforce Help — MobileConnect Info Capture Template:

"Use an Info Capture message template to collect and store SMS responses in a designated data extension."

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

—