MARKETING-CLOUD-DEVELOPER practice question 2 of 10
NTO puts the word TEST at the beginning of the name for each test email. Which query would return the subs who were sent those emails?
Full set: 196 questionsThe correct query to retrieve subscribers who were sent emails with names starting with 'TEST' correctly joins the Job and Sent data extensions on JobID and uses a WHERE clause to filter EmailName using the LIKE operator.
A. The join condition is incorrect; it uses LIKE improperly in the JOIN rather than in a WHERE clause.
B. This option lacks the necessary alias and uses an incorrect join condition syntax.
D. The join condition has a syntax error with improper use of equals sign (=).
1. Salesforce Marketing Cloud Documentation, Query Activities: Link
2. Marketing Cloud Developer Guide, SQL Reference: Link
Keep practicing
Take the free MARKETING-CLOUD-DEVELOPER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MARKETING-CLOUD-DEVELOPER practice questions
- Question 1A marketer is troubleshooting why an email send's tracking information is not available i…
- Question 3Certification Aid wants to include SSJS in an email message. Which code block can be used…
- Question 4A developer receives a 401 Unathorized HTTP status message from a REST API request. What …
- Question 5A developer has a text field in a data extension they want to format using the FormatCurr…
- Question 6A developer needs to create a fully-branded CloudPage which includes images hosted in Con…
- Question 7A developer needs to push real-time updates of the company's product catalog to a data ex…
