exam questions

Exam AWS-SysOps All Questions

View all questions & answers for the AWS-SysOps exam

Exam AWS-SysOps topic 1 question 582 discussion

Exam question from Amazon's AWS-SysOps
Question #: 582
Topic #: 1
[All AWS-SysOps Questions]

A new application runs on Amazon EC2 instances and accesses data in an Amazon RDS database instance. When fully deployed in production, the application fails. The database can be queried from a console on a bastion host. When looking at the web server logs, the following error is repeated multiple times:
*** Error Establishing a Database Connection.
Which of the following may be causes of the connectivity problems? (Choose two.)

  • A. The security group for the database does not have the appropriate egress rule from the database to the web server.
  • B. The certificate used by the web server is not trusted by the RDS instance.
  • C. The security group for the database does not have the appropriate ingress rule from the web server to the database.
  • D. The database is still being created and is not available for connectivity.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
Moon
Highly Voted 2 years, 7 months ago
B & C Security group egress rule is required ONLY if the RDS is initiating traffic. Security Group is statefull, so if traffic is allowed IN, then the response will automatically be allowed OUT! The issue here is, the SG for IN traffic is not allowed, so it is possible issue. second, and by elimination, D is not correct, and A is not correct. So, B is true. B & C.
upvoted 10 times
...
Wmatt
Highly Voted 2 years, 6 months ago
A&C I think. B says web server's certificate not trusted by DB, DB doesn't need to trust the webserver, its the other way around. I don't think they are saying you need two separate security groups (because we know its stateful), its just saying that at least part of that two-way comm is missing
upvoted 5 times
ANS0908431
2 years, 6 months ago
Security Group is stateful, that means return traffic is automatically allowed, regardless of any rules. No need for egress rule. So I think A is not correct.
upvoted 1 times
...
...
albert_kuo
Most Recent 9 months, 4 weeks ago
Selected Answer: CD
Please note that without further information, it is difficult to determine the exact causes of the connectivity problems. Other factors such as network configuration, database configuration, or application-specific issues could also contribute to the problem. Additional troubleshooting and investigation would be required to pinpoint the exact causes.
upvoted 1 times
...
Ghugs
1 year, 3 months ago
I found the same question with an extra answer: E. The port used by the application developer does not match the port specified in the RDS configuration. Could this be the correct missing answer since B may still be questionable?
upvoted 3 times
...
DoTheRightThing
1 year, 4 months ago
Selected Answer: C
Only C is correct. For A to be correct it should be NACL, not SG. B is not correct because the webserver certificate is not involved in this communication. D is not relevant at all
upvoted 1 times
...
Huy
2 years, 5 months ago
Based on the current options, we have to select B&C. Although I don't think the error for SSL/TLS connection is "Error Establishing a Database Connection". It should be something like "SSL connection error".
upvoted 2 times
...
RicardoD
2 years, 6 months ago
B | C are the answers If the SG does not allows traffic coming from EC2, it will not get to RDS DB. (C) (B) can be the other answer if you are using SSL/TLS to encrypt a connection to a DB
upvoted 2 times
...
JGD
2 years, 6 months ago
A and C is correct.. B > Here they are talking about Website SSL not the RDS. D > Data is queried from Bastion.. So database is up and running fine.
upvoted 1 times
JGD
2 years, 6 months ago
reverting my comments back... Answer is B & C A is in correct.. by default full traffic is allowed from the host machine.
upvoted 1 times
...
...
ThoseWereTheDays
2 years, 6 months ago
B & C B: The certificate used by the web server is not trusted by the RDS instance. https://aws.amazon.com/blogs/database/amazon-rds-customers-update-your-ssl-tls-certificates-by-february-5-2020/ What applications are impacted? Any application that connects to an RDS database using SSL/TLS, and which also requires server certificate validation against the application’s trust store (or a hardcoded client certificate) is impacted by this change. What happens if I don’t make the required change by March 5, 2020? If you do not make the change by March 5, 2020, your applications that connect via SSL/TLS and verify that the CA certificate will no longer be able to communicate with their RDS DB instances. C: Connection from Application to RDS, so ingress rule is correct.
upvoted 4 times
...
sen12
2 years, 6 months ago
It is C & D. When ingress rules are not setup properly or when the DB instance is still being created and available for connectivity. The error clearly says: *** Error Establishing a Database Connection*** Either the db is not available or security group rules are not setup properly.
upvoted 1 times
nicat
2 years, 6 months ago
"The database can be queried from a console on a bastion host." So D is wrong because bastion host can be queried from bastion host.
upvoted 1 times
nicat
2 years, 6 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html B is true. Because You can use SSL certificate for RDS connections. AND C is true. RDS security group needs ingress rule for accepting connections.
upvoted 1 times
...
...
...
wshyang
2 years, 6 months ago
B doesn't seem right too, why does the database need to trust the web server certificate?
upvoted 4 times
...
karmaah
2 years, 7 months ago
Must be b & c.
upvoted 1 times
...
saumenP
2 years, 7 months ago
if you go by elimination rule... D is not correct, as you could query the database. B is certificate related,
upvoted 1 times
...
jxhyxxclyp
2 years, 7 months ago
why a is right?
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago