Marketing cloud developer

Clock Kicks would like to encrypt and store form data submitted from a CloudPage in a data extension using AMPscript. Which three encryption options could be used when creating a new key in Key Management? Choose 3

NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of the recipient. Language is stored in a Profile Attribute. Which two Data Views would be included in the query? Choose 2 answer

What parameter should a developer include to ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber?

A developer wants to create an AMPscript FOR loop that populates HTML table rows based on the number of rows and data in a target DE. Where should the developer place the FOR keyword to begin the loop?

Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.

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

From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

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

NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?

NTO is using an asynchronous SOAP API call to the TriggerSend object to send order confirmation email to their customers. Which API object and attribute should be used to retrieve the status of the API call?

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 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?

A developer wants to programmatically inject Contacts into a journey via REST API. What is the recommended route using POST data extension fields and values?

A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the performance? Choose 2

NTO wants to exclude sending an email at send time to those with a record on the 'Exclude' Data Extension. The primary key on this data extension is Subscriber Key. How would a developer write the Exclusion Script?

NTO wants to exclude sends to specific subscribers based on a business rule, which is defined in an Exclusion Script. Which three types of sends would support this functionality? Choose 3

A particular data extension need to be configured to store six months of data. How should data retention be added to the data extension in Email Studio?

A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installed properly. What should be confirmed next to continue troubleshooting the send's tracking information?

A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?

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

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

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 to successfully create a TriggerSend object? Choose 2

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

How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is 'true' (Data Type = Formula(Boolean)) -ContactType equals 'Phone' (Data Type = Text). Which field could be used to select a subset of records in the synchronization configuration?

A developer receives a 401 Unathorized HTTP status message from a REST API request. What is the reason for this error?

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?

A developer wants to transform the date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

How often should a developer request a new token when making multiple API calls in v1?

A developer wants to use the RaiseError Ampscript function when a subscriber does not have the necessary data to build an email. Which two outcomes are possible using this function? Choose 2 answer

NTO uses data extensions to manage the subscriber information used for 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 using an 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 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?

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 would identify the most accurate status for subscribers of each business unit?

A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

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 naming pattern 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?

What is the operational order of the Contact Delete process for Marketing Cloud?

What parameter should a developer include to ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber?

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?

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 create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

Which of the following is a valid comment within an AMPscript code block? Choose 1.

Which programming language should be used in email messages? Choose 1.

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.

Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page. When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

Which statements are true regarding the Marketing Cloud SOAP API? Choose 2.

Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.

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.

ertification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.

Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible 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.

Certification Aid created a journey and event definition in Marketing Cloud. Which of the following resources are relevant to inject Contacts into the journey using the REST API? Choose 2.

When do synchronous REST API calls to Marketing Cloud time out? Choose 2.

Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

A developer is using the REST Authorization Service to obtain an OAuth access token. Which method should be used to include the access token in the API requests

A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete. How could the process be expedited?

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?

Contact Builder can be used to create a relational model of an organization's data within Marketing Cloud. Which three factors should be taken into consideration when preparing data to be used in Contact Builder? Choose 3 answer

A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

A developer is creating a custom preference center and wants to log unsubscribe events from the CloudPage. Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose 2

A developer wants to personalize a welcome email with the recipient's first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensions contain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?

A developer identified a use case where a triggered send 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 marketing director at NorthernTr ail Outfitters wants to analyze the Send, Click, and Open Data Views. Which activities should the developer build to generate the data before transferring it to the SFTP?

A developer wants to retrieve daily JSON data from a customer's API and write it to a data extension for consumption in Marketing Cloud at a later time. What set of Server-Side JavaScript activities should the developer use?

A developer wants to retrieve a row of data from a data extension using the SOAP API. Which API Object should be used for this call?

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 contain line 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?

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 developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform 'Post' on objects of type 'SentEvent'". What could be the issue?

A developer uses an API to send data to a Marketing Cloud data extension once every five minutes using the REST API. They notice data does not always write to the data extension, leading to data loss. Which three best practices are recommended to avoid this issue? Choose 3 answers

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 wants to build an email that dynamically populates the physical address of a company's locations using the variable ©address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance. Which AMPscript solution should be recommended?

