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 51 discussion

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

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

  • A. Log in to the host and run the rm $PGDATA/pg_logs/* command
  • B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
  • C. Create a ticket with AWS Support to have the logs deleted
  • D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by BillyMadison at July 22, 2020, 6:33 p.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
BillyMadison
Highly Voted 3 years, 7 months ago
I cant find anything for the other answers, so I'm going with B based off https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.Concepts.PostgreSQL.html "To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days)." "If storage gets too low, Aurora might delete compressed PostgreSQL logs before the retention period expires. If logs are deleted early, you get a message like the following. The oldest PostgreSQL log files were deleted due to local storage constraints."
upvoted 7 times
trietnv
2 years, 10 months ago
Reason: DB logs (error files) that are retained for too long. Because by default, PostgreSQL error log files have a retention value of 4,320 minutes (three days). Large log files can use more space because of higher workloads. You can change the retention period for system logs using the rds.log_retention_period parameter in the DB parameter group associated with your DB instance. For example, if you set the value to 1440, then logs are retained for one day Ref: https://aws.amazon.com/premiumsupport/knowledge-center/diskfull-error-rds-postgresql/
upvoted 1 times
...
...
adelcold
Most Recent 1 year, 10 months ago
Selected Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.PostgreSQL.html
upvoted 1 times
...
redman50
2 years, 1 month ago
In this scenario, the company is facing a low storage issue due to additional logs. To address this issue, they can rotate the logs to free up storage space using the stored procedure rds_rotate_error_log(). This procedure rotates the current log file and starts a new one. The rotated logs are compressed and stored in the log directory, freeing up space in the main storage. Option A is incorrect because removing log files manually is not recommended, as it may cause issues and loss of data. Option B is incorrect because changing the log retention period will not delete the existing logs immediately, and the company needs to wait for up to 24 hours for the logs to be deleted. Option C is incorrect because AWS support does not provide log deletion services.
upvoted 3 times
jitesh_k
1 year, 5 months ago
There is no function named rds_rotate_error_log(). It is just a distractor. Check this link: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.PostgreSQL.html
upvoted 1 times
...
...
SachinGoel
2 years, 7 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
novice_expert
3 years ago
Selected Answer: B
reduce rds.log_retention_period parameter and wait
upvoted 2 times
...
tugboat
3 years, 2 months ago
Selected Answer: B
correct
upvoted 1 times
...
AmitB
3 years, 4 months ago
B is correct Answer. To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days). The maximum value is 10,080 (seven days).
upvoted 3 times
...
guru_ji
3 years, 6 months ago
B is Correct. ==> Anyone planning for exam? We can share study material with each other, it would be beneficial for both. You can email me on "awsdbguru at gmail"
upvoted 3 times
...
guru_ji
3 years, 6 months ago
Correct Answer is ==>> B any idea how much Q we will get in real exam from Q available here? anyone is preparing for this exam and want to do group study with us, comment with mail_id.
upvoted 2 times
...
LMax
3 years, 6 months ago
My choice is B
upvoted 2 times
...
AWSCert2020
3 years, 6 months ago
B here The SELECT rds_rotate_error_log() does not exist on RDS
upvoted 2 times
...
BillyC
3 years, 7 months ago
B is correct
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago