The Lookup() function ' s fourth parameter must be the value to match against the lookup column — here, SubscriberKey in the Fav_Animals data extension — and that value must be sourced from the current recipient ' s own SubscriberKey at send time. In this scenario, because the audience is being pulled from a Salesforce Report rather than a native Marketing Cloud list, the relevant personalization string that resolves correctly is the plain, unscored SubscriberKey personalization string (matching the field/column naming used generally in Report-based and Salesforce Data Extension sends), which is what option C supplies as the literal fourth argument. Option A ' s ContactID is a Salesforce record identifier, not the Marketing Cloud Subscriber Key value the Fav_Animals data extension is keyed on, so it would fail to match. Option B ' s _emailaddr personalization string returns the recipient ' s email address, an entirely different value than SubscriberKey, and would not correctly match the lookup column. Option D ' s underscore-prefixed _subscriberkey is the legacy/system personalization string typically associated with native list-based sends rather than Salesforce Report-audience sends, making the unscored SubscriberKey reference the more contextually correct choice for this Report-driven scenario. Reference: AMPscript Lookup() Function, Personalization Strings for Salesforce Report Audiences.

An Auto-suppression list is specifically designed to be dynamically and automatically refreshed by a scheduled SQL Query Activity, and then applied to future sends without requiring the marketer to manually re-attach a suppression list each time — precisely matching the requirement that the excluded contacts are ' dynamically identified with the help of the SQL query on a daily basis ' and should be excluded from all future sends ' automatically. ' Because it can be tied to specific sender profiles, it further satisfies the requirement to scope the exclusion only to the relevant sends using those particular sender profiles. A standard Suppression list (B), by contrast, is a static, manually-attached list that must be explicitly selected on each individual send — it does not automatically refresh from a daily query or automatically apply itself to all qualifying future sends without ongoing manual intervention, making it unsuited to the ' automate ' requirement described. A Publication list (C) governs subscriber opt-in/communication-type preferences rather than dynamic, query-driven exclusion logic tied to sender profiles. ' Exclusion data extension ' (D) is not a distinct, named Marketing Cloud feature — it describes a generic data extension, not the automated suppression mechanism the platform actually provides for this use case. Reference: Auto-Suppression Lists, Sender Profiles.

Journey Builder provides two native building blocks that together satisfy this requirement without any custom development: an Engagement Split evaluates each recipient ' s response — click behavior on a satisfaction survey, for example — to branch negative responses down a distinct journey path, and the native Case Activity (available through Marketing Cloud Connect) can then directly create a new Case record in Service Cloud for that negative-response branch, all within a single orchestrated journey and using entirely out-of-the-box functionality, matching the explicit ' use as much native functionality as possible ' guidance. This is the cleanest, lowest-effort path precisely because both the routing logic and the Salesforce write-back are native journey activities requiring no custom code. Option A ' s AppExchange/custom API integration approach is unnecessarily heavy engineering when native functionality already accomplishes the goal. Option C substitutes a Custom Activity, which by definition requires custom development and external hosting, for the native Case Activity, working against the stated preference for native functionality. Option D proposes handling response capture in Automation Studio, which lacks the native engagement-based branching logic that Journey Builder ' s Engagement Split provides for evaluating individual response sentiment in real time. Reference: Journey Builder Engagement Split, Case Activity (Marketing Cloud Connect).

The most reliable, documented pattern for cross-journey handoff based on engagement is to capture the engagement outcome as a persisted, queryable data point rather than attempting to read it indirectly from system-level journey data views, which do not reliably expose per-contact Engagement Split path results in a directly queryable format. In this pattern, Journey A includes an Engagement Split after the email send, and the branch a contact falls into (engaged vs. not) is written out via an Update Contact Activity into a Boolean field on a dedicated Engagement data extension — creating a durable, explicit record of that contact ' s engagement outcome. A separate Automation Studio process then queries this Engagement data extension directly to build the entry-source population for journey B, giving a clean, reliable, and fully controllable handoff mechanism between the two journeys. Options A, B, and D all attempt to derive the engagement outcome by querying system Journey/Journey Activity data views for Engagement Split results, which is not a standard, reliably queryable data structure for this purpose — Engagement Split path outcomes are not natively exposed as a clean Boolean field in those system data views the way this scenario ' s options imply. Reference: Journey Builder Engagement Split, Update Contact Activity, Cross-Journey Data Handoff Patterns.

A single, unified Journey Builder journey spanning Push, Social, and Email activities within one orchestrated path is the correct architecture, because it lets the consultant use native Engagement Splits and Exit Criteria/Goals evaluated at the individual-contact level across the whole customer experience: when a contact opens or clicks any message in the sequence, the journey ' s engagement logic removes them from continuing through subsequent steps, exactly as required. Building this as one journey also ensures message sequencing and channel coordination remain synchronized for each contact, rather than fragmented across disconnected processes. Option C, running multiple separate journeys per channel, breaks the requirement that engagement in one channel should suppress messaging across all remaining channels, since disconnected journeys cannot natively communicate contact-level engagement state to one another in real time. Option B, a generic Script Activity inside Automation Studio, is a heavy, code-dependent, batch-oriented approach poorly suited to real-time, per-contact engagement evaluation and channel orchestration. Option D similarly relies on periodic batch imports and suppression list rebuilding, introducing latency and missing the real-time ' remove on open/click ' behavior a journey ' s native engagement logic provides instantly. Reference: Journey Builder Multi-Channel Journeys, Engagement Split, Exit Criteria.

