After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?
A.
The restored DB instance does not have Enhanced Monitoring enabled
B.
The production DB instance is using a custom parameter group
C.
The restored DB instance is using the default security group
D.
The production DB instance is using a custom option group
how do we know what parameter or option groups source rds is using so assuming security group mismatch because even parameter or option group mismatch also if securrity group is correct one we can make the connections
When you restore a DB instance, the default virtual private cloud (VPC), DB subnet group, and VPC security group are associated with the restored instance, unless you choose different ones.
C and B both have incomplete info, would go with B assuming that PROD is the source, and custom parameter group not selected or changed from default for restored one
x A. Enhanced Monitoring enabled (unrelated - for performance check)
B. The production DB instance is using a custom parameter group (would be correct if it was the source)
x C. The restored DB instance is using the default security group (but would not be issue if source also had default)
x D. The production DB instance is using a custom option group (unrelated - it can specify features, called options, that are available for a particular Amazon RDS DB instance)
https://aws.amazon.com/about-aws/whats-new/2018/10/specify-parameter-groups-when-restoring-amazon-rds-backups/
Correction: Ans is C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html
When you restore a DB instance, the default virtual private cloud (VPC), DB subnet group, and VPC security group are associated with the restored instance, unless you choose different ones.
C, but B........
Parameter group considerations
We recommend that you retain the DB parameter group for any DB snapshots you create, so that you can associate your restored DB instance with the correct parameter group.
The default DB parameter group is associated with the restored instance, unless you choose a different one. No custom parameter settings are available in the default parameter group.
You can specify the parameter group when you restore the DB instance.
C. The restored DB instance is using the default security group
This is likely the cause of the problem since security groups control the connectivity to the DB instance.
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.
learnaws
Highly Voted 3 years, 8 months agoBillyMadison
3 years, 8 months agoBillyC
Highly Voted 3 years, 8 months agoSathish_dbs
Most Recent 1 year, 8 months agonarvaez
1 year, 8 months agosaikarthikeya777
1 year, 11 months agoKodoma
2 years agoChirantan
2 years, 11 months agonovice_expert
3 years, 1 month agonovice_expert
3 years, 1 month agokret
3 years, 1 month agosoyyodario
3 years, 4 months agoChauPhan
3 years, 7 months agogelsm
3 years, 7 months agogelsm
3 years, 7 months agoLMax
3 years, 7 months agomyutran
3 years, 7 months agokubilay
3 years, 7 months agoJobinAkaJoe
3 years, 8 months agoAshoks
3 years, 8 months ago