A company has a quarterly customer survey. The survey uses an Amazon EC2 instance that is hosted in a public subnet to host a customer survey website. The company uses an Amazon RDS DB instance that is hosted in a private subnet in the same VPC to store the survey results.
The company takes a snapshot of the DB instance after a survey is complete, deletes the DB instance, and then restores the DB instance from the snapshot when the survey needs to be conducted again. A database specialist discovers that the customer survey website times out when it attempts to establish a connection to the restored DB instance.
What is the root cause of this problem?

A. The VPC peering connection has not been configured properly for the EC2 instance to communicate with the DB instance.

B. The route table of the private subnet that hosts the DB instance does not have a NAT gateway configured for communication with the EC2 instance.

C. The public subnet that hosts the EC2 instance does not have an internet gateway configured for communication with the DB instance.

D. The wrong security group was associated with the new DB instance when it was restored from the snapshot.








 

Suggested Answer: D

Community Answer: D

Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Tutorials.RestoringFromSnapshot.html


This question is in DBS-C01 AWS Certified Database – Specialty Exam
For getting AWS Certified Database – Specialty Certificate


Disclaimers:
The 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.
The website does not contain actual questions and answers from Amazon's Certification Exam.