DEA-C01 Practice Question 97: Glue JDBC Self Referencing Security Group
AWS Certified Data Engineer – Associate (DEA-C01) · Test 10 · question 7 of 10
An AWS Glue ETL job uses a Glue connection to read from an Amazon RDS database in a private subnet. The job fails because it cannot connect to the database. The database's security group allows inbound traffic only on the database port from the application subnet, and the connection uses that same security group. Which change should the data engineer make to the security group?
Show answer and explanation
Answer:
AWS documents that to let Glue components communicate when they access a data store in a VPC, you *"specify a security group with a self-referencing inbound rule for all TCP ports."* Such a rule restricts the source to the same security group, and *"a self-referencing rule will not open the VPC to all networks."* If outbound traffic is restricted, matching outbound rules are also needed (option D).
- A is wrong because opening the database port to the whole internet is unsafe, and it does not provide the self-referencing rule that Glue components need to talk to each other. - B is wrong because a NAT gateway provides outbound internet access. The connection to the database stays inside the VPC, so the missing rule is not an internet-routing problem. - C is wrong because a public address exposes the database to the internet and does not fix the Glue-to-Glue communication rule.
Reference: Setting up Amazon VPC for JDBC connections to Amazon RDS data stores from AWS Glue