MCE-Admn-201 — Salesforce Certified Marketing Cloud Engagement Administrator

Full question text, answer options, and explanations for this practice set — a spoiler-free alternative is the interactive quiz above for scored, shuffled practice.

1. 1. When creating a new Marketing Cloud user, which setting controls what actions the user can take within Marketing Cloud?

   • A. The user's email address
   • B. The Role assigned to the user, which defines feature-level permissions(correct)
   • C. The Business Unit the user belongs to
   • D. The user's login method (SSO or standard)

   Explanation: In Marketing Cloud, a Role defines what a user can see and do — granular permissions for each product and feature area (e.g., can create emails, can send emails, can manage subscribers). Roles are assigned to users at the Business Unit level. The Business Unit determines which data and content the user can access, but the Role governs the actions they can perform.

2. 2. A Marketing Cloud administrator wants to prevent a user from being able to delete Data Extensions while still allowing them to create and edit them. How should they configure this?

   • A. Assign the user to a restricted Business Unit
   • B. Create a custom role with Create and Edit permissions for Data Extensions enabled and Delete permission disabled, then assign that role to the user(correct)
   • C. Set the user's account to read-only access
   • D. Remove the user from the 'Data Management' permission group

   Explanation: Marketing Cloud supports granular permission configuration through custom roles. An administrator creates a custom role, enables the specific permissions needed (Create Data Extension, Edit Data Extension) and leaves Delete Data Extension disabled. This user can then manage data structures without risking accidental deletion — a key principle of least-privilege administration.

3. 3. A company uses Single Sign-On (SSO) to authenticate Marketing Cloud users through their corporate identity provider. When SSO is enabled, how does initial user provisioning in Marketing Cloud work?

   • A. Users are automatically created in Marketing Cloud the first time they log in via SSO with no admin action required
   • B. A Marketing Cloud administrator must still create the user account in Marketing Cloud Admin first; SSO only handles authentication, not user creation(correct)
   • C. User accounts are created via SCIM provisioning from the identity provider with no Marketing Cloud admin action
   • D. Users can self-register in Marketing Cloud by using their corporate email address

   Explanation: Marketing Cloud SSO handles authentication (verifying who the user is) but not provisioning (creating the user account). An administrator must still create the user record in Marketing Cloud's Admin → Users section, assign the appropriate role and Business Unit, and enable SSO login for that user. Without the pre-created account, the SSO login will fail even with valid corporate credentials.

4. 4. Which two Marketing Cloud Admin settings must be configured before a new Business Unit can send commercial emails? (Choose 2)

   • A. A Sender Profile — defining the from name and from email address for the BU(correct)
   • B. A Send Classification — combining the Sender Profile, Delivery Profile, and send type(correct)
   • C. A Private IP address dedicated to the new Business Unit
   • D. A connected Salesforce CRM org via Marketing Cloud Connect

   Explanation: Before a Business Unit can send emails, administrators must configure: (1) a Sender Profile (from name, from address, reply-to address) — this represents the identity of the sender; (2) a Send Classification that links the Sender Profile to a Delivery Profile (IP pool and footer settings) and specifies whether sends are commercial or transactional. Without these, the email send wizard cannot complete. A dedicated IP and MC Connect are optional.

5. 5. A Marketing Cloud administrator needs to set up account-level reply mail management so that all replies to marketing emails are automatically processed and do not fill up the from-address inbox. Which Marketing Cloud feature handles this?

   • A. Return Path Management in the Delivery Profile
   • B. Reply Mail Management (RMM) configured in Setup, which processes replies — routing auto-replies, out-of-office messages, and unsubscribes automatically(correct)
   • C. A custom email routing rule in the corporate mail server
   • D. The Bounce Mail Management settings in the Sender Profile

   Explanation: Reply Mail Management (RMM) is a Marketing Cloud Admin feature that intercepts replies to marketing emails sent from the Marketing Cloud from-address. It auto-classifies replies (unsubscribe requests, auto-replies, out-of-office) and processes them accordingly — honouring unsubscribes, discarding auto-replies, and optionally forwarding other replies to a designated mailbox. Without RMM, replies land in the sender's inbox and unsubscribe requests may be missed.

