What is one limitation of AMC SQL?
It cannot filter query results based on date range
Some common SQL functions are not currently supported
It cannot join tables from different databases
Correct Answer
Some common SQL functions are not currently supported
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
- 1SELECT 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 correct answer is: SELECT campaign, supply_source, device_type, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3 Explanation: The correct query to get the total impressions delivered per campaign, per supply source, and per device type is: SQL SELECT campaign, supply_source, device_type, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1, 2, 3 ✅ Explanation of the Query This is a standard and efficient SQL query structure for use in Amazon Marketing Cloud (AMC) .Multiple correct
- 2Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
- 3Which of these is NOT a method of optimizing your AMC SQL?
- 4The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
- 5What is SQL optimization in the context of AMC?
- 6AMC supports most common SQL functions, but there are some unsupported SQL functions.