Question 25
Domain 4: Monitoring and LoggingA 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.)
Correct answer: D
Explanation
Amazon Athena can query data in Amazon S3 using SQL without loading it into a database, and Amazon QuickSight can generate graphs and dashboards from query results. AWS Glue Data Catalog provides an automated metadata store for the CSV files, minimizing manual effort. Together, these services meet the requirements with the least operational overhead.
Why each option is right or wrong
A. Filter the data through Amazon QuickSight to visualize the data.
QuickSight handles visualization, but it does not by itself provide querying and metadata cataloging.
B. Query the data with Amazon Athena.
Athena provides SQL querying on S3 data, but not dashboards and not the full metadata management workflow alone.
C. Use the AWS Glue Data Catalog as the persistent metadata store.
Glue Data Catalog stores metadata, but it does not perform SQL analysis or create graphs.
D. All of the above
Each of the listed options is a valid answer; all are needed.