6. 6. An administrator needs to share a Data Extension from a parent Business Unit so it can be used for sends in a child Business Unit. What must they configure?

   • A. Duplicate the Data Extension in each child Business Unit
   • B. Mark the Data Extension as 'Shareable' in the parent BU and then share it to the relevant child BUs from the parent(correct)
   • C. Grant the child BU Administrator role access to the parent BU
   • D. Export the parent BU Data Extension to SFTP and import it into the child BU daily

   Explanation: Marketing Cloud supports Data Extension sharing between Business Units. In the parent BU, the administrator marks the Data Extension as shareable (Shared Data Extension) and selects which child BUs can access it. Shared Data Extensions can be used as send audiences or data sources in the child BUs without duplication, and data is always managed centrally in the parent BU.

7. 7. What field in a Marketing Cloud Data Extension is designated as the primary key to uniquely identify each row?

   • A. EmailAddress
   • B. The field(s) marked as 'Primary Key' when the Data Extension is created(correct)
   • C. The auto-generated RowID field
   • D. SubscriberKey, which is automatically set as the primary key on all Data Extensions

   Explanation: When creating a Data Extension, the administrator designates one or more fields as the Primary Key. The primary key uniquely identifies each row and is used for upsert operations (insert new rows or update existing ones where the key matches). Any field can be the primary key — commonly SubscriberKey for subscriber-linked DEs, but it can be an order ID, product ID, etc. depending on the data model.

8. 8. A company imports subscriber records into a Marketing Cloud Data Extension using an Import Activity set to 'Update' mode. What happens to rows in the file whose Primary Key does not already exist in the Data Extension?

   • A. The new rows are inserted into the Data Extension
   • B. The new rows are skipped — Update mode only modifies existing records(correct)
   • C. The import fails with an error if any new keys are found
   • D. The new rows are added to a quarantine table for administrator review

   Explanation: Import mode 'Update' only modifies records where the Primary Key already exists in the Data Extension. Rows in the import file with new (unrecognised) keys are skipped. To both insert new records and update existing ones in a single import, use 'Add and Update' (upsert) mode. 'Overwrite' mode replaces all existing data with the file contents.

9. 9. An administrator wants to delete all rows from a Data Extension and replace them with a fresh data file. Which Import Activity mode should they use?

   • A. Update
   • B. Add Only
   • C. Overwrite(correct)
   • D. Delete

   Explanation: Overwrite mode deletes all existing rows in the Data Extension and replaces them entirely with the data from the import file. This is used when the file represents the complete current state of the data (e.g., a daily full extract). 'Add Only' inserts new rows and skips duplicates; 'Update' only modifies existing rows.

10. 10. What is the Marketing Cloud Contact model and why is it important for billing?

    • A. A Contact is a Data Extension row; billing is based on the number of email sends
    • B. A Contact is the unified identity record in Marketing Cloud's Contact Builder, representing a unique individual across all channels; the total Contact count is used for licence billing(correct)
    • C. A Contact is synonymous with a Subscriber in All Subscribers — they are the same record
    • D. A Contact is a record in Salesforce CRM synced via Marketing Cloud Connect

    Explanation: Marketing Cloud's Contact model (managed in Contact Builder) unifies a person's identity across channels using the Contact Key (equivalent to Subscriber Key). Every email subscriber, SMS contact, push subscriber, etc. resolves to a single Contact record. Marketing Cloud licences include a Contact count ceiling — exceeding it incurs additional billing, making Contact hygiene (removing inactive contacts) an important administrative responsibility.

11. 11. An administrator needs to build a segmented audience of all subscribers who received a campaign email in the last 90 days but did not click any link. Which two Automation Studio activities are needed to build this audience in a Data Extension? (Choose 2)

    • A. A SQL Query Activity joining the _Sent and _Click data views to find subscribers with sends but no clicks in the date range(correct)
    • B. A Query Activity writing the result to a target Data Extension that will be used as the send audience(correct)
    • C. A Data Extract Activity to export tracking data to SFTP for external processing
    • D. A File Transfer Activity to move the extracted file back into Marketing Cloud

    Explanation: The standard approach uses: (1) a SQL Query Activity that queries the _Sent system data view (filtered by EventDate in last 90 days) LEFT JOIN _Click (no matching click records) to identify the non-clicker segment; (2) the Query Activity writes the results to a target Data Extension that serves as the email audience. Data Extract + File Transfer are used when data must leave Marketing Cloud — not needed when writing to a Data Extension.

