SAA-C03 Question 345
Select 2A retail company collects and stores transactional data from its point-of-sale (POS) systems in an Amazon S3 data lake. The company wants to create interactive dashboards and visualizations to analyze sales trends. The solution should allow business analysts to create reports without needing to write SQL queries. Which combination of services should you recommend?
- A
Amazon QuickSight
- B
Amazon Athena
- C
AWS Lake Formation
- D
Amazon Redshift
- E
AWS Glue
Show answer and explanation
Correct answers: A, C
Explanation
The combination of Amazon QuickSight and AWS Lake Formation is ideal for this scenario. QuickSight allows business analysts to create dashboards and visualizations without needing SQL expertise, and Lake Formation simplifies the management and secure access of the data stored in the Amazon S3 data lake. While other services like Athena and Glue can be helpful for querying and transforming data, they are not directly required for the stated objectives of the question.
- A. Correct.
Amazon QuickSight is a business intelligence service that provides tools for creating interactive dashboards and visualizations. It is ideal for the company's requirement to analyze sales trends and allow business analysts to create reports without writing SQL queries.
- B. Incorrect.
Amazon Athena is a serverless query service that allows you to analyze data directly in Amazon S3 using SQL. While it is useful for querying the data in the S3 data lake, it does not fulfill the requirement of creating interactive dashboards without SQL.
- C. Correct.
AWS Lake Formation simplifies the process of setting up a secure data lake on Amazon S3 and managing access to the data. It is a suitable choice for enabling secure access and organizing the data for analysis and visualization.
- D. Incorrect.
Amazon Redshift is a data warehousing solution that can be used for complex queries and analytics. However, in this scenario, the data is already in an Amazon S3 data lake, and Redshift is not a necessary component for the solution.
- E. Incorrect.
AWS Glue is a fully managed extract, transform, and load (ETL) service that can be used to prepare and transform data for analysis. However, the scenario does not mention the need for data transformation or ETL processes.