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

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

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

Where can the SSJS Core library be used? 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.

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

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 is making an API REST call to trigger an email send. An accesstoken is used to authenticate the call.

How long are Marketing Cloud v1 access tokens valid?

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

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

Northern Trail Outfitters uses a number to uniquely identify contacts across different marketing channels.

Which two actions should the developertake to ensure the contacts relate across channels in Marketing Cloud when working with the data model?

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?

Northtrn Trail Outfitters mistakenly synced the User_Salesforce object which added to their billable contact count.

What should be recommended to remove these contacts'

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

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 create a Send LogData 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

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

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?

Which AMPscript function group could most negatively Impact send processing?

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?

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

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

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

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

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

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?

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

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 field value returned from a DE lookupcontains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

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

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 Trails Outfitters (NTO) developers want to use the Transactional Messaging API to send email receipts to customers.

What is the first step required to send using the API?

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?

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 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 is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms MarketingCloud Connect is installed properly. What should be confirmed next to continue troubleshooting the send's tracking information?

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?

Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named 'Inventory', which contains the details for each product. A Boolean field named 'InStock' indicates whether the item is available.

Which snippet of AMPscript would return all products which are currently available?

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

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

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?

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?

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

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?

How can SSJS variables be referenced for content personalization? Choose 1.

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 wants to extract tracking data from the Market Activity in the user interface.

Which option would be available to extract the data"?

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