Home › AWS Solutions Architect Associate › cloudcomputing › highperformingarchitectures › Which AWS service provides a managed, query-on-d…
Which AWS service provides a managed, query-on-demand interface to analyse data already sitting in S3 using standard SQL, with no infrastructure to manage?
AAWS Glue ETL jobs only
BAmazon Athena
CAmazon EC2 instances running Hive manually
DAmazon Redshift dense compute nodes
Answer & Solution
Correct answer: B. Amazon Athena
Athena is a serverless interactive SQL engine that queries S3 (Parquet, JSON, CSV, ORC, etc.). Redshift requires cluster provisioning. Glue is for ETL pipelines. Manual Hive on EC2 inverts the "no infrastructure" requirement.
Related questions
Which combination most efficiently runs spiky containerised workloads at the lowest operatWhich architecture pattern handles a sudden 10× write burst from millions of IoT devices wA workload needs millisecond reads at any scale on a key-value access pattern with predictAn OLTP workload has a relational schema, needs single-digit-ms latency at the 99th percenWhich AWS service routes user traffic at the IP layer with anycast addressing and Region fWhich combination accelerates static content delivery to global users in front of an origiAn application's RDS for MySQL primary is CPU-bound under read traffic. Without changing tWhich compute option scales to zero between requests and bills per invocation millisecond,