DEA-C01 Question 339
Select 2A company has stored its sales data in Amazon S3 in Parquet format. The data engineering team needs to create visualizations for this data to analyze the trends in sales over time. They want a solution that minimizes operational overhead and integrates seamlessly with AWS services. Which of the following steps should they take to achieve this?
- A
Use AWS Glue to catalog the data in the S3 bucket and make it available for querying.
- B
Use Amazon QuickSight to connect directly to the S3 bucket and create visualizations from the Parquet files.
- C
Create an AWS Glue ETL job to convert the Parquet files to CSV format before visualizing the data.
- D
Use Amazon Athena to query the data in the S3 bucket and then connect Amazon QuickSight to Athena for visualization.
- E
Export the data to a third-party visualization tool after downloading it locally from the S3 bucket.
Show answer and explanation
Correct answers: A, D
Explanation
To minimize operational overhead and work seamlessly within the AWS ecosystem, the team should use AWS Glue to catalog the data and Amazon Athena to query it. Then, they can use Amazon QuickSight, which integrates directly with Athena, to create visualizations. This solution avoids unnecessary data transformations and third-party dependencies, aligning with the company's goals.
- A. Correct.
Correct: AWS Glue can catalog the data stored in S3, enabling services like Amazon Athena to query the data using SQL.
- B. Incorrect.
Incorrect: Amazon QuickSight cannot directly connect to Parquet files in S3. It requires data to be accessible through other services like Athena or Redshift.
- C. Incorrect.
Incorrect: While converting data to CSV might make it easier for some tools, it is unnecessary here as Athena can natively query Parquet files.
- D. Correct.
Correct: Amazon Athena can query Parquet files in S3 directly, and QuickSight can integrate with Athena to create visualizations.
- E. Incorrect.
Incorrect: Exporting data to a third-party tool adds unnecessary complexity and operational overhead, which is against the stated requirements.