Amazon Web Services AWS Certified Data Engineer Data-Engineer-Associate Question # 27 Topic 2 Discussion

Problem Analysis:

The company must log alluser activitiesandconnection activitiesin Amazon Redshift for security compliance.

Key Considerations:

Redshift supportsaudit logging, which can be configured to write logs to an S3 bucket.

S3 provides durable, scalable, and cost-effective storage for logs.

Solution Analysis:

Option A: S3 for Logging

Standard approach for storing Redshift logs.

Easy to set up and manage with minimal cost.

Option B: Amazon EFS

EFS is unnecessary for this use case and less cost-efficient than S3.

Option C: Aurora MySQL

Using a database to store logs increases complexity and cost.

Option D: EBS Volume

EBS is not a scalable option for log storage compared to S3.

Final Recommendation:

EnableRedshift audit loggingand specify anS3 bucketas the destination.