DEA-C01 exam dumps

DEA-C01 practice question 319 of 550

AWS Certified Data Engineer - Associate. Associate level, Amazon Web Services. Free question with the correct answer and a full explanation.

DEA-C01 Question 319

Single answer

A company is using Amazon S3 to store large amounts of raw log files generated by its web application. The company wants to analyze these logs to gain insights into user behavior, such as identifying the most frequently accessed URLs and patterns of access. The team wants a cost-effective solution that does not require setting up and managing servers. Which AWS service should the company use to analyze the data?

  1. A

    Amazon Athena

  2. B

    Amazon Redshift

  3. C

    AWS Glue

  4. D

    Amazon EMR

Show answer and explanation

Correct answer: A

Explanation

Amazon Athena is the most suitable service for analyzing log data stored in Amazon S3. It enables running SQL queries directly on the data without needing to manage servers or clusters, making it a cost-effective and efficient choice for this scenario. Other options like Redshift, Glue, and EMR involve more complex setups or are better suited for different types of workloads.

  • A. Correct.

    Amazon Athena is the best choice for this use case as it allows you to run SQL queries directly on data stored in Amazon S3 without needing to manage any infrastructure. This makes it cost-effective and serverless.

  • B. Incorrect.

    Amazon Redshift is a powerful data warehouse service, but it requires setting up a cluster and is not serverless. It is more suitable for complex, large-scale analytical workloads rather than simple log analysis directly from S3.

  • C. Incorrect.

    AWS Glue is primarily used for data cataloging and ETL processes to prepare and transform data. While it can be part of the solution, it does not directly analyze data.

  • D. Incorrect.

    Amazon EMR is a managed Hadoop and Spark service, which can be used for data analysis, but it requires managing clusters and is not as simple or cost-effective as Athena for this specific use case.

Timed practice exam

Take a DEA-C01 practice test under exam conditions

65 questions in 130 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam