Marketing Cloud Engagement Consultant Free Sample Questions

12 free sample questions161 in the full practice test

Try simulator

MCE-Con-201 Sample Questions

  1. Question 1

    Intermediate

    Automation · Automation Studio Activities

    A financial services client requires a secure method to import sensitive customer financial data into Marketing Cloud Engagement daily. The data is generated by an on-premises legacy system and encrypted using PGP before transmission. The consultant needs to design an automation to ingest this data safely.

    Which sequence of activities in Automation Studio correctly handles this requirement?

    Answer and explanation

    Correct answer: A

    The correct sequence involves first using a File Transfer Activity configured with the 'Manage File' action to decrypt the PGP-encrypted file found on the Enhanced FTP. Once decrypted, the file is available in the Safehouse (or specified location) for the Import File Activity to process it into a Data Extension. Direct import of encrypted files is not possible without the decryption step.

    flowchart LR A[Encrypted File on FTP] -->|File Transfer Activity| B[Decrypted File in Safehouse] B -->|Import Activity| C[Data Extension]
  2. Question 2

    Advanced

    Integration · Marketing Cloud Connect

    A global retailer is implementing Marketing Cloud Connect to integrate with their Salesforce CRM. They operate in a Multi-Org environment where the European and North American Salesforce orgs must both connect to a single Marketing Cloud Enterprise 2.0 account. The European team requires that their Marketing Cloud users only see data and email sends relevant to the European Salesforce org.

    Which configuration setting is critical to achieving this visibility restriction?

    Answer and explanation

    Correct answer: B

    In a Multi-Org environment, 'Scope by User' is the configuration that respects the Salesforce user's data visibility rules when accessing Marketing Cloud Connect features. If a Marketing Cloud user is mapped to a Salesforce user in the European org, 'Scope by User' ensures they only see reports, sends, and data consistent with that Salesforce user's permissions, effectively segregating the view between regions.

  3. Question 3

    Intermediate

    Data Modeling · Contact Builder

    A consultant is designing the data model for a travel agency. The agency has a 'Subscribers' master data extension and a 'Bookings' data extension. One subscriber can have multiple bookings. The goal is to send a journey email 3 days before each booking date.

    How should the data relationships be configured in Contact Builder to support this journey entry?

    Answer and explanation

    Correct answer: A

    To support a journey based on transaction dates where a single contact has multiple records (bookings), the relationship in Contact Builder must be One-to-Many. This allows the journey engine to evaluate each booking record independently against the entry criteria (3 days before booking date).

  4. Question 4

    Intermediate

    Data Modeling · SQL

    A healthcare provider needs to send appointment reminders via SMS. They have collected mobile numbers in various formats (e.g., '(555) 123-4567', '555.123.4567', '+1-555-123-4567'). The consultant needs to ensure these numbers are valid for MobileConnect before importing.

    Which SQL function would be most effective in a Query Activity to normalize these numbers to the required format (e.g., '15551234567' for US code 1)?

    Answer and explanation

    Correct answer: C

    The consultant should use nested REPLACE functions to strip out non-numeric characters (parentheses, dashes, dots, spaces) and then use CONCAT (or the '+' operator) to prepend the country code if it is missing. This ensures the data meets the strict E.164-like formatting requirements of MobileConnect.

  5. Question 5

    AdvancedMultiple answers

    Integration · Data Integration Strategies

    Select TWO reasons why a consultant might recommend using a Synchronized Data Source over a Salesforce Data Entry Event in Journey Builder for a specific use case.

    (Select TWO)

    Answer and explanation

    Correct answers: A, C

    Salesforce Data Entry filters are limited in how deep they can traverse object relationships. For complex criteria involving multiple hops (e.g., Account -> Custom Obj A -> Custom Obj B), it is better to sync the data and use SQL to segment the audience precisely before injecting them into the journey.

    Salesforce Data Entry Events generally require the source object to be related to a Who (Lead/Contact/User) or Person Account. If the data resides in a custom object with no direct link, syncing the data first and then using a scheduled automation or query to identify the audience is a necessary architectural pattern.

  6. Question 6

    Intermediate

    Account Configuration · Deliverability

    A university is setting up a new Marketing Cloud instance. They plan to send 2 million emails during their first week for an alumni fundraising campaign. They have purchased a Sender Authentication Package (SAP) with a dedicated IP.

    What is the primary risk of proceeding with this volume immediately, and what is the correct mitigation?

    Answer and explanation

    Correct answer: C

    A new Dedicated IP has no sender reputation. Sending high volumes (2M) immediately looks like spam behavior to ISPs (Gmail, Yahoo, etc.) and will result in blocks or bulking. The standard mitigation is IP warming: starting with small volumes to highly engaged users and doubling volume every few days/weeks to build a positive reputation history.

    xychart-beta title "IP Warming Volume Strategy" x-axis [Week 1, Week 2, Week 3, Week 4] y-axis "Volume" 0 --> 500000 bar [50000, 100000, 250000, 500000]

Register free for 6 more questions

Or unlock all 161 MCE-Con-201 questions with explanations, timed mode and flashcards.