Certified Marketing Cloud ConsultantPreview

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?

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?

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

A marketer wants to create and edit email content, as well as generate reports and manage subscriber data.
Using the principle of least privilege, which two pre-defined roles should be assigned? (Choose two.)

Northern Trail Outfitters (NTO) uses Marketing Cloud to connect with its individual consumers, retailers and wholesale buyers, and its corporate apparel customers. Marketing Cloud is currently configured with data extensions containing Store, Order, Product, and Contact information. NTO is in the process of implementing Data Designer and linking its data extensions.
How should consumers, retailers, and wholesale buyers be defined in Data Designer?

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?

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?

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?

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?

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

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?

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?

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?

Which two statements are accurate regarding segmentation options in Marketing Cloud? (Choose two.)

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?

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?

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?

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.)

A retail company's database of record resides at a third party company that also keeps track of purchase history. Their database only updates once a day where new records can be created and merged. The database uses the unique identified "Customer ID".
The company wants to send real-time Welcome emails to newly registered website users who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Customer ID" in the database.
What three key issues should be addressed? (Choose three.)

Northern Trail Outfitters stores birthdate on the contact object in the Salesforce CRM. They want to inject the contact into a journey on their birthday.
Which two Journey Builder entry process configurations allow for an injection using the customer's birthday? (Choose two.)