A developer wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needsto 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 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?
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
In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3
What is the operational order of the Contact Delete process for Marketing Cloud?
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
When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?
A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server. What steps shouldthe developer take?
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 started a Contact Delete process that is now complete.
In which twoplaces would the Contact Delete process remove data? Choose 2 answers
A developer identified a use case where a triggeredsend 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 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?
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.
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 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?
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.
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
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?
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 wants to review the available properties for using the DataExtensionField SOAP API object.
Where could the developer find this information
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?
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 add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?
A developer identified duplicate contacts and wants to delete roughly 10 million subscribers usingContact Delete. How could the process be expedited?
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?
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 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?
How often should a developer request a new token when making multiple API calls in v1?
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 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?
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?
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?
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?
Adeveloper is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each.
Which application utilizes the REST API?
A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?
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
A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?
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 needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending.
Which tworoutes would allow this?
Choose 2 answers
Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.
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
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 noemails have been sent during his initial testing. Which object and method should the developer use?
NTO wants toexclude 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
An UpdateDE AMPscript function is used to update a column value in a data extension row when an email is sent. The emailis being sent to 250,000 subscribers, but the user decides to cancel the send during the sending process and only 400 emails are sent.
How many subscriber rows would be affected by the UpdateDE function?
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?
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.
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 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?
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'
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
DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.
TESTED 25 Apr 2024
