A team has setup a Redshift cluster for a company. There is a requirement from the IT Security department to get the list of all IP addresses which establish connections to the Redshift cluster. Which of the following can help achieve this requirement?

Answer options:

A.Get this information from Cloudtrail logs
B.Get this information from connection logs in Redshift
C.Get this information from users logs in Redshift
D.Get this information from VPC Flow Logs

Answer: B
The AWS Documentation mentions the following
Amazon Redshift logs information in the following log files:
Connection log — logs authentication attempts, and connections and disconnections.
User log — logs information about changes to database user definitions.
User activity log — logs each query before it is run on the database.
The connection and user logs are useful primarily for security purposes. You can use the connection log to monitor information about the users who are connecting to the database and the related connection information, such as their IP address, when they made the request, what type of authentication they used, and so on. You can use the user log to monitor changes to the definitions of database users.
Since the documentation clearly mentions how this can be achieved, the other options are invalid
For more information on database auditing, please visit the url
https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html