clapgeek logo
NTO is using a mobile campaign to collect an 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 tosuccessfully create a TriggerSend object? Choose 2
Customer data has been imported into a staging data extension andneeds to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query'' Choose 2 answers
Northern Trail Outfitters wants to trigger follow upmessages after a subscriber opens an email.
What process would they use to get real-time engagement data?
Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPScript'sAPI 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 answers
A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?
Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.
Which two file encryption options are supported when importing data files to Marketing Cloud?
Choose 2 answers
A doctor's office creates Populations for staff, patients and vendors. What is the maximum number of Populations that should be created to ensure performance?
Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.
A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may containline breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.
Which SQL functions could be used to change each line break to a single space?
A developer started a Contact Delete process that is now complete.
In which twoplaces would the Contact Delete process remove data? Choose 2 answers
A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?
A developer needs to process a payload from an external system in a CloudPage.
What Marketing Cloud Server-Side JavaScript Platform function should be used for converting a string payload in JSON format to a JavaScript object?
Which two AMPscript HTTP functions allow an OAuth token to be passed in a header?
Choose 2 answers
A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which querywould provide that result?
A)
B)
C)
A developer wants to add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?
What is the operational order of the Contact Delete process for Marketing Cloud?
Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and thefile name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.
NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given these requirements? Choose 3
A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error. What should the developer check to troubleshoot the error?
Which two ways would a developer write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean field in the Sendable Data Extension?
Choose 2 answers
A developer wants to create a data model in Contact Builder.
Which two applications will be able to use this newly-created data model for segmentation?
Choose 2 answers
A company has chosen to use the REST API for triggered sends, but they continue to get the following error during their testing: "Unable to queue Triggered Send request. There are no valid subscribers." They were informed that the SOAP API provides more information about the error, and found that their payload did not include a required data extension field.
Which element of the SOAP API response provides this level of detail?
A particular data extension need to be configured to store six months of data.
How shoulddata retention be added to the data extension in Email Studio?
A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber.
In which way could the developer create the CTA link?
An email requires custom AMPscript to append the subscriber's zip code to a link in theemail. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose
A developer wants to retrieve all recordsin the OrderDetails data extension which are associated with a particular customer.
Which two AMPscript functions would return a suitable rowset?
Choose 2 answers
NTO had an Enterprise 2.0 account; subscribers unsubscribes from the business unit only. A developer is identifying subscribers who unsubscribed from any of the NTO child business units. Which method wouldidentify the most accurate status for subscribers of each business unit?
A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the performance? Choose2
A developer wants to build out aseries of CloudPages that will interact with several REST APIs.
Which Marketing Cloud supported scripting tool should be used?
NTO puts the word TEST at the beginning of the namefor each test email. Which query would return the subs who were sent those emails?
How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.
Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.
From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?
When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?
A developer identified a use case where a triggeredsend of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls. When the REST call is made, a "401 Unauthorized" error is returned. What is the first thing the developer should check?
A developer wants CloudPages to work with a REST API returning data in JavaScript Object Notation. The developer wants to efficiently ingest the data and write it to a data extension.
Which function should be used?
Certification Aid wants to add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.
A developer wants to configure an automation to import files placed on the SFTP shared by a customer's data vendor. The automation will start when a file matching a specific namingpattern is encountered in the Import folder. The first step of the automation is a File Import Activity referencing a substion string for the matching file. Which substituon string represents the name of the file?
A developer receives a request for tracking data for alt sends associated with a specific JoblD. The developer needs to see Sends, Opens, Clicks, and Bounces.
Which two activities could the developer use? Choose 2 answers
A developer is configuring a File Drop Automation and wantsto use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.
Which two configurations should be used for the automation to successfully start? Choose 2 answers
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 developer is troubleshooting why an API client Jd and chent_secret are authenticating yet failing to access data from a child business unit.
What should be checked to validate the installed package can access the child business unit data?
A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?
An UpdateDE AMPscript function is used to update a column value in a data extension row when an email is sent. The emailis being sent to 250,000 subscribers, but the user decides to cancel the send during the sending process and only 400 emails are sent.
How many subscriber rows would be affected by the UpdateDE function?
A developer want to email a subscriber who is currently being processed for a Contact Deletion request. When could the Contact be reintroduced after a Contact Delete operation has started?
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 developer is building an integration with theMarketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?
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 developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validatethe data available can be accessed for child business unit queries?
Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields arevisible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.
Northtrn Trail Outfitters has set up their North American business unit to unsubscribe at the business unit level.
Which dataview would they query to identify all subscribers who are unsubscribed from that Business Unit?
TESTED 05 May 2024