AWS Certified DevOps Engineer – Professional (DOP-C02) — Question 96

A company is storing 100 GB of log data in .csv format in an Amazon S3 bucket. SQL developers want to query this data and generate graphs to visualize it. The SQL developers also need an efficient, automated way to store metadata from the .csv file.

Which combination of steps will 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 the AWS Glue Data Catalog as the persistent metadata store.
• F. Use Amazon DynamoDB as the persistent metadata store.

Correct answer: B, C, E

Explanation

The correct answer options B, C, and E provide a streamlined approach for SQL developers to visualize the data and manage metadata. Amazon QuickSight offers visualization capabilities, Amazon Athena enables querying of data in S3 without the need for ETL, and AWS Glue Data Catalog serves as an efficient metadata repository. The other options either do not focus on visualization (A and D) or suggest less suitable metadata storage solutions (F).