AWS Certified Data Engineer – Associate (DEA-C01) — Question 185

A company has a data warehouse in Amazon Redshift. To comply with security regulations, the company needs to log and store all user activities and connection activities for the data warehouse.

Which solution will meet these requirements?

Answer options

• A. Create an Amazon S3 bucket. Enable logging for the Amazon Redshift cluster. Specify the S3 bucket in the logging configuration to store the logs.
• B. Create an Amazon Elastic File System (Amazon EFS) file system. Enable logging for the Amazon Redshift cluster. Write logs to the EFS file system.
• C. Create an Amazon Aurora MySQL database. Enable logging for the Amazon Redshift cluster. Write the logs to a table in the Aurora MySQL database.
• D. Create an Amazon Elastic Block Store (Amazon EBS) volume. Enable logging for the Amazon Redshift cluster. Write the logs to the EBS volume.

Correct answer: A

Explanation

The correct answer is A because Amazon S3 is designed for scalable storage and can efficiently store logs generated by Amazon Redshift. Options B, C, and D are unsuitable as EFS, Aurora MySQL, and EBS are not optimized for logging activities in the same way as S3, making them less effective for this requirement.