A company is planning to set up a Redshift cluster in AWS. There is a requirement to ensure that logs for the cluster are in place for auditing purposes. Which of the following logs would be available to you? Choose 3 answers from the options given below.

Answer options:

A.Connection Logs
B.Transaction Logs
C.User Logs
D.User Activity Logs

Correct Answers: A, C and D
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.
Option B is invalid since transaction logs are not available.
For more information on database auditing, please visit the below URL-
https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html