DOP-C02 Practice Question 99: CloudTrail Lake SQL Investigation

AWS Certified DevOps Engineer – Professional (DOP-C02) · Test 10 · question 9 of 10

Monitoring and Loggingmedium

A security team needs to identify which IAM principal deleted a specific Amazon EBS volume two weeks ago, across an organization with dozens of accounts. They want to run a single SQL query against long-retained management event history spanning all member accounts, without having to first pull raw event JSON out of S3 or build a Log Insights query per account's log group.

Which approach fits this requirement?

Select one answer
Show answer and explanation

Answer:

  • A. Create a CloudTrail Lake organization event data store, then run a SQL query filtering eventName = 'DeleteVolume' and the resource identifier against it

CloudTrail Lake stores CloudTrail events in a queryable, managed event data store that supports standard SQL, and an organization event data store aggregates management events from every account in the organization into one place with configurable long-term retention. A single SQL query filtering on the event name and the resource identifier returns the DeleteVolume event along with the calling principal's identity, with no per-account log pulling and no custom partitioning to maintain.

Option B requires searching a separate log group per account and manually merging the output, which does not scale across dozens of accounts and is exactly the manual, per-account effort the requirement wants to avoid.

Option C uses AWS Config to detect that a resource stopped existing, but Config configuration history does not directly name the IAM principal who made the API call; the caller identity comes from CloudTrail, so this is an indirect and less reliable path to the same answer.

Option D would work technically, but it requires the security team to build and maintain their own Athena table definitions, partitions, and cross-account bucket access, which is exactly the undifferentiated setup that CloudTrail Lake's managed event data store removes.

Reference: Working with CloudTrail Lake

Practice Test 10 ›

Study guides for DOP-C02

AWS Service Control Policies Explained: SCPs and DenialsAWS service control policies explained: how SCPs cap permissions, why admins still get access denied, inheritance, deny vs allow lists and the exam traps.
How AI Is Changing Software Jobs: Where to PrepareHow AI is changing software jobs: what history shows, the evidence on junior developers, what Klarna learned, new AI roles and five domains to prepare for.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
Best DevOps certification: AWS, Azure, Google or CKAThe best DevOps certification for your stack: AWS DOP-C02, Azure AZ-400, Google Cloud DevOps Engineer and CKA compared on cost, level and prerequisites.
What Is AWS Lambda? Triggers, Concurrency and Cold StartsWhat is AWS Lambda? How functions run, cold starts, triggers vs event source mappings, concurrency, layers, aliases, pricing and the exam traps.
AWS CloudOps Engineer Associate (SOA-C03) exam guideAWS Certified CloudOps Engineer – Associate (SOA-C03) replaced SysOps Administrator. Format, cost, the five domains, what changed and how to prepare.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is Amazon EC2? Instances, AMIs, EBS and Auto ScalingAmazon EC2 explained: instances, AMIs, instance types, security groups, EBS, Auto Scaling groups and pricing options, with the traps AWS exams set.
SQS vs SNS vs EventBridge on AWSWhen to use an SQS queue, an SNS topic or an EventBridge bus, plus fan-out, FIFO ordering, visibility timeouts and dead-letter queues for AWS exams.