Topic 1 Question 43
A company has 5 TB of data stored in Amazon S3. The company plans to occasionally run queries on the data for analysis. Which AWS service should the company use to run these queries in the MOST cost-effective manner?
Amazon Redshift
Amazon Athena
Amazon Kinesis
Amazon RDS
ユーザの投票
コメント(10)
- 正解だと思う選択肢: B
B. Amazon Athena Amazon Athena is a serverless query service that allows you to analyze data directly in Amazon S3 using standard SQL queries. You don't need to set up or manage any infrastructure; you only pay for the queries you run. It is well-suited for ad-hoc and exploratory analysis on data stored in S3 without the need for maintaining a separate database. Option A (Amazon Redshift) is a fully-managed data warehouse service and is more suitable for complex analytics and large-scale data warehousing scenarios. It might be more cost-effective for frequent and complex analytical workloads. Option C (Amazon Kinesis) is a service for real-time processing of streaming data and is not designed for running ad-hoc queries on stored data. Option D (Amazon RDS) is a managed relational database service and is not the most cost-effective choice for running queries directly on data stored in S3.
👍 26axat2023/12/04 - 正解だと思う選択肢: B
The answer is B.
Amazon Athena is a serverless, interactive analytics service built on open-source frameworks, supporting open-table and file formats. Athena provides a simplified, flexible way to analyze petabytes of data where it lives. Analyze data or build applications from an Amazon Simple Storage Service (S3) data lake and 30 data sources, including on-premises data sources or other cloud systems using SQL or Python. Athena is built on open-source Trino and Presto engines and Apache Spark frameworks, with no provisioning or configuration effort required. https://aws.amazon.com/athena/
👍 9Anyio2023/10/15 - 正解だと思う選択肢: B
A. Amazon Redshift: Suited for running complex queries on large datasets in a data warehouse. It involves provisioning and managing a cluster, and it may be more suitable for regular or ongoing analytics workloads.
B. Amazon Athena: A serverless query service that allows you to analyze data in Amazon S3 using standard SQL without the need to manage infrastructure. It is cost-effective for occasional or ad-hoc queries, as you only pay for the queries you run.
C. Amazon Kinesis: Primarily used for real-time data streaming and analytics. It is not designed for running ad-hoc queries on stored data.
D. Amazon RDS: A managed relational database service. While it supports querying data, it is not typically used for ad-hoc analysis on large datasets stored in Amazon S3.
In the context of occasional query analysis on data stored in Amazon S3, Amazon Athena (Option B) is the most cost-effective choice due to its serverless and pay-as-you-go nature.
👍 6TheFivePips2024/01/24
シャッフルモード