Which of these is NOT a method of optimizing your AMC SQL?
Optimizing JOIN conditions
Filtering records early in the query
Optimizing the query’s order of operations
Adding redundant subqueries
Correct Answer
Adding redundant subqueries
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 94 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
- 2Which signals are not available within AMC?
- 3The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
- 4What is SQL optimization in the context of AMC?
- 5This panel provides access to additional subscription-based insights from Amazon or third parties; these insights can be joined with your Amazon Ads events that are already available in AMC.
- 6AMC supports most common SQL functions, but there are some unsupported SQL functions.