dumpspedia logo
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 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 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 inject a Contact into a journey using API. What method and route would be used to accomplish this?
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'
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
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
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 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?
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?
Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a dataextension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to becreated in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = 'NY' AND US = 1
What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?
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 extensionscontain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?
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 needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?
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
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.
Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.
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 writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which querywould provide that result?
A)
B)
C)
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 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 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 encrypt data stored in Marketing Cloud. It is fine if unencrypted fields arevisible 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.
A marketer is planning a weekly promotionalsend.
Which two types of data extensions could be sent to?
Choose 2 answers
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?
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 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 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 is leveraging the SOAP API to dynamically display Profile and PreferenceAttributes in a custom profile center. Which method could be used to support the dynamic functionality?
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 eachmonth in the following way:
How should the developer use AMPscript to generate the total?
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 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?
When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?
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 toretrieve the status of the API call?
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 build out aseries of CloudPages that will interact with several REST APIs.
Which Marketing Cloud supported scripting tool should be used?
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?
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 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?
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 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 is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validatethe data available can be accessed for child business unit queries?
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?
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
Which of the followingis a valid comment within an AMPscript code block? Choose 1.
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 use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?
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 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'?
TESTED 07 May 2024