Marketing-Cloud-Developer Salesforce Certified Marketing Cloud Developer (SP23) Question and Answers

Which action could the RaiseError AMPscript function be configured to perform?

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

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 used LookupRows to retrieve data when building a dynamic email.

What should be the next step before using this rowset within a FOR loop?

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

A developer needs to display a value which has been calculated using an AMPscript block. This value is stored in the variable named 'Label'.

Which two ways should the developer display this value in the body of an email? Choose 2 answers

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 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 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 developer wants to build out a series of CloudPages that will interact with several REST APIs.

Which Marketing Cloud supported scripting tool should be used?

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 wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needs to contain JobID, EventDate, and the counts of how many emails were sent with each JobID.

Which data view is required to gather this information?

A developer needs to create a fully-branded CloudPage which 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 needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending.

Which two routes would allow this?

Choose 2 answers

What is the purpose of the IF statement below?

A developer is creating a CloudPage which accepts secure parameters via an email link and will submit those parameters to another CloudPage for data upsert. The page currently captures an Appointment ID parameter passed into it and sets the value to the variable caapptld. The developer does NOT want the Appointment ID to be visible to anyone using the form.

What is the best method to ensure the parameters are passed successfully to the data upsert page?

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

Northern Trail Outfitters' legal team is concerned about the daily import process that brings in subscribers to a Sendable Data Extension, even when records have already been targeted for deletion.

Which two true expected behaviors for these records occur in the event a send is initiated directly to this Sendable Data Extension?

Choose 2 answers

A developer is configuring a new Marketing Cloud account and has decided to use a unique 10-digit integer as each customer's Contact Key.

Which data type should be used when representing the value of Contact Key?

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

A marketer from Cloud Kicks wants to make sure no email from their welcome journey gets sent to their competitor at Rainbow Run.

Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey?

Choose 2 answers

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

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

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

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

A developer is troubleshooting the cause of incomplete results in the link tracking data for an email send.

How should the RedirectTo AMPscript function be described as it relates to link tracking'

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?

How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels.

What should be recommended5

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?

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

A sendable data extension with a text field named 'Balance' contains the value S6.96 fora 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?

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 uses an API to send data to a Marketing Cloud data extension once every fiveminutes 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

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

Why woulda developer use LookupRows Instead of the Lookup AMPscript function?

A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link's value as a variable. The variable will be used within the tag. What should thedeveloper do within the tag to ensure clicks are tracked for the variable? Choose 2

A marketer from Cloud Kicks wants to make sure no email from their welcome journey getssent to their competitor at Rainbow Run.

Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey?

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

Which two AMPscript HTTP functions allow an OAuth token to be passed in a header?

Choose 2 answers

A developer needs to import a file into a data extension which contains transactional data. The file includes a column labeled Purchase_Price with values varying from '$.05' to '$100'.

What Data Type should be used to prevent loss of data'

Which activity is required before a compressed file can be imported?

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. Whichfeature should handle this scenario?

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

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

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

Which AMPscript function returns the result of interpreted code within a code block and includes the result in the rendered content, where the code block is located?

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

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?

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

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?

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

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?

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

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

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

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'

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.

What is the purpose of the IF statement below?

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

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.

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

A developer needs to use the 'contacts/ route of the REST API to update records in a data extension.

What should the developer verify before making the API call?

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?

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 is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

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

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

Northern Trail Outfitters' legal team is concerned about the daily import process that brings in subscribers to a Sendable Data Extension, even when records have already been targeted for deletion.

Which two true expected behaviors for these recordsoccur in the event a send is initiated directly to this Sendable Data Extension?

Choose 2 answers

Northern Trails Outfitters is using REST API to send emails to customers after a purchase.

Which considerations should be taken regarding the token used in the API Call?

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