A developer is configuring a File Drop Automation and wants to 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

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 answers

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 wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?

In what order is AMPscript evaluated before an email is sent?

A developer is using the legacy endpoint www.exacttargetapis.com and has been asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?

A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension. Which SELECT statement is optimal for returning all of the columns in the data extension?

Which of the following statements are correct concerning Populations in Contact Builder? Choose 2.

Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.

Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library

Northern Trail Outfitters (NTO) wants to prevent competitors from receiving a coupon email. They also want to capture email addresses of competitors who are included in the targeted audience. Which feature could NTO use to prevent the coupon from being sent and report the email addresses skipped?

Northern Trail Outfitters uses a number to uniquely identify contacts across different marketing channels. Which two actions should the developer take to ensure the contacts relate across channels in Marketing Cloud when working with the data model? Choose 2 answers

A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?

Customer data has been imported into a staging data extension and needs 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

The Contact Delete feature can be used within an Enterprise 2.0 account from which business unit?

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

Certification Aid wants to import data from a CSV file into a Data Extension. The CSV file contains all relevant data. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website. Which API should be used for this? Choose 2.

When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

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

NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but no emails have been sent during his initial testing. Which object and method should the developer use?

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 to personalize emails from an external data source?

What can be created in Attribute Groups within Contact Builder? Choose 2.

Where can the SSJS Core library be used? Choose 2.

Which encryption methods are supported in file imports? Choose 2.

Which SSJS library can be used in email messages? Choose 1.

Which SSJS library can be used in landing pages? Choose 1.

A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server. What steps should the developer take?

A developer is notified the View Email As Web Page (VAWP) link, when clicked, displays the message, The system is temporarily unavailable. We apologize for any inconvenience. Please try again later. What could be a possible cause for the error

Northern Trail Outfitters (NTO) stores most of their customer data in Marketing Cloud. They do not mind their data being viewed in clear text within SFMC to users who have access, but they want to ensure the underlying database files are encrypted at rest in case the physical media is stolen. Which encryption method should NTO use?

Northern Trail Outfitters uses a Send Log and sends more than one million emails per day. They want to execute daily reports on all subscriber activity without impacting send performance. Which set of best practices should be implemented''

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 used to send the email? Choose 2 answers

A developer wants to expand the functionality of existing code which was written in AMPscript, but prefers to use Server-Side JavaScript (SSJS) for updates. Which SSJS statement will retrieve the value of the AMPscript variable named subKey?

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 wants to create a Send Log Data Extension to increase efficiency with tracking email sends. Which two best practices should the developer remember when configuring the Send Log Data Extension? Choose 2 answers

A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

A developer started a Contact Delete process that is now complete. In which two places would the Contact Delete process remove data? Choose 2 answers

A marketer is sending an email with dynamic content contained in a series of conditionals. Which AMPscript function should be used to track the different versions of the content within the email?

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?

A customer wants to export send data to their SFTP. Which two automations would accomplish this? Choose 2

A developer created an email 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 initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted. Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

A developer is building an integration with the Marketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

A developer is implementing a custom profile center and using the LogUnsubEvent request. Which parameter is required for the event to be tied to the appropriate send?

A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center. Which method could be used to support the dynamic functionality?

A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call. How long are Marketing Cloud v1 access tokens valid?

A developer needs to determine why a Query Activity in an Automation has failed. Which three scenarios could have caused this? Choose 3 answers

A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month. What would produce the desired result?

A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will 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 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 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 each month in the following way: How should the developer use AMPscript to generate the total?

A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = 'Tacos'?

A developer wants to 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 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?

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 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 wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

A new record is appended to the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

A sendable data extension with a text field named 'Balance' contains the value S6.96 for a particular record. The following AMPscript statement is included in an email: IF (Balance > 6.00) THEN SET @Result = 'Balance is more than $6.00 ENDIF Why would this IF statement yield unintended results?

An email requires custom AMPscript to append the subscriber's zip code to a link in the email. 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 2

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.

Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.