12. 12. A company's subscriber list contains duplicate email addresses with different Subscriber Keys. When these subscribers receive emails, they receive duplicates. What is the root cause and fix?

    • A. Marketing Cloud always sends one email per Data Extension row; deduplicate the source data before the send
    • B. Duplicate Subscriber Keys create separate Contact records; enable the 'No Duplicate Emails in Send' option on the send and standardise the Subscriber Key strategy upstream
    • C. Enable 'One Email Per Subscriber' in the Delivery Profile to suppress duplicates globally
    • D. Use a SQL Query Activity with SELECT DISTINCT EmailAddress to remove duplicates before the send(correct)

    Explanation: When a Data Extension contains multiple rows with the same EmailAddress (even with different Subscriber Keys), Marketing Cloud sends one email per row — resulting in duplicate delivery. The immediate fix is to use a SQL Query Activity with SELECT DISTINCT EmailAddress (and one representative Subscriber Key) to deduplicate the send audience before each send. The long-term fix is to standardise the Subscriber Key strategy so each person has exactly one Contact/Subscriber Key.

13. 13. What are Marketing Cloud system data views (e.g., _Sent, _Open, _Click, _Bounce) and how are they accessed?

    • A. System data views are reports in Marketing Cloud's analytics dashboard — they cannot be queried
    • B. System data views are read-only tables in Marketing Cloud's data layer that store tracking event data; they are queried using SQL in Automation Studio Query Activities(correct)
    • C. System data views are Data Extensions created by administrators to track email performance
    • D. System data views are REST API endpoints that return tracking data in real time

    Explanation: Marketing Cloud system data views (_Sent, _Open, _Click, _Bounce, _Unsubscribe, _Job, etc.) are read-only system tables maintained by the platform that store raw tracking event data. They are queried using SQL in Automation Studio Query Activities — for example, querying _Open to find subscribers who opened a specific job. They have a 6-month data retention window and cannot be modified directly.

14. 14. Which two approaches correctly remove a contact and all their data from Marketing Cloud to comply with a GDPR deletion request? (Choose 2)

    • A. Use the Marketing Cloud Contact Deletion feature in Contact Builder to delete the contact by Contact Key, which removes all channel data(correct)
    • B. Set the subscriber's status to Unsubscribed in All Subscribers — this deletes their data
    • C. Call the Marketing Cloud REST API Contact Deletion endpoint to programmatically delete the contact(correct)
    • D. Delete the subscriber's rows from all Data Extensions manually via the UI

    Explanation: GDPR deletion requires removing all personal data associated with a contact. Marketing Cloud provides: (1) the Contact Deletion feature in Contact Builder — an admin selects the contact by Contact Key and initiates deletion, which removes data from all channel-specific tables and system data views; (2) the REST API Contact Deletion endpoint (/contacts/actions/delete) for programmatic bulk deletion. Setting a subscriber to Unsubscribed only stops email sending — it does not delete data. Manually deleting DE rows is incomplete (system data views are not cleared).

15. 15. A Marketing Cloud Engagement administrator configures a Send Classification with the type set to 'Transactional'. How does this affect unsubscribe handling compared to a Commercial Send Classification?

    • A. Transactional sends do not require an unsubscribe link
    • B. Transactional sends are sent to subscribers who are Unsubscribed at the list level but still active at the all-sends level — they bypass list-level unsubscribes(correct)
    • C. Transactional sends cannot be tracked for opens and clicks
    • D. Transactional and Commercial sends have identical unsubscribe handling

    Explanation: A Transactional Send Classification is designed for non-marketing messages (order confirmations, password resets, billing notifications). Marketing Cloud allows transactional sends to be delivered to contacts who have unsubscribed from commercial communications at the list or publication list level — as long as they haven't opted out at the All Subscribers (all-sends) level. Transactional emails must still include an unsubscribe mechanism and physical address.

