DEA-C01 Question #25: Real Exam Question with Answer & Explanation

Question

A data engineer is using Amazon Athena to analyze sales data that is in Amazon S3. The data engineer writes a query to retrieve sales amounts for 2023 for several products from a table named sales_data. However, the query does not return results for all of the products that are in the sales_data table. The data engineer needs to troubleshoot the query to resolve the issue. The data engineer's original query is as follows: SELECT product_name, sum(sales_amount) FROM sales_data WHERE year = 2023 GROUP BY product_name How should the data engineer modify the Athena query to meet these requirements?

Options

• AReplace sum(sales_amount) with count(*) for the aggregation.
• BChange WHERE year = 2023 to WHERE extract(year FROM sales_data) = 2023.
• CAdd HAVING sum(sales_amount) > 0 after the GROUP BY clause.
• DRemove the GROUP BY clause.

Explanation

https://docs.aws.amazon.com/athena/latest/ug/select.html

No community discussion yet for this question.