Happy to Announce Our New Discussion Forum | Join Now

WhizQuiz Oct 30th, 2018

Which of the following service can be used to run ad-hoc queries for data in S3 without the need to set up or manage any servers?

  • A. EMR
  • B. Athena
  • C. Presto
  • D. Redshift

0 voters

Hi All,
Amazon Anthena is an “interactive” query service that makes it easy to analyze data directly in Amazon S3 using Standard SQL. Using AWS Management Console, customers can point Anthena at their data stored in S3 and begin using standard SQL to run ad-hoc queries.


Correct Answer is B

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

For more information on AWS Athena please refer to the below URLs:

A. AWS EMR makes it simple and cost effective to run highly distributed processing frameworks such as Hadoop and Spark on AWS vs running on-premise.

C. Presto is an open-source distributed SQL query engine optimized for low-latency, ad-hoc analysis of data. It supports the ANSI SQL standard, including complex queries, aggregations, joins, and window functions. Presto can process data from multiple data sources including the Hadoop Distributed File System (HDFS) and Amazon S3.

Please Note the relation between Amazon Athena uses Presto. Amazon Athena uses Presto with full standard SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, Apache Parquet and Avro.

D. Amazon Redshift provides the fastest query performance for enterprise reporting and business intelligence workloads, particularly those involving extremely complex SQL with multiple joins and subqueries.

So, The correct answer is B Athena