Amazon Marketing Cloud Certification Exam Answers 2026

Exam Name: Amazon Marketing Cloud Certification

Exam URL: https://advertising.amazon.com/academy/student/path/36272/amazon-marketing-cloud-certification

1. AMC audiences is an API-only feature.
2. What are custom parameters?
3. Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
4. Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
5. Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
6. Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?
7. This 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.
8. What is SQL optimization in the context of AMC?
9. Which of these analyses can be accomplished with an overlap query?
10. Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions
11. New-to-brand metrics are only relevant for __________.
12. The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
13. What can Amazon shopping insights be used for?
14. What is one limitation of AMC SQL?
15. How 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
16. Which of the following Amazon services can be used to visualize aggregated AMC reports in a dashboard?
17. Overlap analyses enable you to generate insights by comparing different groups of __________ values in isolation and when overlapped.
18. The __________ field functions as a grouping indicator for the impression and any associated clicks, view events, or conversion events.
19. What types of Sponsored Products records will have spend metrics?
20. Why is it considered a good best practice to exclude NULL user_id values from reach and frequency queries?
21. Which environment allows you to inspect AMC tables at record level?
22. If you run multiple Amazon DSP and sponsored ads campaigns and reached similar audiences, which query can help you understand your customers’ conversion paths that have the highest conversion rate?
23. Clicks are considered conversion events and appear as individual records within the amazon_attributed_events_* tables.
24. Which of these is NOT a method of optimizing your AMC SQL?
25. Why would this query fail? SELECT campaign, SUM(impressions) AS impressions FROM dsp_impressions
26. user_id values cannot be viewed in the AMC user interface or downloaded from AMC.
27. Cost and fee fields are always reported in microcents.
28. There is no universal methodology or join key that can be used to combine tables in all query scenarios.
29. Which of the following statements about paid features (beta) is false?
30. Which of these queries will only include purchase records from the underlying table?
31. Super Power Batteries, a consumer packaged goods brand, is new to AMC and wants to learn more about what tables are available to query. Where in the AMC UI can they find this information?
32. The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations to understand unique reach volumes.
33. Performance reporting, such as Path to Conversion reporting, can be constrained to specific conversion events (e.g. purchases of a specific ASIN).
34. Why is the AMC sandbox a helpful environment for testing queries?
35. Which two functions can be used together to filter records based on presence of a string within a column’s values?
36. In AMC, a conversion is defined as an Amazon.com purchase event.
37. Paid features tables are only available in advertiser instances.
38. Which of these statements is false regarding AMC audiences?
39. What is the Amazon Ads attribution lookback window?
40. Which signals are not available within AMC?
41. Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
42. Which of the following statements is true about using queries within the instructional query library?
43. Which event table can be used when attributing conversions to your campaign using custom logic (e.g., 28 day lookback window)?
44. What is the max window over which AMC can accrue Amazon Ads events?
45. 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?
46. Which table should you use in a query meant to help you choose new Amazon audiences that may benefit your Amazon DSP campaign performance?
47. When determining total impressions served over a given date range, you can use dsp_impressions or dsp_views.
48. Which of the following business questions can be answered with an overlap analysis?
49. To minimize the number of values rendered NULL due to aggregation thresholds, you can:
50. What are the two ways to access AMC?
51. 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?
52. How would you adapt this query to obtain cost and impression metrics by supply_source? SELECT device_type, operating_system, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
53. Custom parameters help make queries more reusable because they __________.
54. Which of these statements is true regarding recurring query automation?
55. 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.
56. AMC supports most common SQL functions, but there are some unsupported SQL functions.
57. This table contains impression and click events from Sponsored Products, Sponsored Brands, Sponsored Display, and Sponsored Television campaigns
58. Where can you activate AMC audiences?
59. What is a primary usage of the UNION ALL function in AMC queries?
60. Conversions measured via Events Manager can be made available for querying in AMC.
61. Iris, a consumer electronics brand, recently started using AMC to perform analytics on events related to their Amazon Ads campaigns. Why should Iris consider using the instructional query library?
62. This UI component is considered the day-to-day operating room for the analytics practitioner and is used to author and execute SQL queries, as well as download the results.
63. What is an AMC sandbox?
64. A single on-Amazon transaction that includes multiple ASINs from your brand will be represented by a single conversion event within each of the amazon_attributed_events_* tables.
65. How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
66. 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 __________.
67. AMC can be used by brands that don’t sell their products directly in the Amazon store.
68. When analyzing the relationship between frequency and purchase rate, what actionable insight can you leverage for campaign optimization?
69. The _____________ field in the conversions_with_relevance table categorizes the relationship between the conversion event and the campaign it is relevant to.
70. Why are developer resources required for creating first-party tables in AMC?
71. Which of these use cases can be achieved when using Amazon Ads events in conjunction with first-party inputs?
72. You can use a _________ filter to limit your query results based on one or more conditions.
73. The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
74. AMC users have access to all AMC instances in an account by default.
75. What is an exploratory query?
76. 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?
77. Which of the following statements about AMC lookalike (LAL) audiences is false?
78. Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?
79. What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
80. AMC audience creation leverages a separate set of tables than those utilized for AMC reporting.
81. Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
82. Which of the following statements about the amazon_attributed_events_* tables is true.
83. Developers can access AMC APIs via the Amazon Ads API gateway.
84. Which statement about rule-based audiences is incorrect?
85. 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?
86. You can activate AMC rule-based audiences on _____________.
87. 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?
88. Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
89. 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?
90. Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?
91. How long can AMC accrue and retain Amazon Ads events?
92. 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?
93. Which field can be used to filter to traffic events from the relevant sponsored ads campaigns?
94. Iris, a consumer electronics brand, would like to modify a query to only include purchase records from the underlying table. Which of the following represents how the query should be written?
95. Which value is not available for Sponsored Products?