DEA-C01 Data Operations and Support Practice Question
A data engineer is troubleshooting a failed AWS Glue job that reads from an Amazon RDS for MySQL table. The error message indicates 'java.sql.SQLException: No suitable driver'. What is the most likely cause?
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
✓
The MySQL JDBC driver JAR is not included in the Glue job's dependencies.
The MySQL JDBC driver must be included in the Glue job's dependent JARs or as a Python module. Option B is incorrect because the driver class name is correct; the driver JAR is missing. Option C is incorrect because the error is about driver, not connection. Option D is incorrect because subnet routing does not affect driver loading.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The MySQL JDBC driver JAR is not included in the Glue job's dependencies.
Why this is correct
Glue needs the JDBC driver in its classpath to connect to MySQL.
- ✗
The Glue job is using the wrong JDBC driver class name.
Why it's wrong here
'No suitable driver' indicates driver not found, not wrong class.
- ✗
The Glue job's VPC subnet does not have a route to the RDS instance.
Why it's wrong here
Network issues give connection errors, not driver errors.
- ✗
The RDS instance is not publicly accessible.
Why it's wrong here
That would cause a connection timeout, not driver error.
Visual reference
Go deeper
Related to this question
About these practice questions
This DEA-C01 question is part of Courseiva's 1,711-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.