- All Exams Instant Download
Which SQL statement would produce the desired results?
A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links. Which SQL statement would produce the desired results? A) B) C) D) A . Option A B. Option B C. Option C D. Option DView AnswerAnswer: C
What updates should be made to ensure this SQL statement returns the desired results?
A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL...
Which application utilizes the REST API?
A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?A . Automation Studio B. Classic Content C. Content BuilderView...
Which two automations would accomplish this?
A customer wants to export send data to their SFTP. Which two automations would accomplish this? Choose 2A . Tracking Extract B. Tracking Extract > File Transfer C. Query (Data Views) > Data Extension Extract > File Transfer D. Query (Data Views) > File TransferView AnswerAnswer: B,C
How should the SMS message be triggered once the subscriber submits the form?
A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subscriber submits the form?A . Outbound SMS template and Automation Send Method B. InsertData AMPscript function to add the subscriber to a MobileConnect list...
Which scenario would cause subscriber records to remain in the data extension?
A developer wants to delete a batch of subscribers from Marketing Cloud. The developer performs a Contact Delete on a batch of records in a data extension in Contact Builder. Which scenario would cause subscriber records to remain in the data extension?A . Sendable data extension with SubscriberKey and EmailAddress...
Which two File Transfer activities are needed to achieve this?
Certification Aid wants to import an encrypted CSV file from the Marketing Cloud Enhanced FTP server. Which two File Transfer activities are needed to achieve this? Choose 2.A . To decrypt the import file on the Enhanced FTP server. B. To move the import file from the Safehouse to Marketing...
Which AMPscript function could easily determine if a specific text string exist anywhere in the list?
A field value returned from a DE lookup contains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?A . Substring B. BuildRowSetFromString C. IndexOf D. LengthView AnswerAnswer: B
New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder.
New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder. What would allow the data extension to be selected for journey entry'A . At least one Campaign must be associated to the data extension....
Which two objects are required to successfully create a TriggeredSend object?
Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPScript's API functions they will send a confirmation email when an email is texted into their short code. Which two objects are required to successfully create a TriggeredSend object? Choose 2 answersA . Subscribers...
