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

QUESTION 34
A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is ‘true’ (Data Type = Formula(Boolean)) -ContactType equals ‘Phone’ (Data Type = Text). Which field could be used to select a subset of records in the synchronization configuration?

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

QUESTION 36
A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension.
Which best practice should the developer follow to control the unique and default content?

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

QUESTION 38
A developer wants to retrieve all records in the OrderDetails data extension which are associated with a particular customer.
Which two AMPscript functions would return a suitable rowset?
Choose 2 answers

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

QUESTION 40
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 schem a. 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?

QUESTION 41
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 would identify the most accurate status for subscribers of each business unit?

QUESTION 42
What is the purpose of the IF statement below?

QUESTION 43
Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

QUESTION 44
Northern Trails Outfitters (NTO) has a sendable data extension with 1,500,000 contact records they want to delete.
Which step is required before deleting the contacts?

QUESTION 45
A developer wants to populate a data extension with the date of the most recent click for each subscriber.
Which query would accomplish this?

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

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

QUESTION 48
Certification Aid created a journey and event definition in Marketing Cloud. Which of the following resources are relevant to inject Contacts into the journey using the REST API? Choose 2.

QUESTION 49
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’

QUESTION 50
A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the peformance? Choose 2

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

QUESTION 52
A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

QUESTION 53
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’?

QUESTION 54
A developer wants 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?

QUESTION 55
A developer identified a use case where a triggered send 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?

QUESTION 56
NTO wants to exclude sending an email at send time to those with a record on the ‘Exclude’ Data Extension.
The primary key on this data extension is Subscriber Key. How would a developer write the Exclusion Script?