Amazon Marketing Cloud Certification Answers

Amazon Marketing Cloud Certification Answers

Amazon Marketing Cloud (AMC) is a secure, cloud-based clean room solution that allows advertisers to perform analytics across pseudonymized signals, including Amazon Ads event tables as well as their own inputs. The Amazon Marketing Cloud Certification validates an individual's proficiency using the AMC user interface and their ability to leverage event tables to write queries and generate advanced performance reports.

 

Exam Url: https://learningconsole.amazonadvertising.com/student/path/36272-amazon-marketing-cloud-certification?sid=5d357e06-4896-4acf-bb3f-a1bf59ae6766&sid_i=8

 

Amazon Marketing Cloud Certification Assessment

 

This assessment is comprised of 50 questions which cover topics related to the Amazon Marketing Cloud Certification.

• You will have 120 minutes to complete the assessment.
• Achieve a score of 80% to pass the assessment.
• If you end the assessment early or the timer runs out before you have answered all questions, you will not pass and will not be able to resume where you left off.
• You may not review your answers once they've been submitted.
• You may attempt the assessment again after 24 hours.

All answers to pass this certification are only in our .PDF file, you can buy and download here:

 

Amazon Marketing Cloud Certification Answers

 

Questions:

 

AMC audiences is an API-only feature.

• False
• True

 

What can Amazon shopping insights be used for?

• Understanding retail patterns
• Determining ad campaign correlation with purchases not directly attributed to ads
• Creating flexible reports for brands that sell on Amazon

 

Paid features tables are only available in advertiser instances.

• False
• True

 

Developers can access AMC APIs via the Amazon Ads API gateway.

• True
• False

 

Where can you activate AMC audiences?

• Amazon DSP
• Amazon Clean Rooms
• Seller Central
• AMC API's

 

This table contains impression and click events from Sponsored Products, Sponsored Brands, Sponsored Display, and Sponsored Television campaigns

• adserver_traffic
• sponsored_ads_traffic
• dsp_impressions_by_user_segments:
• conversions_with_relevance

 

Why is the AMC sandbox a helpful environment for testing queries?

• The AMC sandbox supports a wider variety of SQL expressions
• The volume of records is larger than what an advertiser instance typically contains, allowing you to more quickly test your queries
• The AMC sandbox will provide query development guidance directly in the query editor
• The volume of records is smaller than what an advertiser instance typically contains, allowing you to more quickly test your queries

 

Which environment allows you to inspect AMC tables at record level?

• An AMC sandbox instance
• A manager account
• An AMC advertiser instance
• An AMC account

 

Conversions measured via Events Manager can be made available for querying in AMC.

• False
• True

 

What is an AMC sandbox?

• An instance in which you can explore, develop, test and innovate in AMC using synthetic records
• An AMC environment where you can be a beta-tester for new API and UI features
• A gen-AI powered tool that walks you through how to run your first AMC query

 

What are custom parameters?

• Parameters that can be invoked in your SQL query and replaced by specified values during query execution
• Credentials for the S3 bucket that you have connected to your AMC instance
• Custom models that you can use for AMC lookalike audience generation
• Synthetic signals that exist within an AMC sandbox instance, which mimic the structure and statistical properties of those records in an advertiser instance

 

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.

• Paid features (beta)
• Instructional query library (IQL)
• Query editor
• Instance info

 

Which of the following statements about AMC lookalike (LAL) audiences is false?

• AMC LAL features are identical to Amazon DSP LAL features
• AMC LAL audiences are often a fit for prospecting tactics
• The seed for the AMC LAL audience is composed using AMC SQL
• The seed for the AMC LAL audience is composed using AMC SQL

 

AMC audience creation leverages a separate set of tables than those utilized for AMC reporting.

• True
• False

 

Which of these statements is false regarding AMC audiences?

• Audiences are created via SQL logic
• Audiences must exceed 2000 records
• Audiences cannot be configured to refresh
• Audiences cannot be modified once created

 

Which of these is NOT a method of optimizing your AMC SQL?

• Optimizing the query’s order of operations
• Optimizing JOIN conditions
• Adding redundant subqueries
• Filtering records early in the query

 

Custom parameters help make queries more reusable because they __________.

• allow you to run a single query across multiple instances in parallel
• enable you to publish custom queries to your team's AMC instance
• eliminate the need to hard-code values directly into your SQL code

 

What is SQL optimization in the context of AMC?

• The process of sampling AMC tables for directional results rather than querying the full tables for accurate and complete reports
• The process of using AMC custom parameters to make a query run more efficiently
• The process of optimizing your first-party schema to perform more efficiently when being queried within AMC
• The process of improving the performance of a query by adjusting query elements to reduce execution time and resource usage while still producing accurate results.

 

