A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link's value as a variable. The variable will be used within the <a> tag. What should the developer do within the <a> tag to ensure clicks are tracked for the variable? Choose 2

Wrap the variable in a RedirectTo function

Ensure the Conversion attribute is 'true'

Wrap the variable in a v function

Include a variable for the Alias attribute

Certification Aid wants to include SSJS in an email message. Which code block can be used for this?Choose 2.

How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

<ctrl:field name="attributeName" />

<ctrl:attribute name="attributeName" />

<ctrl:var name="attributeName" />

How can SSJS variables be referenced for content personalization? Choose 1.

<ctrl:var name="variableName" />

<ctrl:eval>variableName</ctrl:eval>

<ctrl:var name="variableName" />

<ctrl:field name="variableName" />

<ctrl:eval name="variableName" />

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

Use the DataExtensionObject SOAP object

Use the /hub/vl/aataevents REST route

Use the DataExtension SOAP object

Upload a file to the Enhanced SFTP for import

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

The business unit where the contact was introduced

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

%%=Lookup ('Excluded' , SendBoo1'. Subscribekey'. _Subscribekey) =%%

%%=Lookup ('Excluded' , SendBoo1'. _Subscribekey'. _Subscribekey) =%%

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.JobID = S.JobID WHERE 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 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%'

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

Stop current delete process and delete smaller groups

Change the Suppression value to a larger value

Manually delete subscribers in All Contacts

Stop current delete process and delete smaller groups

Delete any unnecessary Sendable Data Extensions

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?

ResultItem Object and RequestID

Result Object and ConservationID

ResultItem Object and RequestID

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?

After deletion is fully complete

14 days after deletion process is complete

After deletion is fully complete

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/eventDefinitions

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 AMPscript API functions on a CloudPage

Use the ContinueRequest feature

Use a SimpleFilterPart to retrieve small sets of relevant data.

Use AMPscript API functions on a CloudPage

Use the ContinueRequest feature

Use the REST API instead of the SOAP API

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?

Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0

Lookup ('Exclude','EmailAddress','SubscriberKey',SubscriberKey)

Lookup ('Exclude','SubscriberKey', 'EmailAddress', emailddr_)

Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0

Rowcount (LookupRows('Exclude','SubscriberKey,_SubscriberKey) >1

NTO wants to exclude sends to specific subscribers based on a business rule, which is defined in an Exclusion Script. Which three types of sends would support this functionality? Choose 3

Journey Builder Send Email Activity

Automation Studio Send Email Activity

Journey Builder Send Email Activity

Send Marketing Cloud Email in Sales or Service Cloud

Journey Builder Send SMS Activity

Automation Studio Send Email Activity

A particular data extension need to be configured to store six months of data.How should data retention be added to the data extension in Email Studio?

Create a new data extension that includes data retention settings

Run a query to overwrite the rows with six months of data

Import a file to overwrite the rows with six months of data

Create a new data extension that includes data retention settings

Update the data extension configuration to include data retention settings.

A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installed properly. What should be confirmed next to continue troubleshooting the send's tracking information?

The audience was a Salesforce Data Extension containing the appropriate SFID

The email was sent to the All Subscribers list

The tracking destination folder was set to My Tracking

The audience was built using a Triggered Send Data Extension template

A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

Create using the SendLog Data Extension Template

Create and ensure it has the name "Send Log"

Salesforce Support should create the data extension

Create from a copy of an existing Send Log in another business unit

Create using the SendLog Data Extension Template

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

Use Primary key(s) on fields used in joins

Use intermediate tables to stage data

Only update records that have changed since last execution

Use intrisic functions in the WHERE clause

Use SELECT * to include all fields

Use Primary key(s) on fields used in joins

Use intermediate tables to stage data

Only update records that have changed since last execution

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?

Use the RowCount function and an IF statement

Use the Lookup, Row and Field functions

Use the LookupOrderRows and Row functions

Use the DataExtensionRowCount function

A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2

Set credentials as environment variables in the application platform

Store credentials in a key management system (KMS)

Set credentials as environment variables in the application platform

Pass credentials in URL parameters over HTTPS

Set credentials as variables in application source code

Store credentials in a key management system (KMS)

A developer receives a 401 Unathorized HTTP status message from a REST API request. What is thereason for this error?

The access token was not found in the request, or it is invalid or expired

The account lacks the privileges necessary to perform the request

The access token was not found in the request, or it is invalid or expired

OAuth is not supported for the requested resource

API requests are temporarily blocked due to too many concurrent requests.

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?

Verify the Asset Type Id matches the Asset Type Name

Validate Client Id and Client Secret are correct

Verify the Asset Type Id matches the Asset Type Name

Confirm the REST Base URI uses the correct subdomain

Confirm the Component's Channel options are available

A developer wants to transform the date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

%%=DateAdd(Date_Enrolled,-1 'H')=%%

%%=DataAdd(Date_Enrolled,-1)=%%

%%=DateAdd(Date_Enrolled,-1 'H')=%%

%%=DateDiff(Date_Enrolled, 1, 'H')=%%

%%=FormatDate(Date_Enrolled,-1,'HH','en-us')=%%

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

The email is not sent to the particular subscriber

An error message is sent to the From Address used in the email

NTO uses data extensions to manage the subscriber information used for their email sends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated using an InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?

The InsertDE function comes after the system added the row as part of the email send

The InsertDE function will always insert two rows into a data extension as part of the call

The InsertDE function cannot be used with name and value pairs

The InsertDE function comes after the system added the row as part of the email send

The InsertDE function cannot be used at send time

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?

Non-sendable data extension with SubscriberKey field

Sendable data extension with SubscriberKey and EmailAddress fields

Non-sendable data extension with SubscriberKey field

Contact Delete process does not delete rows from data extensions

Sendable data extension with SubsciberKey field

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?

Create Data Extracts of All Subscribers within each Child business unit

Create Data Extract of all Subscribers within the Parent Business unit

Create Data Extracts of All Subscribers within each Child business unit

Query unsubscriber from _Subscribers within the Parent business unit

Query status from _ListSusbscribers within the Parent business unit

A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator.What is the recommended AMPscript logic to determine the background color of each table row within the loop?

%%[IF DIVIDE(@numerator,2) =1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

%%[IF SUBSTRING(DIVIDE(@numerator,2),1) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

%%[IF @numerator/2 = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

%%[IF MOD(@numerator,2) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

Salesforce Certified Marketing Cloud Developer Practice Test 1

Clock Kicks would like to encrypt and store form data submitted from a CloudPage in a data extension using AMPscript. Which three encryption options could be used when creating a new key in Key Management? Choose 3

A.

SAML

B.

Asymmetric

C.

RSA

D.

Salt

E.

Symmetric

Salesforce Certified Marketing Cloud Developer Practice Test 1

Question

Salesforce Certified Marketing Cloud Developer Practice Tests

Practice Tests