‹ All DEA-C01 questions

DEA-C01 Practice Question 97: Glue JDBC Self Referencing Security Group

AWS Certified Data Engineer – Associate (DEA-C01) · Test 10 · question 7 of 10

Data Operations and Supportmedium

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?

Select one answer
Show answer and explanation

Answer:

  • D. Allow all TCP traffic from the security group to itself.

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

Practice Test 10 ›

Study guides for DEA-C01