DEA-C01 Question 337
Select 2You are a data engineer at a retail company that stores large amounts of sales data in Amazon Redshift. The analytics team wants to visualize trends in the sales data and create dashboards for executive reporting. Which combination of services should you use to visualize the data efficiently?
- A
Use Amazon QuickSight to connect directly to Amazon Redshift and create visualizations.
- B
Export the data from Amazon Redshift to Amazon S3, then use AWS Glue to transform the data before visualizing it in Amazon QuickSight.
- C
Use Amazon Athena to query the data in Amazon Redshift and then create visualizations in Amazon QuickSight.
- D
Enable Amazon Redshift Spectrum to query the data directly from Amazon S3 and visualize it in Amazon QuickSight.
- E
Set up an Amazon EMR cluster to process the data, store the results in Amazon S3, and then visualize the data using Amazon QuickSight.
Show answer and explanation
Correct answers: A, D
Explanation
To efficiently visualize data stored in Amazon Redshift, Amazon QuickSight can be directly used to connect to Redshift and create dashboards. Alternatively, Redshift Spectrum can be enabled to query data directly from Amazon S3, which can also be visualized in QuickSight. Both approaches minimize complexity and provide a streamlined solution for visualization.
- A. Correct.
Correct: Amazon QuickSight can connect directly to Amazon Redshift, allowing the analytics team to create dashboards and visualizations without needing additional services.
- B. Incorrect.
Incorrect: While exporting data to Amazon S3 and using AWS Glue for transformation is possible, it introduces unnecessary complexity when Amazon QuickSight can directly connect to Amazon Redshift.
- C. Incorrect.
Incorrect: Amazon Athena is primarily used for querying data stored in Amazon S3, not data in Amazon Redshift. This option is not a valid approach for this scenario.
- D. Correct.
Correct: Amazon Redshift Spectrum allows you to query data in Amazon S3 without moving it into Amazon Redshift, and Amazon QuickSight can be used to visualize the queried data.
- E. Incorrect.
Incorrect: Using Amazon EMR to process the data and then store it in Amazon S3 adds unnecessary overhead. Amazon QuickSight can directly connect to Amazon Redshift or Redshift Spectrum, making this option less efficient.