CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Salesforce
  5. Certified Marketing Cloud Consultant

Free Certified Marketing Cloud Consultant Exam Braindumps (page: 39)

Page 39 of 74
PDF with 293 Questions

A customer needs to import data from an SFTP site. The customer wants to:

• Segment the contents of the file and then send emails.
• Transfer the file to the SFTP site at various times daily.
• Send to data extensions.

What sequence of automation activities should meet these requirements?

  1. Scheduled: Import File > SQL Query(s) > Send Email(s)
  2. Scheduled: Transfer File > Import File > SQL Query(s) > Send Email(s)
  3. File Drop: Import File > SQL Query(s) > Send Email(s)
  4. File Drop: Import File > Group Refresh > Send Email(s)

Answer(s): C



A customer wants to perform an email send to a subset of Synchronized Data Extension referencing Sales Cloud custom object data and return tracking to Sales Cloud.
Which two approaches should the consultant recommend? Choose 2 answers

  1. Use Synchronized Data Source to sync Sales Cloud objects to Marketing Cloud.
  2. Use SQL Query Activities to output a Sendable Salesforce Data Extension.
  3. Use SQL Query Activities to create a Sendable Synchronized Data Extension.
  4. Use Data Filters to segment data to output a Sendable Data Extension.

Answer(s): A,B



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

  1. Pick “Choose from list,” selecting the From Name and From Email values from the list of account users.
  2. Match the external keys of the sender profile and data extension containing account representative details.
  3. Utilize AMPscript data extension lookups to dynamically populate the From Name and From Email values.
  4. Use substitution strings to populate the From Name and From Email values in the sender profile.

Answer(s): C,D



A company collects subscriptions on its websites. It does the following:

• Compiles that subscription list in a database in the website content Management System (CMS).
• Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
• Uses Marketing Cloud as the database of record.
• Sends up to five emails a week based on subscriber engagement with prior sends.

What automation sequence (excluding waits) should cover these requirements?

  1. File Transfer > Import File > Measures > Send Email
  2. File Transfer > Import File > SQL Query > Send Email
  3. File Transfer > SQL Query > Measures > Send Email
  4. File Transfer > Data Extract > Filters > Send Email

Answer(s): B



Page 39 of 74



Post your Comments and Discuss Salesforce Certified Marketing Cloud Consultant exam with other Community members:

Shobena commented on June 19, 2024
Yesterday I gave this exam. Passed it on the first try. This prep material is very accurate and cover all topics.
INDIA
upvote