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 94 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.
- 3Which function can be used to append a string to ID fields (i.e., campaign_id) to prevent issues when reading the values in Excel?
- 4Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
- 5You are writing a query and would like to know the total impressions that have been delivered per campaign, per supply_source, and per device_type. Which of the following represents how you should write the query?
- 6The ___________ function can be used to append a string to ID fields (such as campaign_id), preventing issues reading the accurate ID values within Excel.