MARKETING-CLOUD-CONSULTANT Online Practice Questions and Answers

A publishing company has presented the following:

1.

A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.

2.

A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.

3.

The customer's expiration date is included in the data file.

What component should the customer's solution include? Choose 3 answers

A. Suppression list

B. Data Filter

C. Triggered Send

D. Template-based emails

E. Automation Studio

A subscriber asked to be removed from a customer's email list multiple times by replying directly to the customer's marketing message, but continues to receive emails.

Which steps will solve how replies are managed by the application?

Choose 3 answers

A. Confirm that Reply Mail Management (RMM) is configured for the customer's account.

B. Confirm that the RMM setting 'Unsubscribe Manual Requests' is set to YES.

C. Confirm that the RMM setting 'Delete auto-replies and out-of-office replies' is set to NO.

D. Confirm that an email address was provided as the Routing Address for Remaining Replies.

E. Confirm that the subscriber's request contained one of the standard terms that qualify for automatic unsubscribe.

Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.

In which two ways could this distributor-specific sender profile be configured in a Marketing Cloud account with Sender Authentication Package implemented?

Choose 2 answers

A. Pick "Choose from list," selecting the From Name and From Email values from the list of account users.

B. Match the external keys of the sender profile and data extension containing account representative details.

C. Utilize AMPscript data extension lookups to dynamically populate the From Name and From Email values.

D. Use substitution strings to populate the From Name and From Email values in the sender profile.

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

1.

CustomerlD

2.

FirstName

3.

EmailAddress

4.

OrderlD

5.

OrderDate

6.

ShippedDate

Which SQL statement should the consultant use?

A. SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD

B. SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD

C. SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD

D. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

Northern Trail Outfitters receives data from their point-of-sale system every night. The file is placed on their Enhanced FTP, but there is not a consistent time or naming convention for the file.

In which two ways should they set up their automation to import the data from the file on a nightly bais? (Choose 2 answers)

A. %%BASEFILENAME_FROM_TRIGGER%%

B. %%BASEFILENAME_FROM_FILEDROP%%

C. Scheduled Starting Source

D. File Drop Starting Source

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?

A. Route the domain through an IP address unique to the business unit.

B. Configure link wrapping to redirect to the business unit's subdomain.

C. Configure custom Reply Mail Management for the business unit's subdomain.

D. Delegate a specific subdomain to the Marketing Cloud name servers.

A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails.

What should a consultant recommend?

A. Create an auto-suppression list populated with the known email addresses.

B. Create an exclusion list with the known email addresses.

C. Populate a list using a query to exclude the subscriber key.

D. Create an auto-suppression list populated with subscriber keys.

A customer wants to limit the number of emails a subscriber receives to a maximum of one email every 14 days. After the 14-day period, the subscriber is eligible to receive the next message.

What should a consultant recommend to meet this criteria?

A. Import the identified subscribers into a list when creating the send.

B. Create an exclusion data extension populated with the identified subscribers.

C. Query contacts from the Einstein Engagement Frequency data extension when creating the send.

D. Create a suppression list populated with the identified subscribers.

A customer indicates their point-of-sale system can be configured to upload a file every fifteen minutes. The filename is not consistent for each upload. Their consultant recommends they use a File Drop Automation.

Which two considerations should be made? Choose 2 answers

A. They may utilize an external FTP site.

B. The directory is unable to be used by another File Drop Automation.

C. The directory used by the file trigger should be inside the import directory.

D. The directory cannot contain more than five file triggers.

When Northern Trail Outfitters acquires a new customer, it would like to send a series of welcome messages on behalf of the brand with an optimized send time. New customers will be sent to Marketing Cloud via an hourly batch file drop.

Which solution should the consultant recommend?

A. Use Journey Builder to process and segment the new customers, and for the campaign sends and decisioning.

B. Use Automation Studio to process and segment the new customers, and use Journey Builder for the campaign sends and decisioning.

C. Use Automation Studio to process and segment the new customers, and use Email Studio for the campaign sends and decisioning.

D. Use Automation Studio to process and segment the new customers, and for the campaign sends and decisioning.