16. 16. An administrator notices that a significant portion of a recent send resulted in 'Soft Bounce' responses. What does a soft bounce indicate?

    • A. A permanent failure — the email address does not exist
    • B. A temporary delivery failure — the email could not be delivered at that moment (e.g., full inbox, server temporarily unavailable) but the address may be valid(correct)
    • C. The email was delivered but moved to the spam folder
    • D. The subscriber manually bounced the email back from their inbox

    Explanation: A soft bounce is a temporary delivery failure. Common causes include: full recipient mailbox, recipient mail server temporarily unavailable, or message size too large for the server. Marketing Cloud retries soft-bounced emails and tracks the bounce count. After a certain number of consecutive soft bounces (typically 3), the subscriber's status may be moved to 'Held'. A hard bounce (permanent failure) indicates a non-existent or invalid address.

17. 17. A company's dedicated IP address is newly warmed up. An administrator wants to monitor the IP's reputation proactively. Which tool should they use to check if the IP has been blacklisted?

    • A. Marketing Cloud's built-in Send Summary report
    • B. A blacklist monitoring service such as MXToolBox or Spamhaus lookup(correct)
    • C. Salesforce's IP Health Dashboard in Setup
    • D. Google Postmaster Tools Domain Reputation report

    Explanation: IP blacklist monitoring is done using third-party tools like MXToolBox (mxtoolbox.com) or by directly checking major blacklists (Spamhaus, Barracuda, SpamCop). These tools check whether an IP address appears on known real-time blacklists (DNSBLs). Marketing Cloud does not provide built-in blacklist monitoring — administrators should check proactively, especially during and after IP warming.

18. 18. A Marketing Cloud administrator sees that 15% of a recent send resulted in hard bounces. What immediate action should they take to protect sender reputation?

    • A. Resend the campaign immediately to the bounced addresses to confirm the bounce
    • B. Identify and remove the hard-bounced addresses from all future sends, investigate the source of invalid addresses, and improve list hygiene processes(correct)
    • C. Switch to a different IP address and resend the campaign
    • D. Contact Salesforce support to have the bounced addresses re-activated

    Explanation: A 15% hard bounce rate is extremely high (acceptable is below 2%) and signals serious list quality issues. Hard-bounced addresses should be suppressed immediately (Marketing Cloud auto-holds them, but the source data must be cleaned). The administrator must investigate where these invalid addresses came from (e.g., purchased list, outdated data, poor form validation) and fix the acquisition process to prevent future occurrences.

19. 19. What is the purpose of Automation Studio in Marketing Cloud?

    • A. To build multi-step customer communication journeys with waits and decision splits
    • B. To schedule and automate recurring batch processes — such as data imports, SQL queries, email sends, and file transfers — on a defined schedule or triggered by a file drop(correct)
    • C. To manage subscriber preferences and unsubscribe processing
    • D. To create and store email templates and content assets

    Explanation: Automation Studio is Marketing Cloud's batch processing and scheduling engine. It runs sequences of activities (import, query, send email, data extract, file transfer) either on a schedule (hourly, daily, etc.) or triggered by a file arrival on the SFTP (File Drop trigger). It is distinct from Journey Builder, which manages real-time, event-driven, per-subscriber communication journeys.

