DEA-C01 Data Operations and Support Practice Question
A data engineer is troubleshooting an AWS Glue job that reads from an Amazon RDS for PostgreSQL database using a JDBC connection. The job fails with the error 'java.sql.SQLException: No suitable driver'. Which TWO actions should the engineer take to resolve this issue? (Select TWO.)
⚠ Common exam trap
Candidates often confuse network connectivity issues (VPC/security groups) with classpath/driver loading errors, leading them to select Option B instead of recognizing that 'No suitable driver' is a Java classloading problem, not a network one.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Verify that the connection string in the job's JDBC URL uses the correct format and includes the driver class
The 'No suitable driver' error in JDBC indicates that the driver class specified in the JDBC URL is either missing or incorrect. For PostgreSQL, the JDBC URL must follow the format 'jdbc:postgresql://host:port/database' and the driver class must be 'org.postgresql.Driver'. If the URL is malformed or the driver class is not properly referenced, the Glue job cannot load the driver, leading to this specific SQLException.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Verify that the connection string in the job's JDBC URL uses the correct format and includes the driver class
Why this is correct
The JDBC URL must be correctly formatted, e.g., 'jdbc:postgresql://...'.
- ✗
Check that the Glue job's VPC and security groups allow outbound traffic to the RDS instance
Why it's wrong here
Network issues cause timeouts, not 'No suitable driver'.
- ✗
Restart the Glue job with a higher timeout value
Why it's wrong here
Restarting does not fix missing driver; the job will fail again.
- ✓
Include the PostgreSQL JDBC driver JAR as a dependent library in the Glue job
Why this is correct
Glue jobs need the driver JAR to be explicitly provided for non-AWS databases.
- ✗
Update the IAM role associated with the Glue job to allow 'rds:*' permissions
Why it's wrong here
IAM permissions are for AWS API calls, not for driver loading.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every DEA-C01 question from scratch — 1,711 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.