exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 136 discussion

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

A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance. The DB instance is deployed in a private DB subnet.
What is the MOST restrictive configuration for the DB instance security group?

  • A. Only allow incoming traffic from the sg-application-servers security group on port 3306.
  • B. Only allow incoming traffic from the sg-application-servers security group on port 443.
  • C. Only allow incoming traffic from the subnet of the application servers on port 3306.
  • D. Only allow incoming traffic from the subnet of the application servers on port 443.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
shantest1
Highly Voted 3 years, 7 months ago
A. Answer Database port 3306 and better to allow only the specific subnet instead of the entire subnet.
upvoted 14 times
novice_expert
2 years, 11 months ago
Do we allow traffic from security group OR from resources that are assigned to the same security group ?
upvoted 1 times
...
...
Pranava_GCP
Most Recent 1 year, 8 months ago
Selected Answer: A
A. Only allow incoming traffic from the sg-application-servers security group on port 3306.
upvoted 1 times
Pranava_GCP
1 year, 7 months ago
Because 1) port 3306 is default port number for mySQL 2) a security group has to be explicitly assigned to an EC2 instance.
upvoted 1 times
...
...
aviathor
1 year, 11 months ago
Selected Answer: A
Where on earth do these "Correct answers" come from? Allowing connections only from members of sg-application-servers is more restrictive than allowing traffic from the whole subnet. 3306 is probably the correct port for RDS. Therefore A
upvoted 2 times
...
Bernardes
2 years, 5 months ago
I'll go with C: Security groups contains rules allowing or denying access to specified IP address and TCP Ports. Then they are associated with resources (such as ec2, rds, etc). The question says that EC2 use the security group sg-application-servers. That is the sg-application-servers contains the rules that at this moment make the ec2 communication work. To allow the RDS instance talk with this ec2, is necessary to create a SG and specify the address of the ec2 instances in the ingress rules, referencing the port 3306. Or, allow the traffic from the entire subnet at this same port. I've read the security group doc again and dont see nothing about grouping aws resources to reference as some kind of "security resource group" as the A answer say. https://docs.aws.amazon.com/vpc/latest/userguide/VPC_SecurityGroups.html
upvoted 1 times
im_not_robot
2 years, 2 months ago
C is wrong. Because allow the whole subnets mean allow all application on that subnet --> not secure. FYI: security group doesn't have 'Deny' rule. A is the answer. Security A allow traffic from Security B mean that Security A allow all resources using Security B
upvoted 1 times
...
...
novice_expert
2 years, 11 months ago
Selected Answer: A
A. Only allow incoming traffic from the sg-application-servers security group on port 3306.
upvoted 3 times
...
awsmonster
3 years, 3 months ago
Ans: A
upvoted 1 times
...
Hits_23
3 years, 5 months ago
Answer A. most restrictive approach is to allow only incoming connections from SG of EC2 instance on port 3306
upvoted 1 times
...
Suresh108
3 years, 6 months ago
AAAAAAAAAAAA
upvoted 2 times
...
Aesthet
3 years, 6 months ago
A final answer
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