The security team needs to run ad‑hoc SQL queries against months of CloudTrail logs stored in S3 to find every instance of a specific IAM user deleting S3 objects. Which solution provides a serverless, on‑demand query capability?
A. Load CloudTrail logs into Amazon RDS and use SQL queries to search by event type and user identity for the required analysis.
B. Use Amazon Athena to define a table over the S3 CloudTrail log location and query with SQL using filters on eventName and userIdentity.
C. Stream CloudTrail logs to Amazon OpenSearch Service and use Kibana to filter by event type and user identity in the dashboard.
D. Use AWS CloudTrail Lake, which requires logs to be re-ingested from S3 before SQL queries can be executed against them.
Amazon Athena lets you define a table over the CloudTrail logs in S3 and query them directly with SQL, without provisioning any infrastructure.