ExamGecko
Login
Ask Question

Salesforce Certified Marketing Cloud Developer Practice Test - Questions Answers, Page 2

List of questions

Question 11

Report
Export
Collapse

From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Any business unit
Any business unit
The Parent account
The Parent account
Only in Agency accounts
Only in Agency accounts
The business unit where the contact was introduced
The business unit where the contact was introduced
Suggested answer: B
asked 23/09/2024
Florence Li
39 questions

Question 12

Report
Export
Collapse

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

%%SendBoo1%%
%%SendBoo1%%
%%SendBoo1 < 1
%%SendBoo1 < 1
%%=Lookup ('Excluded' , SendBoo1'. Subscribekey'. _Subscribekey) =%%
%%=Lookup ('Excluded' , SendBoo1'. Subscribekey'. _Subscribekey) =%%
%%=Lookup ('Excluded' , SendBoo1'. _Subscribekey'. _Subscribekey) =%%
%%=Lookup ('Excluded' , SendBoo1'. _Subscribekey'. _Subscribekey) =%%
Suggested answer: B, C
asked 23/09/2024
Abraham Ermann
42 questions

Question 13

Report
Export
Collapse

NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'
SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'
Suggested answer: C
asked 23/09/2024
Jebaz Norton
44 questions

Question 14

Report
Export
Collapse

A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?

Change the Suppression value to a larger value
Change the Suppression value to a larger value
Manually delete subscribers in All Contacts
Manually delete subscribers in All Contacts
Stop current delete process and delete smaller groups
Stop current delete process and delete smaller groups
Delete any unnecessary Sendable Data Extensions
Delete any unnecessary Sendable Data Extensions
Suggested answer: C
asked 23/09/2024
Tim baxter
41 questions

Question 15

Report
Export
Collapse

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 to retrieve the status of the API call?

Result Object and EmailAddress
Result Object and EmailAddress
Result Object and ConservationID
Result Object and ConservationID
ResultItem Object and OrderID
ResultItem Object and OrderID
ResultItem Object and RequestID
ResultItem Object and RequestID
Suggested answer: D
asked 23/09/2024
Benice dobbins
44 questions

Question 16

Report
Export
Collapse

A field value returned from a DE lookup contains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

Substring
Substring
BuildRowSetFromString
BuildRowSetFromString
IndexOf
IndexOf
Length
Length
Suggested answer: B
asked 23/09/2024
Kevin Suckiel
48 questions

Question 17

Report
Export
Collapse

A developer want to email a subscriber who is currently being processed for a Contact Deletion request. When could the Contact be reintroduced after a Contact Delete operation has started?

Never
Never
14 days after deletion process is complete
14 days after deletion process is complete
After deletion is fully complete
After deletion is fully complete
Anytime
Anytime
Suggested answer: C
asked 23/09/2024
Hany Mohammed
35 questions

Question 18

Report
Export
Collapse

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?

/interaction/v1/interactions
/interaction/v1/interactions
/interaction/v1/events
/interaction/v1/events
/interaction/v1/eventDefinitions
/interaction/v1/eventDefinitions
/contacts/v1/contactEvents
/contacts/v1/contactEvents
Suggested answer: B
asked 23/09/2024
William Sorensen
39 questions

Question 19

Report
Export
Collapse

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

Use a SimpleFilterPart to retrieve small sets of relevant data.
Use a SimpleFilterPart to retrieve small sets of relevant data.
Use AMPscript API functions on a CloudPage
Use AMPscript API functions on a CloudPage
Use the ContinueRequest feature
Use the ContinueRequest feature
Use the REST API instead of the SOAP API
Use the REST API instead of the SOAP API
Suggested answer: B, C
asked 23/09/2024
TienYai Ho
37 questions

Question 20

Report
Export
Collapse

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?

Lookup ('Exclude','EmailAddress','SubscriberKey',SubscriberKey)
Lookup ('Exclude','EmailAddress','SubscriberKey',SubscriberKey)
Lookup ('Exclude','SubscriberKey', 'EmailAddress', emailddr_)
Lookup ('Exclude','SubscriberKey', 'EmailAddress', emailddr_)
Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0
Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0
Rowcount (LookupRows('Exclude','SubscriberKey,_SubscriberKey) >1
Rowcount (LookupRows('Exclude','SubscriberKey,_SubscriberKey) >1
Suggested answer: C
asked 23/09/2024
Mark Green
45 questions
Total 197 questions
Go to page: of 20
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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 each month in the following way: How should the developer use AMPscript to generate the total?
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 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 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 contain line 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 wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible 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 configuring a new Marketing Cloud account and has decided to use a unique 10-digit integer as each customer's Contact Key. Which data type should be used when representing the value of Contact Key?
A developer 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 customer wants a list of subscribers who were sent an email within the past 12 months. How should this request be completed?
Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5
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