Question: You are writing a query and would like to know the total impressions that have been delivered per campaign, per supply_source, and per device_type. Which of the following represents how you should write the query?
- SELECT total_impressions SUM(impressions) AS device_type FROM campaign, supply_source GROUP BY 1,2,3
- SELECT campaign, supply_source, device_type, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3
- SELECT campaign, supply_source, SUM(impressions) AS impressions FROM device_type GROUP BY 1,2
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.
