Exam AWS Certified Cloud Practitioner CLF-C02 topic 1 question 43 discussion

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.

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/

Amazon Athena is a serverless query service that allows you to run SQL queries directly on data stored in Amazon S3. You pay only for the amount of data scanned during the query, which makes it a cost-effective solution for occasional querying, especially when dealing with large datasets such as the 5 TB in this case.

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.

Kinesis is for data streaming

B. Amazon Athena

b is ok

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.

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.

Answer B is Correct. Key: "Amazon S3. The company plans to occasionally run queries on the data for analysis"