A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:
*Imported iota a staging data extension.
*Separated into two different data extensions.
Which automation should meet these requirements?

• A.Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
• B.File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
• C.File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
• D.Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters wants to send an email to one million contacts in Sales Cloud. The criteria to segment contacts include using 10+ fields to segment.
Which process should the consultant utilize for a reliable send method?

• A.Import Salesforce Report through an import activity to a Salesforce Data Extension, then send to data extension using Email Studio email send
• B.Assign the one million contacts from the report to a Salesforce campaign, and use a Single Step journey with Salesforce Campaign as an entry event
• C.Query Synchronized Data Extensions using a query activity to a Salesforce Data Extension, then send via Email Studio Send Flow
• D.Send to a Salesforce Report from Marketing Cloud using Email Studio Send Flow

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters (NTO) wants to find ways to better drive return on investment and growth via their marketing sends. They plan to centralize their analytics data to allow for a more efficient analysis of this data across all of their campaigns. NTO currently has Marketing Cloud, Sales Cloud, and a third-party warehouse service.
What product would help their use case?

• A.Report Studio
• B.Datorama
• C.Interaction Studio
• D.Web Analytics Connector

Comment: *

Name: *

Email: *

Verification: *

A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. The customer has indicated the following:
* Emails will be built using a custom dynamic template for these messages.
* Links will vary over time and across campaigns.
* Click activity will be cross-referenced with subscribers' regional markets on a master subscriber data extension.
* Retargeting messages will dynamically populate content based on regional market.
In order for this solution to be viable, which skill set does the customer team need to possess?

• A.SSJS
• B.HTML
• C.SQL
• D.AMPscript

Comment: *

Name: *

Email: *

Verification: *

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity.
The list is:
* Compiled in a database in the website Content Management System (CMS).
* Imported into Marketing Cloud nightly at 11 p.m.
What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

• A.They will need to integrate with the Marketing Cloud SOAP API.
• B.Unsubscribes should be synchronized between senders.
• C.Engagement metrics will be passed into Marketing Cloud.
• D.The third-party send list should be pulled from the CMS

Comment: *

Name: *

Email: *

Verification: *