AC
Ad
Certified
Certifications
How It Works
Start Studying
Home
Amazon Marketing Cloud
Question 24 of 78
☁️
Amazon Marketing Cloud Certification
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 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
SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
Reveal Answer
Previous
24 / 78
Next