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?

• A.SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
• B.SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
• C.SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
• D.SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'

Comment: *

Name: *

Email: *

Verification: *

A developer has a text field in a data extension they want to format using the FormatCurrency AMPscript function. Which two values would return $6.96? Choose 2

• A.6.96
• B.6.96
• C.6,961
• D.$6.96

Comment: *

Name: *

Email: *

Verification: *

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?

• A.%%[IF DIVIDE(@numerator,2) =1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%
• B.%%[IF @numerator/2 = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%
• C.%%[IF MOD(@numerator,2) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%
• D.%%[IF SUBSTRING(DIVIDE(@numerator,2),1) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

Comment: *

Name: *

Email: *

Verification: *

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

• A.The query is returning more than one million rows.
• B.The query is inserting a value that is larger than the size of a field.
• C.The query is not returning a value for a non-nullable field.
• D.The query takes more than 60 minutes to run.
• E.The query results in duplicate rows not allowed by the primary key.

Comment: *

Name: *

Email: *

Verification: *

A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose 2

• A.Add a unique identifier in the HTML tags within the generated content
• B.Request the Impression Tracking feature be enabled on the account
• C.Configure dynamic content block in Content Builder
• D.Include the functions BeginImpressionRegion and EndImpressionRegion

Comment: *

Name: *

Email: *

Verification: *