Answer-first summary for fast verification
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.
Option A is CORRECT because Amazon Redshift supports native logging of user activities and connection attempts through its audit logging feature. These logs can be automatically exported to an Amazon S3 bucket by enabling logging and specifying the target bucket in the Redshift cluster configuration. This approach is secure, scalable, cost-effective, and aligns with regulatory requirements for auditability and traceability. It also minimizes operational overhead by using built-in AWS services.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 59/60
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?
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.
No comments yet.