AWS Certified DevOps Engineer – Professional — Question 45

A company has 100 GB of log data in an Amazon S3 bucket stored in .csv format. SQL developers want to query this data and generate graphs to visualize it.
They also need an efficient, automated way to store metadata from the .csv file.
Which combination of steps should be taken to meet these requirements with the LEAST amount of effort? (Choose three.)

Answer options

• A. Filter the data through AWS X-Ray to visualize the data.
• B. Filter the data through Amazon QuickSight to visualize the data.
• C. Query the data with Amazon Athena.
• D. Query the data with Amazon Redshift.
• E. Use AWS Glue as the persistent metadata store.
• F. Use Amazon S3 as the persistent metadata store.

Correct answer: B, C, E

Explanation

The correct answer includes using Amazon QuickSight for visualization, Amazon Athena for querying the .csv data directly from S3, and AWS Glue for storing metadata efficiently. Options A and D do not meet the requirements for visualization or querying in this context, while option F is less suitable for a persistent metadata store compared to AWS Glue.