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?
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 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?
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 wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?
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 customer wants to export send data to their SFTP. Which two automationswould accomplish this? 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'
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?
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
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 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?
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 developer identified duplicate contactsand initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?
A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?
Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.
Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose 2.
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 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?
Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.
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 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?
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?
Which of the followingis a valid comment within an AMPscript code block? Choose 1.
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 used LookupRowsto retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?
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?
In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3
A marketer is planning a weekly promotionalsend.
Which two types of data extensions could be sent to?
Choose 2 answers
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 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 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 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 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 to programmatically inject Contacts into a journey via REST API. What is the recommended route using POST data extension fields and values?
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 is building an integration with theMarketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?
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 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 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 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
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 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?
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 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
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?
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
Northern Trail Outfitters has created subscriber attributes including AGE underProfile Manager within their Enterprise 2.0 account.
How would a developer retrieve subscribers over 30 years of age?
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?