Which of these statements is true regarding recurring query automation?
AMC queries executed via UI or API will automatically recur on a daily cadence
Once recurring queries are set up, modifications to the query schedule can be made in the Instance info panel of the AMC UI
You can download the results of automatically-recurring queries from the Submitted queries table in the AMC UI
Delivery of recurring AMC queries can be automated via API only
Correct Answer
Delivery of recurring AMC queries can be automated via API only
Topics in this question
About the Amazon Marketing Cloud Certification
The Amazon Marketing Cloud Certification covers Amazon's clean-room analytics environment: how AMC data is structured, writing SQL queries against it, and turning results such as overlap and path-to-conversion analysis into audience and media decisions.
Exam guide and all 95 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
- 2Which of these statements is false regarding AMC audiences?
- 3Which of the following statements about the amazon_attributed_events_* tables is true.
- 4Which of these analyses can be accomplished with an overlap query?
- 5SELECT total_impressions SUM (impressions) AS device_type FROM campaign, supply_source GROUP BY 1,2,3 SELECT campaign, supply_source, SUM (impressions) AS impressions FROM device_type GROUP BY 1,2 SELECT campaign, supply_source, device_type, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3 The correct answer is: SELECT campaign, supply_source, device_type, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3 Explanation: The correct query to get the total impressions delivered per campaign, per supply source, and per device type is: SQL SELECT campaign, supply_source, device_type, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1, 2, 3 ✅ Explanation of the Query This is a standard and efficient SQL query structure for use in Amazon Marketing Cloud (AMC) .Multiple correct
- 6Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.