A company wants to start storing their large data sets on S3
They want to use a serverless service for managing the SQL queries.
They need to call these queries using JDBC and ODBC drivers.
Which of the following can be used for this purpose?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer - A.
The AWS Documentation mentions the following.
Athena is an interactive query service that lets you analyze data directly in Amazon S3 by using standard SQL.
You can access Athena by using JDBC and ODBC drivers, AWS SDK, or the Athena console.
Options B and C are incorrect since these are not serverless services.
Option D is incorrect since this is a compute service and not a query service.
For more information on Amazon Athena service, please refer to the below URL.
https://docs.aws.amazon.com/athena/latest/ug/what-is.htmlThe company wants to store their large data sets on S3 and use a serverless service for managing the SQL queries. Additionally, they need to call these queries using JDBC and ODBC drivers.
AWS offers several services that can meet these requirements, but the most suitable one for this scenario would be AWS Athena. Here's why:
AWS Athena is a serverless service that allows you to run SQL queries directly on data stored in Amazon S3. Athena is built on Presto, an open-source distributed SQL query engine, and offers compatibility with JDBC and ODBC drivers, which makes it easy to integrate with existing BI tools and applications.
With Athena, you don't need to manage any infrastructure, as the service automatically scales up or down depending on the query load. You only pay for the queries you run, which makes it a cost-effective solution for companies looking to analyze large datasets.
AWS EMR (Elastic MapReduce) is another option for processing large datasets, but it is a fully managed Hadoop and Spark platform, which requires more management overhead than Athena, and may not be the best fit for a serverless architecture.
AWS EC2 (Elastic Compute Cloud) is a virtual machine service that provides you with complete control over the infrastructure, but it requires significant effort to manage, scale and secure, which could be a burden on the company's IT resources.
AWS Lambda is a compute service that allows you to run code without provisioning or managing servers. While it can be used to process data stored in S3, it is not a suitable option for running SQL queries, as it is not designed to support complex data operations.
In summary, AWS Athena is the most suitable option for a company looking to store large datasets on S3, use a serverless service for managing SQL queries, and call these queries using JDBC and ODBC drivers.