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?
Where can the SSJS Core library be used? Choose 2.
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?
A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views. Which activities should the developer build togenerate the data before transferring it to the SFTP?
A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2
Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.
A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers
Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a dataextension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to becreated in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = 'NY' AND US = 1
What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?
A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code.
Which syntax should the developer use?
A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture toolwill call the Marketing Cloud API to create a data extension every time a new lead form is published. The created data extension's name should match the name of the form exactly.
Which API feature could the developer use to dynamically create these data extensions?
A developer uses the messageDefinitionSends REST API endpoint to send a triggered send email. This method returns a 202 (success) response code. How could the developer validate if the email was successfully sent?
Which programming language should be used in email messages? Choose 1.
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?
A customer wants a list of subscribers who were sent an email within the past 12 months.
How shouldthis request be completed?
Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 = 30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.
A developer used LookupRowsto retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?
When do synchronous REST API calls to Marketing Cloudtime out? Choose 2.
A company needs to retrieve a large number of rows from a data extension via the API.
Which two solutions would optimize the performance?
Choose 2 answers
How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?
A developer built a complex dynamic email with many data variants. Rather than create test data manually, they want to use a subset of live data to validate the dynamic aspects of the email.
Which SQL function should be used to collect a representative sample from a larger data set?
A developer created anemail with AMPscript variable as the subject line. The subject line variable was recently updated, but when testing the email, the wrong subject line continues to appear in the inbox. The developer thinks another, outdated, subject line variable is declared within the email. Where could the outdated variable be located?
A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?
Which statements are trueregarding the Marketing Cloud SOAP API? Choose 2.
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 wantsto implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?
A developer needs to push real-time updates of the company's product catalog to a data extension.
Which two API options are available? Choose 2 answers
What is the operational order of the Contact Delete process for Marketing Cloud?
A developer wants to create a complex dynamic email with three different sections and four different possible content blocks In each section. The email will be sent to an audience of over one million contacts.
Which best practice should the developer use to ensure a blank email will not be sent?
What is the purpose of the IF statement below?
A developer, who is new to Marketing Cloud, needs to design a landing page for a new customer. They choose to use Server-Side JavaScript (SSJS) due to their extensive knowledge of JavaScript from previous projects.
Which two features would the developer be able to leverage in their Server-Side code? Choose 2 answers
A developer needs to create a fully-branded CloudPagewhich includes images hosted in Content Builder. The developer wants to secure the page and its elements using the SSL protocol.
What is the minimum number of SSL certificates required?
A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?
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?
NTO uses data extensions to manage the subscriber information usedfor their email sends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated usingan InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?
A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?
A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for eachmonth in the following way:
How should the developer use AMPscript to generate the total?
Northern Trail Outfitters has created subscriber attributes including AGE underProfile Manager within their Enterprise 2.0 account.
How would a developer retrieve subscribers over 30 years of age?
A developer is creating a custom preference center and wants to log unsubscribeevents from the CloudPage. Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?
A developer has a text field in a data extension they want to format using the FormatCurrency AMPscript function. Which two values would return $6.96? Choose 2
Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer data is stored in a data extension with the Subscriber Key set as a Primary Key.
Which step is required for NTO when creating relationships for this data extension in Data Designer'
A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including:
Which subject line will be used at the time of deployment?
NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use topersonalize emails from an external data source?
A developer is querying data from the _Bounce data view and storing it in a data extension. They have found that sometimes the fields SMTPBounceReason and SMTPCode exceed the 4000-character limits for each field as specified in the DE schema. After consulting with the original requestor, it was decided that they could simply store the first 4000 characters for each of those fields.
Which SQL function could be used for this purpose?
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.
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 set a variable to use a field from a Sendable Data Extension.
Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension usedto send the email? Choose 2 answers
A developer needs to know how many records are contained in a particular data extension. This will dictate what is displayed on a landing page.
Which AMPscript functionreturns the number of rows in a specified data extension?
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.
Certification Aid sends an email to a newly imported List with Subscribers who have no associated Subscriber Key. Which value will become the Contact Key? Choose 1.
Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.
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
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?
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?
A marketer is planning a weekly promotionalsend.
Which two types of data extensions could be sent to?
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
What parameter should a developer include to ensure the MobileConnect Contactis tied to the Email Contact when making a QueueMO call for an existing email subscriber?
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.