Unlock exclusive bundle offers on Google Ads, HubSpot & more! Unlock your discount now!

Blog

Amazon Marketing Cloud Exam Answers

Which of these queries will only include purchase records from the underlying table?

SELECT campaign, COUNT(DISTINCT user_id) AS purchasers, SUM(purchases) AS purchases FROM…

Amazon Marketing Cloud Exam Answers

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

impression_id request_tag user_id purchases The correct answer is: user_id

Amazon Marketing Cloud Exam Answers

The LIKE function is unsupported by AMC. Which of the following AMC-supported functions can serve as a substitute?

CAST SIMILAR TO COLLECT The correct answer is: SIMILAR TO

Amazon Marketing Cloud Exam Answers

Which table should you use in a query meant to help you choose new Amazon audiences that may benefit your Amazon DSP campaign performance?

amazon_audiences dsp_audiences dsp_impressions_by_user_segments dsp_impressions_by_matched_segments The correct answer is: dsp_impressions_by_user_segments

Amazon Marketing Cloud Exam Answers

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?

Amazon’s attribution logic leverages a 14-day window; queries run before…

Amazon Marketing Cloud Exam Answers

Which of the following business questions can be answered with an overlap analysis?

What was the average impressions per day per campaign per…

Amazon Marketing Cloud Exam Answers

Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?

dsp_impressions, amazon_attributed_events_* dsp_impressions_by_matched_segments, amazon_attributed_events_* dsp_impressions_by_user_segments, amazon_attributed_events_* The correct answer is:…

Amazon Marketing Cloud Exam Answers

Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?

dsp_impressions_by_matched_segments amazon_attributed_events_by_conversion_time conversions_with_relevance The correct answer is: dsp_impressions_by_matched_segments

Amazon Marketing Cloud Exam Answers

Which two functions can be used together to filter records based on presence of a string within a column’s values?

WHERE, COLLECT WHERE, CONCAT WHERE, SIMILAR TO WHERE, LIKE The…

Amazon Marketing Cloud Exam Answers

Which of the following Amazon services can be used to visualize aggregated AMC reports in a dashboard?

Amazon QuickSight Amazon S3 Amazon IAM The correct answer is:…