Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
UNION or JOIN functions
WHERE filters with literal (static) values
first-party insights
aggregation functions such as SUM or AVG
Correct Answer
WHERE filters with literal (static) values
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
- 1Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?
- 2There is no universal methodology or join key that can be used to combine tables in all query scenarios.
- 3SELECT supply_source, SUM (total_cost)/100000000 AS total_cost_dollars, ((SUM (total_cost)/100000000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_inventory GROUP BY 1 SELECT supply_source, SUM (total_cost)/100000 AS total_cost_dollars, ((SUM (total_cost)/100000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2 SELECT supply_source, SUM (total_cost)/100000 AS total_cost_dollars, ((SUM (total_cost)/100000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1 The correct answer is: SELECT supply_source, SUM (total_cost)/100000 AS total_cost_dollars, ((SUM (total_cost)/100000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1 Explanation: That’s the correct query. Here is an explanation of the adaptation and why it works: The adapted query focuses on aggregating the desired metrics at the supply_source level, utilizing fields available in the dsp_impressions table: SQL SELECT supply_source, SUM(total_cost) / 100000 AS total_cost_dollars, ((SUM(total_cost) / 100000) / SUM(impressions)) * 1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1 🔍 Explanation of Changes The core principle of the adaptation is to replace the previous grouping dimensions with the single dimension required: supply_source .Multiple correct
- 4SELECT 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
- 5Which function can be used to append a string to ID fields (i.e., campaign_id) to prevent issues when reading the values in Excel?
- 6Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.