Free Salesforce Marketing Cloud Consultant Exam Dumps and Marketing Cloud Consultant Exam Questions

Question No: 21

MultipleChoice

Northern Trail Outfitters (NTO) stores customer purchase data m an external system. NTO ingests this data into Marketing Cloud through a file drop automation. The automation contains an import activity which overwrites a staging data extension, as well as an SQL Query activity which brings this data into a sendable data extension.

NTO's marketing manager wants to be informed If mort than 1,000 records are ever imported through this automation, and would also like to prevent the sendable date extension from being updated that day.

Which solution ts appropriate m this situation'

Options

AQ Split the existing activities into two
separate automations.

AImplement a Wait Activity to wait until the data extension is populated with records.

BPlace a Verification Activity between the import and SQL Query activity.

CWrite a custom SSJS script to

Dvalidate the row count of the staging data extension and send a notification email.
By placing a Verification Activity between the import and SQL Query activities, you can check to see if more than 1,000 records have been imported from the external system. If the row count exceeds 1,000, the automation can be paused and a notification email can be sent. This will allow NTO's marketing manager to be informed if more than 1,000 records are imported, and will also prevent the sendable data extension from being updated that day. For further information, please refer to the following Salesforce documentation:
* Automation Studio Overview:https://help.salesforce.com/articleView?id=mc_as_overview.htm&type=5* Automation Studio Activities:https://help.salesforce.com/articleView?id=mc_as_activities.htm&type=5* Verification Activity in Automation Studio:https://help.salesforce.com/articleView?id=mc_as_verification_activity.htm&type=5* Wait Activity in Automation Studio:https://help.salesforce.com/articleView?id=mc_as_wait_activity.htm&type=5

Question No: 22

MultipleChoice

N 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

Options

AConduct manual imports of customer information from Sales Cloud.

BCreate a data extension to incorporate the imported data from a Salesforce Dashboard.

CCombine each individual's channel contact information under one record.

DUse Marketing Cloud Connect to include data from Sales Cloud.

Question No: 23

MultipleChoice

Northern Trail Outfitters injects customers into journey B based upon email engagement in journey

Which method would facilitate this solution?

Options

AIn journey A, engagement split afteremail send. In Automation studio, query JourneyActivity data new for the Engagement split result Boolean field, Use result Data

BIn Automation Studio, query activity engagement on Journey System data view for email send to journey A; Use result data extension for journey B Subjects.

CIn Automation Studio, use verification activity to verify engagement on email in journey A' Query engagement data extension for journey B Subjects.

DIn journey A engagement split followed by Contact Activity to Boolean on an engagement data extension; Query engagement data extension injections.

Question No: 24

MultipleChoice

North Trail Outfitters (NTO) wants to automate the sending of shipping notices and a customer survey.

*Shipping notices will be sent once a day.

*The shipping file will be placed on the FTP sometime after 4:00 p.m.

*The shipping data will be stored in the shipping Notice data extension.

*A field in the data extension will contain the shipping data.

*The survey needs to be sent at 9:00 a.m., exactly 10 days after the customers order ships.

Which workflow would most effectively enable NTO to do this?

Options

AOption

BOption

COption

DOption