DEA-C01 Question 336
Single answerYou are working as a data engineer at a company that uses Amazon Redshift to store large volumes of structured data. Your team needs to visualize customer purchasing patterns to identify trends. The visualization needs to be interactive and allow business analysts to explore the data dynamically. Which of the following approaches would best meet this requirement?
- A
Use Amazon QuickSight to directly connect to the Amazon Redshift cluster and create interactive dashboards.
- B
Export the data from Amazon Redshift to CSV files and use a third-party tool like Microsoft Excel for visualization.
- C
Use AWS Glue to transform the data and load it into an S3 bucket, then visualize it with Amazon Quicksight using S3 as the data source.
- D
Create a custom visualization application by processing data from Amazon Redshift using AWS Lambda and presenting it on a web interface.
Show answer and explanation
Correct answer: A
Explanation
Amazon QuickSight is a fully managed business intelligence (BI) service that natively integrates with Amazon Redshift. It allows you to create interactive dashboards with minimal setup and no need for additional infrastructure, making it the best choice for this scenario. Other options either add unnecessary complexity, lack scalability, or require significant development effort.
- A. Correct.
This is the correct option because Amazon QuickSight natively integrates with Amazon Redshift and is specifically designed for creating interactive dashboards and visualizations for analysis.
- B. Incorrect.
While this option might work for small datasets, exporting data to CSV files and using Excel limits scalability and interactivity. It is not an efficient or scalable solution for large datasets in Amazon Redshift.
- C. Incorrect.
Although this approach could work, it unnecessarily adds complexity by introducing AWS Glue and S3 when Amazon QuickSight can directly connect to Amazon Redshift for visualization.
- D. Incorrect.
Creating a custom visualization application with Lambda would require significant development effort and expertise. It is not the most efficient approach when a managed service like Amazon QuickSight can achieve the same goal with less effort.