DOP-C02 Practice Question 99: CloudTrail Lake SQL Investigation
AWS Certified DevOps Engineer – Professional (DOP-C02) · Test 10 · question 9 of 10
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?
Show answer and explanation
Answer:
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