Marketing-Cloud-Developer Salesforce Certified Marketing Cloud Developer (SP23) Questions and 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 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 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 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 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 new record is appendedto 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 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 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 puts the word TEST at the beginning of the namefor each test email. Which query would return the subs who were sent those emails?

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?

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

Which SSJS library can be used in email messages? 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?

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?

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

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 (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 is building an integration with theMarketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

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?

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

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?

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

Clock Kicks would like to encrypt and storeform 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

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?

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 customer wants to export send data to their SFTP. Which two automationswould accomplish this? Choose 2

Certification Aid wants to import data from a CSV file into a Data Extension. The CSV filecontains 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.

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

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

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

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?

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

What should be recommended to remove these contacts'

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?

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

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?

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

Northern Trail Outfitters (NTO) wants to prevent competitors fromreceiving 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?

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

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

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.

A developer wants to create a JavaScript Web Token using a key from Key Management.

What function should the developer use?

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

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?

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

A developer wants to review the available properties for using the DataExtensionField SOAP API object.

Where could the developer find this 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 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 doctor's office creates Populations for staff, patients and vendors. What is the maximum number of Populations that should be created to ensure performance?

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

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