ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 333 - CLF-C02 discussion

Report
Export

A company is expecting a short-term spike in internet traffic for its application. During the traffic increase, the application cannot be interrupted. The company also needs to minimize cost and maximize flexibility.

A company needs to use a serverless interactive query service to analyze data in Amazon S3. The query service must support standard SQL.

Which AWS service will meet these requirements?

A.
Amazon Redshift
Answers
A.
Amazon Redshift
B.
AWS Glue
Answers
B.
AWS Glue
C.
Amazon Athena
Answers
C.
Amazon Athena
D.
Amazon Kinesis Data Streams
Answers
D.
Amazon Kinesis Data Streams
Suggested answer: C

Explanation:

Amazon Athena is a serverless interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is ideal for quick, ad-hoc querying but it can also handle complex analysis, including large joins, window functions, and arrays. Athena scales automatically-executing queries in parallel-so results are fast, even with large datasets and complex queries. Amazon Redshift is a fully managed, petabyte-scale data warehouse service that can run complex analytic queries against structured and semi-structured data using standard SQL. However, it is not a serverless service and requires provisioning and managing clusters of nodes. AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load your data for analytics. However, it is not a query service and does not support standard SQL. Amazon Kinesis Data Streams is a service that enables you to build custom applications that process or analyze streaming data for specialized needs. However, it is not a query service and does not support standard SQL.

asked 16/09/2024
Sebrena Adkins
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first