Category: Amazon Marketing Cloud Exam Answers

• WHERE, COLLECT
• WHERE, CONCAT
• WHERE, SIMILAR TO
• WHERE, LIKE

The correct answer is:

• WHERE, SIMILAR TO

• Amazon QuickSight
• Amazon S3
• Amazon IAM

The correct answer is:

• Amazon QuickSight

• Because NULL user_id values are deemed invalid traffic in post-impression server-side models.
• This would be redundant; records with NULL user_id values have been removed upstream of query processing anyway.
• Reach and frequency cannot be accurately determined for NULL user_id values, so this group is excluded to prevent NULL user_id values from skewing the results.

The correct answer is:

• Reach and frequency cannot be accurately determined for NULL user_id values, so this group is excluded to prevent NULL user_id values from skewing the results.

• Records representing audience membership insights for Sponsored Product impression events
• Records representing Sponsored Product click events
• Records representing Sponsored Product impression events
• Records representing Sponsored Product view events

The correct answer is:

• Records representing Sponsored Product click events

• SageMaker
• QuickSight
• IAM

The correct answer is:

• IAM

• campaign_id
• user_id
• engagement_scope
• purchases

The correct answer is:

• campaign_id

• True
• False

The correct answer is:

• False

• Check the aggregation thresholds for the event tables in the Schema explorer
• Run the report multiple times and look for a variance in the results
• Use the Append aggregation threshold columns option in the Query editor
• NULL values don’t occur naturally within reports unless the query is invalid.

The correct answer is:

• Use the Append aggregation threshold columns option in the Query editor

• Query editor
• Schema explorer
• Instance info
• Submitted queries

The correct answer is:

• Schema explorer

• Sponsored Products and DSP Display Overlap
• Audience Overlap Analysis
• Path to Conversion by Campaign Groups

The correct answer is:

• Path to Conversion by Campaign Groups