DEA-C01 Question 340
Single answerYou are a data engineer working for a company that uses Amazon Redshift as their data warehouse. The business intelligence (BI) team has requested access to data visualizations for sales data stored in Amazon Redshift. Which of the following approaches will allow you to visualize the data effectively while minimizing additional infrastructure setup?
- A
Use Amazon QuickSight and connect it directly to Amazon Redshift for visualization.
- B
Export the data from Amazon Redshift to Amazon S3, then use Amazon Athena with a third-party BI tool for visualization.
- C
Set up an Apache Spark cluster using Amazon EMR to process the data and then visualize it using a custom-built dashboard.
- D
Schedule an ETL job to transfer data from Amazon Redshift to an on-premises database and use desktop-based visualization software.
Show answer and explanation
Correct answer: A
Explanation
The most efficient way to visualize data stored in Amazon Redshift is to use Amazon QuickSight, as it integrates directly with Redshift and is designed for creating interactive dashboards and visualizations. This approach minimizes infrastructure setup, avoids unnecessary data movement, and provides a scalable, managed solution.
- A. Correct.
This is the correct answer. Amazon QuickSight can directly connect to Amazon Redshift, enabling quick and efficient data visualization without requiring additional infrastructure or data movement.
- B. Incorrect.
While this approach can work, it involves unnecessary data movement and complexity compared to directly using Amazon QuickSight with Amazon Redshift.
- C. Incorrect.
Setting up an Apache Spark cluster is unnecessarily complex and not cost-efficient for simple data visualization tasks.
- D. Incorrect.
This approach involves moving data off the cloud to an on-premises system, which adds latency, complexity, and potential security risks.