Amazon Marketing Cloud Certification

Question: The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations […]

Question: What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions? (SUM(total_cost)/100000)/(SUM(impressions))*1000 AS avg_cpm

Question: You can use a _________ filter to limit your query results based on one or more conditions. FROM WHERE

Question: Which of the following statements about paid features (beta) is false? Paid features are offered as a monthly subscription

Question: Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table? The time window used for your query will apply

Question: 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

Question: Since the amazon_attributed_events_* tables contain ad-attributed conversions across all of your Amazon Ads media, you can aggregate them by

Question: user_id values cannot be viewed in the AMC user interface or downloaded from AMC. True False The answer(s) to

Question: Overlap analyses enable you to generate insights by comparing different groups of __________ values in isolation and when overlapped.

Question: AMC supports most common SQL functions, but there are some unsupported SQL functions. True False The answer(s) to the

Question: Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?