Public Database Exposure Vulnerability
A junior administrator placed an RDS database in a public subnet with publiclyAccessible: true and a 0.0.0.0/0 ingress rule.
Lab Objective
Move or configure RDS to be in a private subnet, disable public accessibility, and restrict ingress exclusively to the app layer.
Exam Track & Type
Cloud Practitioner (CLF) (CLF-C02) · Live Outage Troubleshooting Drill
FinOps & Cost Impact
Mitigating database attacks avoids catastrophic ransomware remediation costs and eliminates unmetered internet ingress DDoS traffic.
AWS Services Involved
Verification Success Criteria
- RDS publiclyAccessible is set to false.
- Public 0.0.0.0/0 ingress rule removed from database security group.
- Database resides in a private subnet.
Diagnostic Starting Point (Spoiler-Free Hint)
Real Solutions Architect Interview Question
Frequently Asked Questions
How do I troubleshoot "Public Database Exposure Vulnerability" in AWS?
Why does the AWS Well-Architected Security Pillar require production relational databases to never reside in public subnets or have public IPs? How should database ingress be isolated exclusively to internal application tiers?
Which AWS certification exam covers this architecture scenario?
This interactive lab maps directly to CLF-C02 (Cloud Practitioner (CLF)) under Domain 3: Design Secure Architectures.
Do I need an AWS account or credit card to practice this lab?
No. CloudTracer runs a stateful VPC packet engine locally in your browser so you can debug Route Tables, Security Groups, NACLs, and target groups with $0 AWS cloud spend.
Related CLF-C02 Troubleshooting Labs
Missing Internet Gateway Route
Attach or route default outbound traffic 0.0.0.0/0 to the Internet Gateway in the public route table.…
CLF-02Locked-Out Security Group Ingress
Add an inbound rule allowing TCP port 80 from 0.0.0.0/0 to the web instance Security Group.…
CLF-04Single Point of Failure (Single-AZ)
Add a secondary subnet in us-east-1b and front instances with an Application Load Balancer across both Availability…
CLF-05S3 Public Access Block Disabled
Enable S3 Block Public Access and enable AES-256 or KMS encryption on the S3 bucket.…
CLF-06Tight Coupling in Transaction Processing
Decouple the architecture by placing an Amazon SQS queue between the producer and consumer.…
SAA-03Retail Banking PCI Audit: Stateless NACL Ephemeral Drop
Add an outbound NACL rule permitting return ephemeral traffic (TCP 1024-65535) to 0.0.0.0/0.…