ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 339 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 339
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company has an Amazon Redshift cluster with database audit logging enabled. A security audit shows that raw SQL statements that run against the Redshift cluster are being logged to an Amazon S3 bucket. The security team requires that authentication logs are generated for use in an intrusion detection system (IDS), but the security team does not require SQL queries.

What should a database specialist do to remediate this issue?

  • A. Set the use_fips_ssl parameter to true in the database parameter group.
  • B. Turn off the query monitoring rule in the Redshift cluster's workload management (WLM).
  • C. Set the enable_user_activity_logging parameter to false in the database parameter group.
  • D. Disable audit logging on the Redshift cluster.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by marll88 at Nov. 26, 2023, 5:21 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
KikiNoviandi
1 year, 8 months ago
Selected Answer: C
Set the enable_user_activity_logging parameter to false in the database parameter group.
upvoted 2 times
...
Ram_xyz
1 year, 8 months ago
Selected Answer: C
https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html#db-auditing-enable-logging
upvoted 4 times
...
marll88
1 year, 8 months ago
I think B. The security team does not need SQL queries. Turn off query monitoring.
upvoted 1 times
...
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.

SaveCancel