A company uses Amazon Redshift as its data warehouse solution. The company wants to create a dashboard to view changes to the Redshift users and the…

Comprehensive and Detailed Explanation From Exact Extract:

Amazon Redshift supports audit logging which can be configured to log user activity, including

queries and user changes. The logs can be delivered to an S3 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.

Reference:

Amazon Redshift Audit Logging

Visualizing Logs with Amazon CloudWatch Dashboards