AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: A data engineer is using Amazon Athena for aws video

Question 1
« Back   Next aws data-engineer Exam Question »

Full Certification Question

A data engineer is using Amazon Athena for querying customer engagement data stored in Amazon S3. The analyst needs to extract information about customer interactions for the year 2023 from a table called interaction_data. The initial query designed to fetch the total interactions per customer for 2023 is not yielding results for some customers known to have interactions in that year. The query needs adjustment to correctly reflect the entire dataset. The original query is: SELECT customer_id, sum(interactions) FROM interaction_data WHERE year = 2023 GROUP BY customer_id How should the data engineer modify the Athena query to ensure it includes all relevant customer data for 2023?