Free Salesforce Marketing Cloud Engagement Consultant Practice Test Questions

Explanation:

When using Marketing Cloud Connect, Email Studio sends can return tracking information to Sales Cloud, but the send must use the appropriate Salesforce Data Extension configuration.

For Salesforce Sends, Marketing Cloud Connect uses Salesforce Data Extensions to support the transfer of tracking data back to the connected Salesforce org. Salesforce documentation specifically states that tracking data can be pushed from Marketing Cloud Engagement back to Salesforce for emails sent to Salesforce Data Extension audiences.

Therefore, the customer should verify that the sendable Data Extension is stored in the Salesforce Data Extensions folder.

Why the other options are incorrect

B. Report is saved in Standard Salesforce folder — Incorrect
Salesforce reports used for Marketing Cloud Connect sends must be stored in a custom Salesforce folder. Standard Salesforce folders aren't supported for these sends.

C. Required profile attributes are properly mapped — Incorrect
Profile attribute mapping is primarily used for personalization and sharing attributes between Sales Cloud and Marketing Cloud Engagement. It isn't the primary configuration that determines whether Email Studio initiated-send tracking is returned to Sales Cloud.

D. Email Address column is included in the report — Incorrect
Email Address can be part of the send data, but Salesforce requires the appropriate Contact ID or Lead ID fields for report-based sends. The Email Address column itself isn't the configuration that controls tracking synchronization.

Reference
Salesforce documentation confirms that Marketing Cloud Connect can push tracking data from Marketing Cloud Engagement back to Salesforce and that Salesforce Data Extensions are used for this functionality.

Explanation:

Why D is correct: Since the customer is utilizing Marketing Cloud Connect to bridge Sales Cloud and Marketing Cloud, real-time actions like web sign-ups or object creation, such as Leads or Contacts, in the CRM can be captured and processed promptly using Salesforce Triggered Sends. This feature allows a record creation event in Sales Cloud to immediately fire a triggered send definition in Marketing Cloud to deliver the Welcome email in near-real-time.

Why A and B are incorrect: Batch files dropped to an SFTP or regular file imports are asynchronous and run on schedules, such as hourly or daily, via Automation Studio. They introduce a delay and cannot satisfy the requirement for prompt delivery following a live website sign-up.

Why C is incorrect: While a Smart Capture form on a CloudPage can collect submissions, standard practice when integrated with Salesforce CRM and Marketing Cloud Connect relies on CRM record creation, such as Leads or Contacts, feeding Salesforce Triggered Sends or Journey Builder solutions configured through the connected architecture.

Reference
Salesforce Documentation: Create a Salesforce Triggered Send in Marketing Cloud Connect.

Explanation:

Marketing Cloud's Enhanced FTP supports SSH key-based authentication as an alternative to username/password authentication for automated file transfers. By generating and registering an SSH key pair, with the public key stored in Marketing Cloud's Key Management and the private key used by the data warehouse's transfer script, NTO can authenticate file transfers without relying on a password at all. This means:

- No password expiration issue — Since the connection doesn't use a password, the 90-day rotation policy doesn't affect the automated script.
- No security compromise — SSH key authentication is a strong security practice for automated and unattended file transfers.
- No need to update the script every 90 days — The key doesn't expire in the same way that passwords do.

This directly solves NTO's stated constraints: avoiding script maintenance on every password rotation without weakening security.

Why the other options are wrong:

A. Exclude FTP Users From Password Expiration
This isn't a supported Marketing Cloud security setting for this purpose. Even if such an exemption existed, permanently exempting a user from password rotation policy would represent a security compromise, which is contrary to NTO's requirement for a secure solution.

B. SSO via SAML
SAML SSO governs user login authentication to the Marketing Cloud application, typically for human users authenticating through a browser. It doesn't apply to automated, unattended machine-to-machine file transfer authentication and therefore isn't appropriate for a scripted FTP file drop process.

D. Upload via SFTP instead of FTP
Marketing Cloud's Enhanced FTP operates over SFTP for secure and encrypted file transfers. Simply changing the protocol terminology doesn't address the underlying password expiration and script maintenance problem. The password would still be subject to expiration if password-based authentication is used.

Reference:
Salesforce Help — "Enhanced FTP Account" and "SSH Key Management for Automated Studio File Transfers" (Marketing Cloud documentation).

Explanation:

This scenario requires importing Sales Cloud data into Marketing Cloud with three specific requirements: 10 million customers, a maximum 30-minute delay, and only records with the consent checkbox selected, which represents approximately half the database.

Synchronized Data Extensions are the native Marketing Cloud Connect feature designed for this use case. When you configure a synchronized data source in Contact Builder, you select which Sales Cloud objects to sync and can set a sync interval of 15, 30, or 60 minutes. For this requirement, a 15-minute interval satisfies the 30-minute maximum delay.

Critically, Marketing Cloud Connect supports boolean field filters at the synchronization level. You can create a boolean filter on a selected field, and only rows where the field meets the filter requirement will sync to Marketing Cloud. Since the consent checkbox is a boolean field, you can configure the synchronized data source to sync only records where the consent checkbox is true, effectively reducing the synced volume from 10 million to approximately 5 million records.

This approach is confirmed by Salesforce Trailhead documentation, which states that when synchronizing a contact object, you can choose which records to pull and use to segment contacts, including records with a particular field type of true or false.

Why Other Options Are Wrong

A. Import from Salesforce Report in Automation Studio
This is a batch-oriented approach. Automation Studio imports run on a schedule you define, but they are not designed for near-real-time synchronization of millions of records. Additionally, you would need to manage the report, the import process, and ongoing changes manually. The 30-minute delay requirement makes this impractical at scale.

B. Event Data from the Entry Event in Journey Builder
This is an event-driven mechanism for admitting contacts into a journey, not a data synchronization strategy. It works well for transactional triggers, such as a single contact entering a journey when a record changes, but it is not designed to bulk-sync 10 million customer records for ongoing segmentation and Journey Builder use.

D. All Subscribers, since these are synchronized in real time
This is factually incorrect on two counts. First, "All Subscribers" is a system list, not a synchronization mechanism for Sales Cloud data. Second, synchronized data sources do not sync in real time; they operate on a polling interval with a minimum interval of 15 minutes. Additionally, this option does not address the consent filtering requirement.

Key Exam Takeaway

When a question involves ongoing synchronization of large CRM datasets into Marketing Cloud with a specific latency requirement, the answer is Synchronized Data Extensions. Remember these key facts:

- Minimum sync interval: 15 minutes
- Boolean field filters can be applied at the sync level to reduce record volume
- Synchronized Data Extensions are the recommended approach for making Sales Cloud data available in Journey Builder

Explanation:

When a Salesforce sandbox is integrated with Marketing Cloud via Marketing Cloud Connect, refreshing the sandbox requires a specific sequence to avoid connection issues, orphaned configurations, or accidental data injection into the wrong environment.

Official Recommended Order

1. Disconnect the existing Marketing Cloud integration from the sandbox in Marketing Cloud Setup → Apps → Salesforce Integration → Disconnect Account. This cleanly removes the current connection and credentials before the refresh.

2. Refresh the sandbox in Salesforce. The refresh creates a new org ID and copies metadata, including the Marketing Cloud Connect package, from the source.

3. Reconnect the Marketing Cloud account to the newly refreshed sandbox.

4. Authenticate by completing the Connected App authentication setup. This re-establishes secure cross-cloud authentication.

5. Synchronize data sources. Any previously synchronized objects or data are removed on disconnect and must be recreated after reconnection.

Performing the steps in any other order, especially refreshing while still connected, can leave the sandbox pointing at the wrong Marketing Cloud account or cause authentication and synchronization failures.

Why the Other Options Are Incorrect

A and C. Start with Refresh while still connected
These options start by refreshing the sandbox while the Marketing Cloud Connect integration is still active. This is the most common cause of post-refresh connection problems.

D. Synchronize before Authenticate
This places synchronization before authentication, which is out of sequence. Authentication must be completed before data sources can be properly synchronized.

Reference
Salesforce Help: "How Do I Refresh an Integrated Sandbox Org?" under Advanced FAQs for Marketing Cloud Connect, along with related best-practice guidance for sandbox refreshes. The documented sequence is Disconnect → Refresh → Reconnect → Authenticate → Synchronize.