You can use a _________ filter to limit your query results based on one or more conditions.
FROM
WHERE
SELECT
Correct Answer
WHERE
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 94 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1How would you adapt this query to limit results to Sponsored Products keyword targeting only? SELECT ad_product_type, targeting, customer_search_term, match_type, SUM (spend)/100000000 AS total_cost_dollars, ((SUM (spend)/100000000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions, SUM (clicks) AS clicks, (SUM (clicks)/SUM (impressions)) AS ctr FROM sponsored_ads_traffic WHERE match_type IN (‘PHRASE’, ‘BROAD’, ‘EXACT’) GROUP BY 1,2,3,4
- 2Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
- 3Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions
- 4Which two functions can be used together to filter records based on presence of a string within a column’s values?
- 5Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
- 6You can activate AMC rule-based audiences on _____________.