Identifying subscribers who did not receive their intended email over a rolling 24-hour window requires filtering logic against send-outcome data (such as the Sent, Bounce, or related data views) based on a specific date range and a negative-outcome condition — precisely the kind of conditional, criteria-based filtering that a SQL Query Activity is built to perform. This activity is the essential step that actually identifies and isolates the correct population of non-received subscribers before anything can be exported; without it, there is no mechanism within the automation to determine which specific subscribers meet the ' did not receive ' criteria. While a Data Extract Activity (C) would ultimately be needed to produce the exportable file and place it on the SFTP, the scenario is asking specifically which activity is required to correctly identify the target population in the first place — and that identification step is the SQL Query Activity, making it the most essential, non-optional component of this automation given the filtering complexity described. A Report Definition Activity (A) is not the standard mechanism for this kind of granular, criteria-based subscriber-level filtering. A ' SendLog Extract ' (B) is not a distinctly named standard Automation Studio activity separate from the general Data Extract Activity. Reference: Automation Studio SQL Query Activity, Data-Driven Segmentation for Exports.

Reply Mail Management supports a set of documented personalization strings specifically designed for use within its auto-forward email template configuration, including a string that renders the actual captured body content of the inbound reply directly inline within the forwarded message sent to an internal team such as Customer Success — this is the native, purpose-built mechanism for exactly this requirement, requiring only template configuration rather than custom development or data querying. RMM ' dynamic content blocks ' (B) is not a real, documented RMM feature; dynamic content blocks are a general Content Builder personalization concept unrelated to RMM ' s specific reply-forwarding template mechanism. There is no ' Include Replies as Attachments ' checkbox (C) in RMM settings — attaching the reply as a separate file is not how RMM ' s native forwarding feature renders reply content; it uses inline personalization strings instead. Option D, querying an ' RMM data view ' and referencing it from a separate data extension, describes an unnecessarily indirect, custom-built workaround for a need RMM ' s own native forwarding template configuration already directly solves through its documented personalization strings. Reference: Reply Mail Management, RMM Personalization Strings.

The Transactional Messaging API is the correct recommendation because it uniquely satisfies both explicit requirements simultaneously: the message is dispatched as fast as possible through a direct, synchronous API call initiated the moment the password-reset request occurs on the web server, and critically, the API call itself returns a real-time send-status response back to the calling web server, satisfying the requirement that ' their web server should receive a notification when the email is sent ' — a synchronous confirmation mechanism that a standard Triggered Send Definition (C) does not provide in the same direct, immediate way, since Triggered Sends fire based on a configured trigger without returning an inline API response to the calling system. A Multi-Step journey with an API Event entry source (B) introduces journey-evaluation timing overhead and, like Triggered Send Definitions, does not natively provide the synchronous, per-call send-status confirmation back to the web server that the Transactional Messaging API ' s request/response model delivers. An Email Send Activity (D) in Automation Studio is a batch, scheduled mechanism entirely unsuited to the fast, individual, event-driven, confirmation-requiring nature of this password-reset use case. Reference: Transactional Messaging API.

Marketing Cloud ' s Content Permissions and Restrictions by Role framework, configured through Setup and Role permissioning, is the native, platform-enforced mechanism that governs precisely which users and business units can view, access, or edit specific content folders and assets, and which content requires review before changes take effect. Because permissions are tied to defined roles rather than ad hoc individual grants, this creates consistent, auditable control over both content visibility (who can see what) and content editability (who can change what and under what review conditions), directly answering both parts of the stated requirement using tools already built into the platform. Option A, Approval Workflow and Share settings, addresses collaboration and folder-sharing scope but is not the comprehensive, role-based permission structure needed to fully control both access and edit/review rights across users and business units. Option B, integrating an external CMS, introduces unnecessary architectural complexity and cost when native Marketing Cloud role permissions already solve the stated need without external systems. Option D, relying purely on internal process without platform-enforced controls, leaves the requirement unenforced technically — process alone does not prevent unauthorized access or edits the way role-based permissioning does. Reference: Content Permissions and Restrictions by Role, Marketing Cloud Roles.

Data Filters in Contact Builder provide a point-and-click, drag-and-drop interface for building segmentation logic against attribute groups without writing SQL, which is exactly the on-ramp a non-technical team coming from manual Excel/VLOOKUP segmentation needs for sustainable self-sufficiency. Marketers can visually construct AND/OR filter logic against contact and related data, save the resulting filtered segment, and reuse or export it — replicating what they were doing manually in spreadsheets, but natively within the platform and without ongoing developer or consultant involvement. Query Activities (A), while powerful, require hand-written SQL syntax, which directly conflicts with the stated ' very little coding experience ' constraint and would create an ongoing dependency on technical resources rather than long-term self-sufficiency. Publication Lists (B) are a list-management construct for organizing subscribers by communication type/preference, not a segmentation-logic tool for building audiences from arbitrary attribute conditions. Attribute Groups (D) are the underlying Contact Builder configuration that defines which data extensions and relationships are available for segmentation — they are a prerequisite setup layer, not the marketer-facing segmentation tool itself; Data Filters are what marketers actually interact with to build audiences from those groups. Reference: Contact Builder Data Filters, Data Designer.