A company uses Amazon Redshift as its data warehouse and wants a dashboard that shows changes to Redshift users and the queries they run. Which combination of steps will achieve this? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Configure the Redshift cluster database audit logging to include user activity logs. Configure Amazon CloudWatch as the target for those logs., Create an Amazon CloudWatch dashboard that includes a log widget. Configure the widget to show user details from the Redshift logs..
Why this is the answer
To track Redshift user changes and queries, you first need to enable database audit logging on the Redshift cluster and specifically include user activity logs. Configuring Amazon CloudWatch as the target for these logs ensures they are centrally collected and accessible. Once the logs are in CloudWatch, you can create an Amazon CloudWatch dashboard. Within this dashboard, a log widget can be added and configured to display the relevant user details and query information directly from the Redshift logs, providing the desired visibility. Incorrect options: Creating a CloudWatch log group and a CloudTrail trail would primarily capture AWS API calls, not detailed Redshift database user activity or queries. Creating an S3 bucket and enabling default audit logging on Redshift to target S3 would store logs in S3, but CloudWatch is a more direct and integrated solution for real-time dashboarding and analysis of logs. Using Lambda and Athena to query logs in S3 is an overly complex solution when CloudWatch Logs directly integrates with CloudWatch Dashboards for this purpose.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed