What is the purpose of the IF statement below?

• A.To handle when there are multiple records in the data extension for the subscriber
• B.To handle when the subscriber is in a held status
• C.To handle when no row is returned by the LookupRows function
• D.To handle when images are broken

Comment: *

Name: *

Email: *

Verification: *

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.SET @total = Add(@var1, @var2, @var3)
• B.SET @total = @var1 + @var2 + @var3
• C.SET @total = Add(@var1, Add(@var2, @var3))
• D.SET @total = Sum(@var1, @var2, @var3)

Comment: *

Name: *

Email: *

Verification: *

A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

• A.Marketing Cloud does not allow use of GETDATE function. They should define a specific date.
• B.Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.
• C.Marketing Cloud does not allow DateAdd functions in Query Activities. They should define a specific date.
• D.Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.

Comment: *

Name: *

Email: *

Verification: *

A developer wants to set a variable to use a field from a Sendable Data Extension.
Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension used to send the email? Choose 2 answers

• A.SET @firstName = ''First Name'']
• B.SET @firstName = attributeValue (''First Name'')
• C.SET @firstName = %%First Name%%
• D.SET @firstName = [First Name]

Comment: *

Name: *

Email: *

Verification: *

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

• A.Use a SimpleFilterPart to retrieve small sets of relevant data.
• B.Use the ContinueRequest feature
• C.Use the REST API instead of the SOAP API
• D.Use AMPscript API functions on a CloudPage

Comment: *

Name: *

Email: *

Verification: *