Amazon Marketing Cloud Certification
Leverage AMC SQL analytics for advanced audience insights and campaign measurement
78 practice questions
Page 2 of 4
If you want to understand more about which product or pixel your conversion events are associated with, which field in the amazon_attributed_events_* tables should you leverage?
4 answer options
The ___________ function can be used to append a string to ID fields (such as campaign_id), preventing issues reading the accurate ID values within Excel.
2 answer options
When analyzing the relationship between frequency and purchase rate, what actionable insight can you leverage for campaign optimization?
3 answer options
Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
4 answer options
Why should you wait until 14 days after the end date of your query date range to run analyses that leverage the amazon_attributed_events_by_traffic_time table?
3 answer options
What is the Amazon Ads attribution lookback window?
4 answer options
Which of these is NOT a method of optimizing your AMC SQL?
4 answer options
Why would this query fail? SELECT campaign, SUM(impressions) AS impressions FROM dsp_impressions
3 answer options
The _____________ field in the conversions_with_relevance table categorizes the relationship between the conversion event and the campaign it is relevant to.
4 answer options
What is the max window over which AMC can accrue Amazon Ads events?
4 answer options
What is an exploratory query?
4 answer options
Which of these statements is true regarding recurring query automation?
4 answer options
To minimize the number of values rendered NULL due to aggregation thresholds, you can:
4 answer options
How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
4 answer options
Which environment allows you to inspect AMC tables at record level?
4 answer options
Why is it considered a good best practice to exclude NULL user_id values from reach and frequency queries?
3 answer options
Which of these use cases can be achieved when using Amazon Ads events in conjunction with first-party inputs?
4 answer options
What is a primary usage of the UNION ALL function in AMC queries?
3 answer options
You can use a _________ filter to limit your query results based on one or more conditions.
2 answer options
What are the two ways to access AMC?
3 answer options