A company runs a data warehouse on Amazon Redshift and must record and retain all user and connection activity to satisfy security requirements. Which solution meets this need?
Choose an answer
Tap an option to check your answer.
Correct answer: Create an Amazon S3 bucket. Enable logging for the Amazon Redshift cluster. Specify the S3 bucket in the logging configuration to store the logs..
Why this is the answer
Amazon Redshift cluster logging, specifically audit logging, is designed to capture user and connection activity. The standard and recommended destination for these logs is an Amazon S3 bucket. By enabling logging for the Redshift cluster and configuring it to send logs to S3, you create a durable, scalable, and cost-effective solution for retaining audit data, directly addressing the security requirement. Amazon EFS, Aurora MySQL, and EBS volumes are not natively supported or practical destinations for Redshift audit logs. EFS is a file system for EC2 instances, not a direct Redshift logging target. Aurora MySQL is a relational database, and while logs could theoretically be ingested, it's an overly complex and unsupported method for Redshift audit logs. EBS volumes are block storage attached to EC2 instances and are not a direct or scalable logging solution for Redshift.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed