Answer-first summary for fast verification
Answer: Amazon Athena
Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. It can be used to optimize for ad-hoc querying by enabling fast and cost-effective analysis of large-scale data sets. To configure it, you can create an Athena database, define the necessary table schema and partitions, and run SQL queries against the data stored in S3. Amazon Redshift with Redshift Spectrum can be used to query data stored in S3, but it is a data warehouse service and may not be optimized for ad-hoc querying. Amazon RDS with read replicas can improve read performance, but it is not designed for ad-hoc querying. Amazon DynamoDB with global secondary indexes can be used to support ad-hoc querying, but it is a NoSQL database service and may not be suitable for large-scale data warehousing.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company is planning to implement a data warehousing solution on AWS. The data warehouse should be able to handle large-scale data sets and support ad-hoc querying. Which AWS service should you choose, and how should you configure it to optimize for ad-hoc querying?
A
Amazon Redshift with Redshift Spectrum
B
Amazon RDS with read replicas
C
Amazon DynamoDB with global secondary indexes
D
Amazon Athena