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: 27)

Page 27 of 74
PDF with 293 Questions

The customer has the following requirements for storing engagement data in their data warehouse:

*All email open and click activity must be pulled daily from Marketing Cloud.
*Output files must meet the specific requirements for the data warehouse.
*All the activity must be provided via SFTP in one file.

Which automation workflow meets the customer requirements?

  1. Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity
  2. Report activity that generates Recent Send Summary report > Report delivered directly to SFTP
  3. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity
  4. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity

Answer(s): C



A restaurant supply company captures email subscribers and leads through trade shows. This has always been a manual process with booth visitors leaving contact information in a fishbowl. The restaurant supply company is updating their process to an online sweepstakes entry that allows entrants to confirm opt-in for a monthly newsletter.
Which two components are appropriate for this solution? Choose 2 answers

  1. CloudPage with Web Collect to add entrants in to a data extension
  2. Send Email Activity with a link to a subscription center
  3. CloudPage with Smart Capture to add entrants in to a data extension
  4. Data extension with double opt-in status defined

Answer(s): C,D



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?

  1. Personalization Strings
  2. Substitution Strings
  3. Dynamic Content Areas
  4. Guide Template Language

Answer(s): C



A consulting has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today’s product catalog. The product catalog is never the same; products can be added and removed.
Which import type should be used?

  1. Overwrite
  2. Add Only
  3. Add/Update
  4. Update Only

Answer(s): C



Page 27 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