Certified Marketing Cloud Consultant practice test

1. Question 1 · 1

   A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings. ✑ Data for the campaign will be in two data extensions: Customer and New Accounts. ✑ The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m. ✑ The New Accounts data is encrypted and will be placed on the SFTP at 10:00 p.m. Which automated workflow meets the customers' requirements?

   Choose one answer.

   • A scheduled automation which starts at 2:00 a.m. and executes Data Extract Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
   • A drop automation which executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
   • A scheduled automation which starts at 2:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.
   • A scheduled automation which starts at 12:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.

   Read explanation

   Should start after 1:00 AM after data update. Since its encrypted so File transfer is required.

2. Question 2 · 1

   A user in Marketing Cloud needs to send an email to a Salesforce Report via a Send Flow process. How should the consultant meet this requirement?

   Choose one answer.

   • Assign the integrated user the Marketing Cloud for AppExchange User permission in Sales Cloud.
   • Create data validation rules for the integrated user in Sales Cloud.
   • Create a Salesforce Data Extension for the user to select during a Send Flow.
   • Add custom VisualForce Page to the page layouts in Marketing Cloud.

3. Question 3 · 1

   A user in the MC wants to use Salesforce custom object data for segmenting and personalization. How should the consultant approach this requirement?

   Choose one answer.

   • Map the custom objects to the profile center and use the email editor to insert the custom data. Create a user-initiated send to associate the email to the largest audience and return tracking data.
   • Sync contact and custom objects with Data Stream and send from Synchronized Data Extension with Salesforce email send. Ensure there is a lookup relationship to a contact or lead record.
   • Create a custom report type that contains the contact or lead ID, email address, and custom object data, then from the marketing cloud, import into a Salesforce Data extension. Use AMPscript in the email to call data.
   • Export report data from the sales cloud and import into a marketing cloud synchronized data extension. Use a filter activity to produce a sendable data extension. Create an email send activity in Automation Studio.

   Read explanation

   Sometime Create a custom report type is also an option.

4. Question 4 · 1

   A financial company wants to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following: ✑ Payments.csv will arrive on the Enhanced SFTP each Monday at 1 a.m. ✑ Payments.csv will be encrypted. ✑ Payments.csv will contain data from the previous week. ✑ Late payment notices will be sent each Monday at noon. ✑ They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send. Which automation sequence represents a viable solution?

   Choose one answer.

   • File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
   • Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
   • File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfer
   • File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer

5. Question 5 · 1

   Northern Trail Outfitters (NTO) account will be used for email communications with its clients and employees. They want to send from two different subdomains, so they have delegated e.nto.com as their SAP domain and mail.nto.com as an additional Private Domain. Which statement describes how this will impact the account?

   Choose one answer.

   • Links within emails will be wrapped with the same subdomain used for the From Address within the Sender Profile.
   • Links within emails will be wrapped with e.nto.com, and images within Content Builder will use e.nto.com.
   • Links within emails will be wrapped with mail.nto.com, but images within Content Builder will use e.nto.com.
   • Links within emails will be wrapped with e.nto.com, but images within Content Builder will use mail.nto.com.

6. Question 6 · 1

   Analyst of Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting. These metrics need to be reported per email campaign for each of NTO's Business Units: * Number of Sends * Delivery Rate * Overall Bounce Rate * Block Bounce Rate * Open Rate * Click Rate * Complaint Rate * Unsubscribe Rate Which email report should NTO's Marketing Analyst pull from Marketing Cloud to get this information?

   Choose one answer.

   • Campaign Email Tracking Report
   • Account Send Summary Report
   • Email Send Report
   • Email Performance Over Time Report

7. Question 7 · 1

   A pharmaceutical company is hosting a monthly event and will be sending an invitation to new local contacts. The customer would like to automatically update a data extension to determine who will be attending. ✑ The data extension will hold each contact's response as well as the time stamp of the click. ✑ The contact will receive an email two days after the click event. ✑ Both emails should be sent via Journey Builder. What is the optimal solution to record the click activity prior to sending the second email?

   Choose one answer.

   • Leverage the Decision Split and create a Custom Activity.
   • Use a landing page to record the click and trigger an email.
   • Leverage the Engagement Split and the Update Contact Activity.
   • Use a landing page to record the click in the data extension.

8. Question 8 · 1

   Which three statements are correct about Data Designer? (Choose three.)

   Choose all answers that apply.

   • Each attribute group contains one data extension, and each data extension can include up to 50 attributes.
   • Each attribute group can contain multiple lists, and each list can include multiple attributes.
   • Data extensions can be linked to either the contact record or different data extensions, including data extensions from other attribute groups.
   • Each attribute group can contain multiple data extensions, and each data extension can include multiple attributes.
   • Data extensions should be linked directly to the contact record prior to being linked to different data extensions.

9. Question 9 · 1

   Northern Trail Outfitters (NTO) wants to use dynamic content within their emails to provide customers with more personalized communications. This includes using a Dynamic Sender Profile to customize the From Name and From Email Address to use the regional store manager's information. If a new manager is assigned to a region, NTO only wants to update the information in one place. What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?

   Choose one answer.

   • Each customer's region code and the manager's name and email address for each region code.
   • Name and email address for each regional store manager stored on a lookup table.
   • Regional store manager's name and email address for each customer.
   • Region code, regional store manager's name, and email address for each customer.

10. Question 10 · 1

    A customer has an email newsletter to send out, but wants to deliver it with a targeted message for customers within a specified age range. These data have been defined in attributes from a sign-up landing page. How should the customer individualize the email content?

    Choose one answer.

    • Guide Template Language
    • Substitution Strings
    • Dynamic Content Areas
    • Personalization Strings

11. Question 11 · 1

    Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeroes, but they will NOT be included in the final values. Which data type should they use for the Order ID field?

    Choose one answer.

    • Number
    • Text (15)
    • Decimal (15,2)
    • Decimal (15,0)

12. Question 12 · 1

    An entertainment customer has added a new business unit for one of its record labels. It has also purchased a Sender Authentication Package (SAP) and owns the branded domain. What is necessary to complete SAP setup?

    Choose one answer.

    • Configure link wrapping to redirect to the business unit's subdomain
    • Configure custom Reply Mail Management for the business unit's subdomain
    • Delegate a specific subdomain to the Marketing Cloud name servers
    • Route the domain through an IP address unique to the business unit

13. Question 13 · 1

    An online retailer would like to utilize Journey Builder interactions for sending post-purchase communications to their customers. What Contact Entry mode best fits this scenario?

    Choose one answer.

    • Re-entry after time
    • Re-entry only after exiting
    • Re-entry anytime
    • No re-entry

14. Question 14 · 1

    An employee in a customer's IT department is responsible for maintaining the Login IP Whitelist and SFTP locations in Marketing Cloud. The IT Director has asked that this employee be given the minimum permissions necessary to complete only these tasks. How should the Consultant configure the IT employee's account?

    Choose one answer.

    • Administrator role, with all Content and Subscriber permissions disabled
    • Marketing Cloud Security Administrator role with account-wide access
    • Data Manager role with access to only the Parent Business Unit
    • Custom role with limited Administrator permissions enabled

15. Question 15 · 1

    A customer has been having problems with SMS responses getting the default keyword response rather than the appropriate next keyword response. What are two potential reasons for this unexpected response? (Choose two.)

    Choose all answers that apply.

    • Next keyword was not specified on the outbound message.
    • Response contained ג€stopג€ in the message content.
    • Responses are not sent within 24 hours of the outbound message.
    • Responses are sent after the 60 minute conversation window.

Paid access to all 77 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.