Which of these analyses can be accomplished with an overlap query?

• Generating delivery metrics per campaign and per line item
• Determining how a first-party uploaded audience compares to Amazon audiences
• Generating delivery metrics per Amazon audience

 

1. Why are developer resources required for creating first-party tables in AMC?
2. For sponsored ads Cost-per-Click (CPC) campaigns, only click events are eligible for attribution of conversion events.
3. 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?
4. There is not a field for campaign ID in the sponsored_ads_traffic table, so the _____________ field can be used to filter to traffic events from the relevant sponsored ads campaigns.
5. 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?
6. 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?
7. How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
8. In AMC, a conversion is defined as an Amazon.com purchase event.
9. Which value is not available for Sponsored Products?
10. Which AWS service can be leveraged by the AWS Admin to provide appropriate permissions and access keys to AMC API users?
11. What types of Sponsored Products records will have spend metrics?
12. Why is it considered a good best practice to exclude NULL user_id values from reach and frequency queries?
13. Which of the following Amazon services can be used to visualize aggregated AMC reports in a dashboard?
14. Which two functions can be used together to filter records based on presence of a string within a column’s values?
15. user_id values cannot be viewed in the AMC user interface or downloaded from AMC.
16. Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?
17. Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
18. Which of the following business questions can be answered with an overlap analysis?
19. 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?
20. How would you adapt this query to limit results to Sponsored Products keyword targeting only?
21. Which table should you use in a query meant to help you choose new Amazon audiences that may benefit your Amazon DSP campaign performance?
22. The LIKE function is unsupported by AMC. Which of the following AMC-supported functions can serve as a substitute?
23. The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations to understand unique reach volumes.
24. Overlap analyses enable you to generate insights by comparing different groups of __________ values in isolation and when overlapped.
25. Which of these queries will only include purchase records from the underlying table?
26. AMC can be used by brands that don’t sell their products directly in the Amazon store.
27. 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.
28. New-to-brand metrics are only relevant for __________.
29. AMC users have access to all AMC instances in an account by default.
30. 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.
31. Which event table can be used when attributing conversions to your campaign using custom logic (e.g., 28 day lookback window)?
32. Which of the following statements is true about using queries within the instructional query library?
33. What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
34. Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions
35. The __________ field functions as a grouping indicator for the impression and any associated clicks, view events, or conversion events.
36. Which signals are not available within AMC?
37. Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
38. You must connect your organization’s AWS account to AMC in order to leverage the AMC APIs.
39. What are the two ways to access AMC?
40. You can use a _________ filter to limit your query results based on one or more conditions.
41. What is a primary usage of the UNION ALL function in AMC queries?
42. Rule-based audience creation leverages a separate set of tables than those utilized for AMC reporting.
43. When determining total impressions served over a given date range, you can use dsp_impressions or dsp_views.
44. What is one limitation of AMC SQL?
45. AMC supports most common SQL functions, but there are some unsupported SQL functions.
46. Which of these use cases can be achieved when using Amazon Ads events in conjunction with first-party inputs?
47. To minimize the number of values rendered NULL due to aggregation thresholds, you can:
48. Where can you activate AMC rule-based audiences?
49. Which of these statements is true regarding recurring query automation?
50. 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?
51. How would you adapt this query to obtain cost and impression metrics by supply_source?
52. Why would this query fail?
53. The Path to Conversion by Campaign Groups IQ considers all touch points but the output is based on the timing of the first impression of the campaign group.
54. What is an exploratory query?
55. What is the max window over which AMC can accrue Amazon Ads events?
56. There is no universal methodology or join key that can be used to combine tables in all query scenarios.
57. The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
58. The _____________ field in the conversions_with_relevance table categorizes the relationship between the conversion event and the campaign it is relevant to.
59. Clicks are considered conversion events and appear as individual records within the amazon_attributed_events_* tables.
60. What is the Amazon Ads attribution lookback window?
61. Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
62. Which of these statements is false regarding rule-based audiences?
63. What is required to access AMC APIs?
64. When analyzing the relationship between frequency and purchase rate, what actionable insight can you leverage for campaign optimization?
65. 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.
66. 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.
67. This table contains impression and click events from Sponsored Products (SP), Sponsored Brands (SB), and Sponsored Display (SD) campaigns.
68. 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?
69. Cost and fee fields are always reported in microcents.
70. Which of the following statements about paid features (beta) is false?
71. Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
72. Which of the following statements about the amazon_attributed_events_* tables is true.
73. Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?
74. Performance reporting, such as Path to Conversion reporting, can be constrained to specific conversion events (e.g. purchases of a specific ASIN).
75. 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 __________.
76. 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
77. Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.

 

 

Practice assessment:

 

 

 

 

 

 

 

 

 

 

 

 

 

SQL Pre-assessment:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Download Now!