SAA-C03 Question 348
Select 2A company has a large dataset stored in Amazon S3. They want to perform ad-hoc SQL queries on this data without setting up or managing any servers. Additionally, they need to visualize the results of these queries in dashboards to share insights across their organization. Which combination of AWS services should they use to meet these requirements?
- A
Amazon Athena
- B
AWS Lake Formation
- C
Amazon QuickSight
- D
Amazon Redshift
- E
Amazon EMR
Show answer and explanation
Correct answers: A, C
Explanation
The combination of Amazon Athena and Amazon QuickSight is the most suitable solution for this scenario. Amazon Athena enables the company to perform ad-hoc SQL queries on the data stored in Amazon S3 without any server management. Meanwhile, Amazon QuickSight allows the visualization of query results through dashboards, fulfilling the requirement to share insights across the organization. Other options like AWS Lake Formation, Amazon Redshift, and Amazon EMR are not as well-suited for this specific use case, as they either involve additional complexity or are designed for different purposes.
- A. Correct.
Amazon Athena is a serverless query service that allows you to run SQL queries directly on data stored in Amazon S3. It is ideal for running ad-hoc queries without the need for infrastructure management, making it a perfect choice for this use case.
- B. Incorrect.
AWS Lake Formation is primarily used for setting up secure data lakes and managing permissions for data stored in S3. While it can assist with data organization and security, it does not directly handle SQL queries or visualization, making it less suited for this specific scenario.
- C. Correct.
Amazon QuickSight is a business intelligence tool that allows you to create interactive dashboards and visualizations. It integrates well with Athena, enabling users to visualize query results, which is essential for this use case.
- D. Incorrect.
Amazon Redshift is a fully managed data warehouse solution designed for large-scale analytics. While it is powerful, it requires setting up and managing a cluster, which is unnecessary for ad-hoc queries on S3 data in this scenario.
- E. Incorrect.
Amazon EMR is a big data processing service that supports frameworks like Apache Spark and Hadoop. While it can process large datasets, it is not ideal for simple SQL queries or visualization, as it requires more complex setup and management.