nerdexam
Amazon

DBS-C01 · Question #252

A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also…

The correct answer is A. Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a D. Create a new parameter group with the enable_user_activity_logging parameter set to true. AWS CloudWatch Logs are stored indefinitely and CloudWatch Log Insights is used to analyze the logs and query upon them. https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html…

Submitted by mike_84· Mar 6, 2026Monitoring and Troubleshooting

Question

A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis. Which combination of steps should a database specialist take to meet these requirements? (Choose two.)

Options

  • AEdit the database configuration of the cluster by enabling audit logging. Direct the logging to a
  • BEdit the database configuration of the cluster by enabling audit logging. Direct the logging to a
  • CModify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.
  • DCreate a new parameter group with the enable_user_activity_logging parameter set to true.
  • EModify the system table to enable logging for each user.

How the community answered

(22 responses)
  • A
    73% (16)
  • B
    5% (1)
  • C
    14% (3)
  • E
    9% (2)

Explanation

AWS CloudWatch Logs are stored indefinitely and CloudWatch Log Insights is used to analyze the logs and query upon them. https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/WhatIsCloudWatchLogs.html "Log retention - By default, logs are kept indefinitely and never expire. You can adjust the retention policy for each log group, keeping the indefinite retention, or choosing a retention period between 10 years and one day." https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html

Topics

#Amazon Redshift#audit logging#connection logs#user activity logs

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice