Nutrition Co., a health snack company, would like to know the total impressions that have been delivered per campaign, per supply_source, per device_type. Which of the following represents how to write this query?

Here is the answer of the question: Nutrition Co., a health snack company, would like to know the total impressions that have been delivered per campaign, per supply_source, per device_type. Which of the following represents how to write this query?

• SELECT total_impressions SUM(impressions) AS device_type FROM campaign, supply_source GROUP BY 1,2,3
• SELECT campaign, supply_source, SUM(impressions) AS impressions FROM device_type GROUP BY 1,2
• SELECT campaign, supply_source, device_type, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3

The above question is related to “Amazon Marketing Cloud Certification Exam“. You can find all the updated questions and answers related to to “Amazon Marketing Cloud Certification Exam” on the “Amazon Marketing Cloud Certification Exam Answers” page. If you find the update in question or answers, do comment on this page and let us know. We will update the answers as soon as possible.