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

Comment: *

Name: *

Email: *

Verification: *

Certification Aid wants to import data from a CSV file into a Data Extension. The CSV filecontains all relevant data. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

• A.Add only
• B.Overwrite
• C.Add andupdate
• D.Update only

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a valid comment within an AMPscript code block? Choose 1.

• A.- comment -->
• B.// comment
• C./* comment */
• D.--comment

Comment: *

Name: *

Email: *

Verification: *

A developer uses the messageDefinitionSends REST API endpoint to send a triggered send email. This method returns a 202 (success) response code. How could the developer validate if the email was successfully sent?

• A.Use the validateEmail REST resource with POST method to obtain the email delivery details from the request.
• B.Confirm the record was successfully inserted into the associated Triggered Send Data Extension.
• C.The 202 response code indicates the message was sent succesfully; no further action is required.
• D.Use the messageDefinitionSend/key:(key)/deliveryRecords REST endpoint with GET method

Comment: *

Name: *

Email: *

Verification: *

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

• A.Use intrisic functions in the WHERE clause
• B.Use SELECT * to include all fields
• C.Use Primary key(s) on fields used in joins
• D.Use intermediate tables to stage data
• E.Only update records that have changed since last execution

Comment: *

Name: *

Email: *

Verification: *