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
Correct Answer
WHERE, SIMILAR TO
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
- 1The ___________ function can be used to append a string to ID fields (such as campaign_id), preventing issues reading the accurate ID values within Excel.
- 2Which function can be used to append a string to ID fields (i.e., campaign_id) to prevent issues when reading the values in Excel?
- 3Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?
- 4Clicks are considered conversion events and appear as individual records within the amazon_attributed_events_* tables.
- 5How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
- 6You can use a _________ filter to limit your query results based on one or more conditions.