SAA-C03 Question 346
Select 2A retail company has a large dataset of sales transactions stored in Amazon S3. They want to perform ad hoc SQL queries on this data to analyze sales trends without setting up or managing any servers. Additionally, they need the ability to grant specific teams access to only certain parts of the dataset. Which combination of services would best meet these requirements?
- A
Amazon Athena
- B
AWS Lake Formation
- C
Amazon QuickSight
- D
Amazon Redshift
Show answer and explanation
Correct answers: A, B
Explanation
The combination of Amazon Athena and AWS Lake Formation is ideal for this scenario. Amazon Athena provides the ability to run serverless ad hoc SQL queries directly on Amazon S3 data, while AWS Lake Formation enables fine-grained access control to the dataset, ensuring that only authorized teams can access specific parts of the data. These services together fulfill both the analytical and access control requirements for the retail company.
- A. Correct.
Amazon Athena is a serverless query service that allows the execution of ad hoc SQL queries directly on data stored in Amazon S3, making it ideal for analyzing sales trends in this scenario.
- B. Correct.
AWS Lake Formation is a service that simplifies the process of creating a secure data lake and managing granular access controls, ensuring specific teams can access only relevant parts of the dataset.
- C. Incorrect.
Amazon QuickSight is a business intelligence service used for data visualization. While it allows the creation of dashboards, it does not handle ad hoc SQL querying or fine-grained access control for datasets.
- D. Incorrect.
Amazon Redshift is a data warehousing solution that requires infrastructure setup and management. While capable of running SQL queries, it is not designed for serverless ad hoc querying directly on S3 data.