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

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

A financial company is hosting its web application on AWS. The application's database is hosted on Amazon RDS for MySQL with automated backups enabled.
The application has caused a logical corruption of the database, which is causing the application to become unresponsive. The specific time of the corruption has been identified, and it was within the backup retention period.
How should a database specialist recover the database to the most recent point before corruption?

  • A. Use the point-in-time restore capability to restore the DB instance to the specified time. No changes to the application connection string are required.
  • B. Use the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.
  • C. Restore using the latest automated backup. Change the application connection string to the new, restored DB instance.
  • D. Restore using the appropriate automated backup. No changes to the application connection string are required.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by leunamE at Nov. 12, 2021, 1:21 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
johnconnor
Highly Voted 3 years, 6 months ago
It has to be B "Please note: When you perform a restore operation to a point in time or from a DB Snapshot, a new DB Instance is created with a new endpoint (the old DB Instance can be deleted if so desired). This is done to enable you to create multiple DB Instances from a specific DB Snapshot or point in time."
upvoted 17 times
...
Pranava_GCP
Most Recent 1 year, 9 months ago
Selected Answer: B
B. Use the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.
upvoted 1 times
...
mbadioum
2 years, 2 months ago
B is right https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html
upvoted 1 times
...
praffuln
2 years, 5 months ago
Selected Answer: B
B - New Instance Creates, need to change connection string from application. A - Not correct. Not inplace PITR, this feature support in Aurora Mysql
upvoted 1 times
...
novice_expert
3 years, 1 month ago
Selected Answer: B
restore operation to a point in time or from a DB Snapshot, a new DB Instance is created
upvoted 4 times
...
RotterDam
3 years, 3 months ago
Got this question in my exam. (i cleared it). B is correct
upvoted 1 times
...
tugboat
3 years, 3 months ago
Selected Answer: B
Point app to restored instance
upvoted 2 times
...
szl0144
3 years, 4 months ago
I vote C
upvoted 1 times
...
jove
3 years, 5 months ago
Selected Answer: B
PIT restore requires a new instance to be created. Hence, the answer is B
upvoted 4 times
...
Justu
3 years, 6 months ago
B is the correct one
upvoted 1 times
...
leunamE
3 years, 6 months ago
Option B.
upvoted 2 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