20. 20. An Automation Studio automation is configured with three steps in sequence: (1) Import Activity, (2) SQL Query Activity, (3) Email Send Activity. What happens if the Import Activity (Step 1) fails?

    • A. The automation skips Step 1 and continues with Step 2 automatically
    • B. The automation stops at Step 1 and does not run Steps 2 or 3; an error notification is sent to configured recipients(correct)
    • C. All three steps run regardless of individual step failures
    • D. Step 3 (email send) runs independently with the last successfully imported data

    Explanation: Automation Studio executes steps sequentially. If a step fails, the automation halts at that step and does not proceed to subsequent steps. This prevents downstream activities from running on incomplete or incorrect data. Administrators can configure email notifications (via the Automation's 'Notification' settings) to be alerted when an automation fails.

21. 21. Which two trigger types can start an Automation Studio automation? (Choose 2)

    • A. Schedule trigger — the automation runs at a defined recurring time (e.g., daily at 6 AM)(correct)
    • B. File Drop trigger — the automation starts when a file arrives in a designated SFTP folder(correct)
    • C. Email Open trigger — the automation starts when a subscriber opens an email
    • D. Salesforce Record trigger — the automation starts when a CRM record is updated

    Explanation: Automation Studio supports two trigger types: (1) Schedule trigger — the automation runs on a recurring schedule (hourly, daily, weekly, monthly, or once); (2) File Drop trigger — the automation monitors an SFTP folder and starts automatically when a file matching a specified filename pattern is detected. Email Open and Salesforce Record triggers are not Automation Studio triggers — those belong to Journey Builder.

22. 22. An administrator needs to export tracking data (open, click events) from Marketing Cloud to an external data warehouse every night. Which Automation Studio activity sequence achieves this?

    • A. Import Activity (reads from _Open data view) → File Transfer Activity (sends to SFTP)
    • B. SQL Query Activity (queries _Open and _Click data views and writes to a Data Extension) → Data Extract Activity (extracts DE to a file) → File Transfer Activity (moves file to SFTP)(correct)
    • C. Data Extract Activity (exports directly from _Open view to SFTP in one step)
    • D. Email Send Activity → Tracking Report Export → File Transfer Activity

    Explanation: Exporting tracking data to an external system requires three steps: (1) SQL Query Activity — queries the _Open and _Click system data views and writes results to a target Data Extension (system data views cannot be directly extracted); (2) Data Extract Activity — exports the target Data Extension contents to a delimited file in the Marketing Cloud SFTP; (3) File Transfer Activity — moves the extracted file from the MC SFTP to the external destination SFTP or location.

23. 23. Where does a Marketing Cloud administrator go to view aggregate performance metrics (sends, opens, clicks, bounces, unsubscribes) for an email send job?

    • A. Analytics Builder → Overview Dashboard
    • B. Email Studio → Tracking → Send Summary for the specific send job(correct)
    • C. Automation Studio → Activity Log
    • D. Contact Builder → Contact History

    Explanation: Email Studio Tracking provides the Send Summary for each email send job — showing aggregate statistics including total sends, deliveries, opens, unique opens, clicks, unique clicks, bounces, and unsubscribes. Administrators use this as the primary post-send performance report. Analytics Builder (Intelligence Reports) provides cross-send reporting and dashboards.

24. 24. A marketing operations administrator needs to build a scheduled report that exports click tracking data for the last 7 days to an SFTP each morning for the analytics team. Which approach uses only native Marketing Cloud tools?

    • A. Schedule an Automation Studio automation with a Query Activity (querying _Click) + Data Extract + File Transfer activities, triggered daily at a specified time(correct)
    • B. Configure a scheduled email report in Analytics Builder that sends data to an email address
    • C. Download the Send Summary manually each morning and email it to the analytics team
    • D. Configure an Intelligence Report to export directly to an S3 bucket

    Explanation: The fully native solution for scheduled data export to SFTP is an Automation Studio automation combining: SQL Query Activity (queries _Click with a date filter for last 7 days, writes to DE) + Data Extract Activity (writes DE to file on SFTP) + File Transfer Activity (moves file to destination SFTP). This runs automatically on the daily schedule without manual intervention.

25. 25. An administrator notices that email open rates have suddenly increased by 40% across all sends this month compared to last month. The email content and audience have not changed. What is the most likely technical explanation?

    • A. The subscriber list has grown, driving more absolute opens
    • B. A large portion of the subscriber base migrated to Apple devices, and Apple Mail Privacy Protection is pre-fetching the tracking pixel, inflating open counts(correct)
    • C. Marketing Cloud's tracking infrastructure was upgraded, improving open detection accuracy
    • D. Email deliverability improved due to IP warming completion

    Explanation: A sudden and unexplained spike in open rates without corresponding click rate increases is a classic indicator of Apple Mail Privacy Protection (MPP) impact. MPP pre-loads emails on Apple proxy servers, registering an 'open' in Marketing Cloud even without the subscriber opening the email. When a significant portion of the list upgrades to iOS 15+ / macOS Monterey+, open rate can spike by 30-50% while click rates remain flat. Marketers should deprioritise open rate and focus on click-based metrics.