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

The deletion process supersedes other automated account activities.

The suppression status does not show for individual contacts until the entire batch processes.

Up to one million records can be deleted in each batch.

To more quickly remove contact information, use the suppression period length of 14.

The deletion process supersedes other automated account activities.

The suppression status does not show for individual contacts until the entire batch processes.

A developer is building an integration with the Marketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

Select the minimum required scope for the integration

Select all available options to enable package reuse for the future integrations

Select the 'Require Secret for Web Flor' option

Select the 'Admin-approved users are pre-authorized' option under Permitted Users.

A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call.How long are Marketing Cloud v1 access tokens valid?

Access tokens expire after one hour.

Access tokens expire after 24 hours.

REST calls do not require an access token.

Each API call requires a new access token.

Access tokens expire after one hour.

A developer needs to determine why a Query Activity in an Automation has failed.Which three scenarios could have caused this? Choose 3 answers

The query takes more than 60 minutes to run.

The query is not returning a value for a non-nullable field.

The query is inserting a value that is larger than the size of a field.

The query takes more than 60 minutes to run.

The query is returning more than one million rows.

The query results in duplicate rows not allowed by the primary key.

The query is not returning a value for a non-nullable field.

The query is inserting a value that is larger than the size of a field.

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?

Find the first day of next month and subtract one day

Use the date format string for last day of month within FormatDate

Add one month using DateAdd to now

Add 30 days using DateAdd to now

A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will 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?

SOAP API using Create Method and the DataExtension Object

REST API using POST on the /interaction/v1/EventDefinitions endpoint with Schema populated

REST API using POST on the /data/v1/customobjectdata/ endpoint

Creating the data extension using API is not possible

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?

GET using the REST API/asset/v1/content/assets and parse the FileProperties parameter

Use the SOAP API to create a Porfoglio object and idenfity the Source property

POST to the REST API/asset/v1/content/categories and parse the Description parameter

POST to the REST API/asset/v1/content/assets and parse the FileProperties parameter

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?

SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))

SET @total - (@jan - 3fet - @mar @apr>

SET @total = AZD((@jan @feb) @mar) @apr)

SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))

SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))

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

REST API, /address/v1/validateEmail route

SOAP API, Perform method with ValidationAction object

SOAP API, Describe method with EmailAddress object

REST API, /messaging/v1/domainverification route

A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?

'" ENDIF]%% %%=v(message)=%%%%=IF(@level IS 'premier', Upgrade to premier now! You are a premier member%%=IIF(@level = 'premier', 'You are a premier member!', Upgrade to premier now!

%%[IF @level == 'premier' THEN SET @message = You are premier member

" ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now

'" ENDIF]%% %%=v(message)=%%%%=IF(@level IS 'premier', Upgrade to premier now! You are a premier member%%=IIF(@level = 'premier', 'You are a premier member!', Upgrade to premier now!

%%=IIF @level == premier, You are a premier member" Upgrade to premier now!

%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%

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

SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC

SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

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?

requestToken and messageContact REST API objects

Outbound SMS template and Automation Send Method

InsertData AMPscript function to add the subscriber to a MobileConnect list

CreateSMSConservation AMPscript function

requestToken and messageContact REST API objects

A new record is appended to the Orders data extension each time a customer makes a purchase.Which SQL statement would select a unique list of subscribers who have made multiple purchases?

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey

SELECT TOP 1 SubscriberKey FROM Orders

SELECT DISTINCT SubscriberKey FROM Orders

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1

A sendable data extension with a text field named 'Balance' contains the value S6.96 for a particular record. The following AMPscript statement is included in an email:IF (Balance > 6.00) THENSET @Result = 'Balance is more than $6.00ENDIFWhy would this IF statement yield unintended results?

Double quotes should be used instead of single quotes.

The operands are not the same data type.

The comparison should use the < operator.

Balance is a protected keyword.

Double quotes should be used instead of single quotes.

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.

SET @total = Add(@var1, Add(@var2, @var3))

SET @total = Sum(@var1, @var2, @var3)

SET @total = Add(@var1, Add(@var2, @var3))

SET @total = Add(@var1, @var2, @var3)

SET @total = @var1 + @var2 + @var3

Northtrn Trail Outfitters mistakenly synced the User_Salesforce object which added to their billable contact count.What should be recommended to remove these contacts'

Put the synced records into a sendable data extension and use Contact Delete.

Update the sync to remove these contacts from the All Contacts table.

Use the REST API to delete the contacts from the All Subscribers table.

Put the synced records into a sendable data extension and use Contact Delete.

Use the SOAP API to delete the contacts from the All Contacts table.

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?

<input id="apptld" type="textarea" value»"%%«v(@>apptld)»%%" readonly>

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?

LookupRows ('Ent. Inventory*, 'InStock', 'true', )

LookupRows ('Ent. Inventory*, 'true', 'InStock')

LookupRows ('Ent. Inventory*, itemName, 'InStock', 'true')

LookupRows ('Ent. Inventory*, 'InStock', 'true', )

LookupRows ('Inventory*, 'InStock' 'true',)

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a data extension 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 be created 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."?

MemberData should be prefixed with ENT

Incorrect syntax; Query Activities are written in SOQL

MemberData should be prefixed with ENT

Query should check for a US value of True'

Query Activities cannot use the " wildcard

Why would a developer use LookupRows Instead of the Lookup AMPscript function?

To return a complete rowset from the data extension

To stay at the limit of two Lookup calls in one email

To see how many rows are In a data extension

To access a data extension, as Lookup only targets lists

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?

Each contact should already exist in All Subscribers.

Journey Builder should be configured to use the data extension.

Contact Key should be equal to Subscriber Key in the underlying data extensions to ensure proper joining.

The data extension should be linked in an Attribute Group in Contact Builder.

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?

Confirm every version has default content

Send a test of every possible version using Test Send

Review every possible version using Subscriber Preview

Create separate emails for each version

Confirm every version has default content

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?

Make a token API call and re-use the token until the token expires.

Make a token API call and re-use the token until the next API call fails.

Make a token API call before each triggered send API call.

Make a token API call and re-use the token for that subscriber.

Make a token API call and re-use the token until the token expires.

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?

Request a token using the vl/requestToken endpoint

POST to /messaging/vl/email/messages/ with clientjd

Request a token using the vl/requestToken endpoint

Request a token using the v2/authorize endpoint

POST to /messaging/vl with clientjd and client_secret

A marketer from Cloud Kicks wants to make sure no email from their welcome journey gets sent to their competitor at Rainbow Run.Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey?Choose 2 answers

Create a Suppression List with all possible email addresses from Rainbow Run

Create an Exclusion Script with the Rainbow Run domain for use In the activity

Create a Filter Activity In the journey that removes the Rainbow Run domain

Create a Suppression List with all possible email addresses from Rainbow Run

Create a data extension with the Rainbow Run domain for use with a Domain Exclusion

Create an Exclusion Script with the Rainbow Run domain for use In the activity

Salesforce Certified Marketing Cloud Developer Practice Test 4

A developer created an email 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?

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Marketing Cloud Developer Practice Test 4

Question

Salesforce Certified Marketing Cloud Developer Practice Tests

Practice Tests