A company uses Amazon Redshift as its data warehouse solution. The company wants to create a dashboard to view changes to the Redshift users and the queries the users perform.
Which combination of steps will meet this requirement? (Choose two.)
A.
Create an Amazon CloudWatch log group. Create an AWS CloudTrail trail that writes to the CloudWatch log group.
B.
Create a new Amazon S3 bucket. Configure default audit logging on the Redshift cluster. Configure the S3 bucket as the target.
C.
Configure the Redshift cluster database audit logging to include user activity logs. Configure Amazon CloudWatch as the target.
D.
Create an Amazon CloudWatch dashboard that has a log widget. Configure the widget to display user details from the Redshift logs.
E.
Create an AWS Lambda function that uses Amazon Athena to query the Redshift logs. Create an Amazon CloudWatch dashboard that has a custom widget type that uses the Lambda function.
Setting up the default audit log on your Redshift cluster will allow you to record database activity, including user changes and queries performed.
Specifying an Amazon S3 bucket as the destination will store the logs for later analysis.
Using Amazon Athena to query the logs stored in S3 allows you to create custom queries and extract the relevant data.
The Amazon CloudWatch dashboard with a custom AWS Lambda-based widget can display the information directly on the dashboard.
To log users queries you need to include user activity logs which require additional setup on the Redshift cluster. So C, because it is not mentioned on B.
Then to display this logs the only option is D, because E requires the logs to be on S3.
B. Create a new Amazon S3 bucket. Configure default audit logging on the Redshift cluster. Configure the S3 bucket as the target.
E. Create an AWS Lambda function that uses Amazon Athena to query the Redshift logs. Create an Amazon CloudWatch dashboard that has a custom widget type that uses the Lambda function.
Explanation:
To create a dashboard for viewing changes to Amazon Redshift users and the queries they perform, you need to capture the necessary audit logs and process them into a dashboard-friendly format.
You need to use CloudWatch for dashboard, so the target must be CloudWatch. B is wrong.
CloudTrail does not record user queries. A is wrong.
Use Lambda to create your own solution is not recommended, E is wrong.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tdlAws
2 weeks agopma17
2 months agoImpromptu
2 months, 1 week agosiheom
2 months, 2 weeks agouncledana
2 months, 2 weeks agotinyshare
2 months, 3 weeks ago