Exactprep Marketing-Cloud-Consultant Questions

Comprehensive and Detailed Explanation:

The correct answer is C — Query Activity > Data Extension Entry Source > Journey Activities.

A Query Activity can select subscribers who haven't purchased in six months based on date logic.

The results are saved into a Data Extension.

This Data Extension is then used as the entry source into a Journey, which can orchestrate sending across multiple channels (email, SMS, push).

❌ Why others are wrong:

A: API Event is not necessary; you already have the data internally.

B: Import Activity is for external file imports; no external file mentioned.

D: Salesforce Entry Event relates to CRM records, not Data Extension queries.

Exact Extract from Salesforce Official Documentation:

Salesforce Help — Data Extension Entry Source:

"Use the Data Extension Entry Source to inject contacts into a journey based on criteria from a query or automation. This supports orchestrating communications across multiple channels."

(Source: )

—

When disconnecting an existing Salesforce org in a Multi-Org Marketing Cloud setup, you must manually remove all user mappings, attribute mappings, and tracking subscriptions tied to the original instance before connecting a new org. This ensures a clean reconnection without conflicts.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – Multi-Org Setup for Marketing Cloud Connect

→ "Before disconnecting an org in a Multi-Org setup, manually remove user mappings, attribute mappings, and tracking subscriptions to prevent data conflicts."

—

Einstein Engagement Frequency analyzes subscriber engagement and determines optimal send frequencies. By querying the Einstein Engagement Frequency data extension, you can identify subscribers who have received emails within the past 14 days and exclude them from the current send, ensuring compliance with the desired frequency cap. ​ CloudKettle

BuildRowSetFromJSON() is an AMPscript function specifically designed to parse JSON payloads into usable row sets inside emails. This allows marketers to iterate through JSON objects easily and display order details dynamically in triggered transactional emails.

—

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help – AMPscript BuildRowSetFromJSON() Function

→ "BuildRowSetFromJSON parses a JSON string and creates a rowset suitable for use in AMPscript loops."

Source: Salesforce Help – Formatting JSON in Emails

→ "Use BuildRowSetFromJSON to extract and format dynamic data from JSON payloads in triggered transactional sends."

—