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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
• B.SELECT DISTINCT SubscriberKey FROM Orders
• C.SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
• D.SELECT TOP 1 SubscriberKey FROM Orders

Comment: *

Name: *

Email: *

Verification: *

Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.

• A.Update
• B.Configure
• C.Describe
• D.Extract

Comment: *

Name: *

Email: *

Verification: *

A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete. How could the process be expedited?

• A.Manually delete subscribers in All Contacts
• B.Stop the current delete process and delete smaller groups
• C.Delete any unnecessary Sendable Data Extensions
• D.Change the Suppression value to a larger value

Comment: *

Name: *

Email: *

Verification: *

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

• A.<script language=javascript></script>
• B.<script runat=server></script>
• C.<script language=ssjs></script>
• D.<script runat=serverlanguage=javascript></script>

Comment: *

Name: *

Email: *

Verification: *