Question: Why would this query fail? SELECT campaign, SUM(impressions) AS impressions FROM dsp_impressions
- 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 answer(s) to the question is highlighted in the BOLD text above. You can also find more questions and answers related to the exams on the “Amazon Marketing Cloud Certification” page.
