A company uses Amazon Redshift as its data warehouse solution.

Comprehensive and Detailed Explanation From Exact Extract:

Amazon Redshift supportsaudit loggingwhich can be configured to log user activity, including queries and user changes. The logs can be delivered to anS3 bucket(Option B), which is the standard location for Redshift audit logs.

While Redshift can send some logs to CloudWatch, the native audit logging is typically routed to S3. Creating a CloudWatch dashboard with a log widget (Option D) allows visualization of user activities from logs ingested into CloudWatch Logs or through custom processing.

Option A is invalid because CloudTrail does not capture Redshift query logs directly. Option C incorrectly assumes Redshift audit logs can be delivered directly to CloudWatch. Option E adds complexity by requiring Lambda and Athena unnecessarily when direct visualization in CloudWatch is simpler.