A company has multiple AWS accounts that are in an organization in AWS Organizations. The company needs to store AWS account activity and query the data from a central location by using SQL. Which sol

Creating individual CloudTrail trails in each account does not inherently provide a centralized storage solution for querying, requiring additional services to aggregate and enable SQL queries.

Option B directly meets all requirements by using a delegated administrator account to create a single AWS CloudTrail Lake data store, which natively aggregates CloudTrail events from across the entire organization and allows querying of this data directly using SQL.

This option suggests creating a CloudTrail trail, which stores logs in S3, requiring Amazon Athena or another service for SQL querying, rather than the integrated SQL query capabilities of CloudTrail Lake.

Deploying separate CloudTrail Lake data stores in each account defeats the purpose of centralizing event data for querying from a single location.