Amazon Marketing Cloud Certification 

Why would this query fail? SELECT campaign, SUM(impressions) AS impressions FROM dsp_impressions

Editorial Staff
  • SELECT statements can not be used to choose metrics from a table.
  • There is no WHERE clause to filter the query results based on one or more conditions.
  • There is no GROUP BY statement; this query cannot be run without aggregation on the campaign dimension.

The correct answer is:

  • There is no GROUP BY statement; this query cannot be run without aggregation on the campaign dimension.

🎓 Get all the latest and 100% correct Amazon Marketing Cloud Certification Exam Answers