Question: Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM sponsored_ads_traffic GROUP BY 1,2
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM dsp_impressions WHERE creative IS LIVE GROUP BY 1,2
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM amazon_attributed_events_by_traffic_time 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.
