A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions.
Which workflow should meet these requirements?
A. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
B. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity
C. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
D. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Tracking Alias question:
A. Same URL
B. Email Conversion Tracking
C. Can be found in some reports
D. Differentiate clicking email
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
1.
Data for the campaign will be in two data extensions: Customer and New Accounts
2.
The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.
3.
The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.
Which automated workflow meets the customer's requirements?
A. A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
B. A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
C. A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
D. A scheduled automation that starts at 12:00 a.m. and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activity, and Send Email Activity.
A Marketing Cloud user needs the email addresses of everyone who unsubscribed from a particular email send. This user does NOT know SQL and does NOT have access to the Enhanced FTP account.
What functionality should be used to retrieve the necessary data?
A. My Tracking
B. My Reports
C. Tracking Extract
D. Data Views
A customer wants to configure appointment reminders for patients in their clinic. The reminder should be sent day before the appointment date at 10 a.m and the appointment record should be updated in the patient was sent a reminder email.
What solution could be recommended?
A. Create a journey with CRM data source triggered on the reminder data and use Journey Builder activities to send a reminder and update the record in Synchronized Data Extension.
B. Create a journey with CRM date based entry source, and use journey Builder activates to send a reminder and update the record in CRM.
C. Create a daily scheduled automation to refresh the audience, and use Automation Studio activities to send a reminder with AMPscript in the message to update the record in Synchronized Data Extension.
D. Create a daily scheduled automation to refresh the audience, and use Data Extension entry source for a journey with activates a reminder and updates the record in CRM.
A customer needs to import data from an SFTP site. The customer wants to:
1.
Segment the contents of the file and then send emails.
2.
Transfer the file to the SFTP site at various times daily.
3.
Send to data extensions.
Which workflow should meet these requirements?
A. Triggered Automation: Import File > SQL Query(s) > Send Email(s)
B. Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)
C. Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
D. Triggered Automation: Import File > Group Refresh > Send Email(s)
A consultant configured a triggered send definition in Sales Cloud for a customer using Marketing Cloud Connect, The trigger is on a Custom Object called 'Shipments' and is enabled for Triggered Sends in Setup.
Which two configuration requirements should be considered when troubleshooting? (Choose 2 answers)
A. The Shipment object is on the Account Related List.
B. There is a Master Detail Relationship from Contact to Shipment.
C. The Shipment object requires a Lookup to Lead or Contact.
D. An Apex Trigger is created on the Shipment object.
Northern Trail Outfitters (NTO) plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships. NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database.
What action should be taken when using Contact Builder? Choose 2 answers
A. Conduct manual imports of customer information from Sales Cloud.
B. Create a data extension to incorporate the imported data from a Salesforce Dashboard.
C. Combine each individual's channel contact information under one record.
D. Use Marketing Cloud Connect to include data from Sales Cloud.
Northern Trail Outfitters has a customer login page on their website and wants to use Marketing Cloud to send an email to customers who need to reset their password. The email needs to be sent as quickly as possible. Their web server should receive a notification when the email is sent.
Which solution should they use?
A. Triggered Send Definition
B. Transactional Messaging API
C. Multi-Step journey with an API Event entry source
D. Single Send journey with an API Event entry source
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 2 answers
A. Analyst
B. Administrator
C. Data Manager
D. Content Creator
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Salesforce exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your MARKETING-CLOUD-CONSULTANT exam preparations and Salesforce certification application, do not hesitate to visit our Vcedump.com to find your solutions here.