Amazon Marketing Cloud Certification
Leverage AMC SQL analytics for advanced audience insights and campaign measurement
78 practice questions
Page 1 of 4
Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
4 answer options
How would you adapt this query to obtain cost and impression metrics by supply_source?
3 answer options
Nutrition Co., a health snack company, would like to know the total impressions that have been delivered per campaign, per supply_source, per device_type. Which of the following represents how to write this query?
3 answer optionsMultiple correct
Since the amazon_attributed_events_* tables contain ad-attributed conversions across all of your Amazon Ads media, you can aggregate them by sponsored ads vs. Amazon DSP using the __________.
4 answer options
Why is the AMC sandbox a helpful environment for testing queries?
4 answer options
How long can AMC accrue and retain Amazon Ads events?
3 answer options
Which function can be used to append a string to ID fields (i.e., campaign_id) to prevent issues when reading the values in Excel?
2 answer options
Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?
3 answer options
Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?
4 answer options
Considering the amazon_attributed_events_ tables contain ad-attributed conversions across all of your Amazon Ads media, which of the following fields would allow you to aggregate them by sponsored ads vs. Amazon DSP?
3 answer options
Which field in the amazon_attributed_events_ tables should you leverage if you want to understand more about which product or pixel your conversion events are associated with?
3 answer options
Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
3 answer options
You can activate AMC rule-based audiences on _____________.
3 answer options
You 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?
3 answer options
Which statement about rule-based audiences is incorrect?
3 answer options
Which of the following statements about the amazon_attributed_events_* tables is true.
4 answer options
Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
4 answer options
Which of the following statements about AMC lookalike (LAL) audiences is false?
4 answer options
Which of the following statements about paid features (beta) is false?
3 answer options
Custom parameters help make queries more reusable because they __________.
3 answer options