Which of these queries will only include purchase records from the underlying table?
SELECT campaign, COUNT (DISTINCT user_id) AS purchasers, SUM (purchases) AS purchases FROM amazon_attributed_events_by_traffic_time GROUP BY 1
SELECT campaign, COUNT (DISTINCT user_id) AS purchasers, SUM (purchases) AS purchases FROM conversions GROUP BY 1
SELECT campaign, COUNT (DISTINCT user_id) AS purchasers, SUM (purchases) AS purchases FROM amazon_attributed_events_by_traffic_time WHERE purchases = 1 GROUP BY 1
Correct Answer
SELECT campaign, COUNT (DISTINCT user_id) AS purchasers, SUM (purchases) AS purchases FROM amazon_attributed_events_by_traffic_time WHERE purchases = 1 GROUP BY 1
Topics in this question
About the Amazon Marketing Cloud Certification
The Amazon Marketing Cloud Certification covers Amazon's clean-room analytics environment: how AMC data is structured, writing SQL queries against it, and turning results such as overlap and path-to-conversion analysis into audience and media decisions.
Exam guide and all 95 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Iris, a consumer electronics brand, would like to modify a query to only include purchase records from the underlying table. Which of the following represents how the query should be written?
- 2Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
- 3Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
- 4Why is the AMC sandbox a helpful environment for testing queries?
- 5Why should you wait until 14 days after the end date of your query date range to run analyses that leverage the amazon_attributed_events_by_traffic_time table?
- 6Which of these is NOT a method of optimizing your AMC SQL?