CLF-C02 · Domain 3: Design Secure Architectures

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.

Launch Interactive Lab in Browser → Browse All 56 AWS Labs

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

VPC Cheatsheet → SUBNET Cheatsheet → IGW Cheatsheet → RTB Cheatsheet → RDS Cheatsheet → SG Cheatsheet → EC2 Cheatsheet → WEBCLIENT

Verification Success Criteria

Diagnostic Starting Point (Spoiler-Free Hint)

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?

Real Solutions Architect Interview Question

Why should production databases always be located in private subnets with no public IP allocation?

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

CLF-01

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-02

Locked-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-04

Single 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-05

S3 Public Access Block Disabled

Enable S3 Block Public Access and enable AES-256 or KMS encryption on the S3 bucket.…

CLF-06

Tight Coupling in Transaction Processing

Decouple the architecture by placing an Amazon SQS queue between the producer and consumer.…

SAA-03

Retail 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.…