AWS Certified DevOps Engineer - Professional DOP-C02 — Topic 1 Question 117

Question

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.)

Accepted Answer

Correct answer: B, C, E. The correct answer is B, C, E. Option B: Filter the data through Amazon QuickSight to visualize the data. Option C: Query the data with Amazon Athena. Option E: Use the AWS Glue Data Catalog as the persistent metadata store. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. Amazon QuickSight is a serverless business-intelligence and dashboard service.

AWS Certified DevOps Engineer - Professional DOP-C02 — Question 117