SAP-C02 Question 355
Single answerA company is migrating its on-premises data lake to AWS and is looking for a managed service that can handle petabyte-scale data storage with native support for querying data using SQL. The solution should also integrate seamlessly with other AWS services such as AWS Glue for ETL and Amazon QuickSight for visualization. Which AWS managed service is most appropriate for this use case?
- A
Amazon S3
- B
Amazon Redshift
- C
Amazon Athena
- D
AWS Lake Formation
Show answer and explanation
Correct answer: C
Explanation
Amazon Athena is the best choice for this use case because it is a fully managed service that allows SQL querying directly on data stored in Amazon S3, which is often used as the storage backend for data lakes. It integrates with AWS Glue for ETL processes and Amazon QuickSight for visualization, fulfilling all the requirements mentioned in the scenario. While services like Amazon S3 and AWS Lake Formation play important roles in data lake architectures, they lack native SQL querying capabilities. Amazon Redshift, on the other hand, is designed for data warehousing rather than data lakes.
- A. Incorrect.
Amazon S3 is a scalable object storage service, but it does not natively provide SQL querying capabilities. You would need to integrate additional services like Amazon Athena for querying data.
- B. Incorrect.
Amazon Redshift is a fully managed data warehouse optimized for high-performance analytics but is not designed specifically for managing a data lake or integrating seamlessly with AWS Glue for ETL and Amazon QuickSight.
- C. Correct.
Amazon Athena is a fully managed service that enables SQL querying directly on data stored in Amazon S3. It integrates natively with AWS Glue for ETL and Amazon QuickSight for data visualization, making it the most appropriate choice for this scenario.
- D. Incorrect.
AWS Lake Formation is a service designed to simplify the creation and management of data lakes on AWS. However, it does not natively support SQL querying. Instead, it often works in conjunction with services like Amazon Athena or Amazon Redshift.