DBS-C01 Deployment and Migration Practice Question
Network Topology
Refer to the exhibit. You run the command and get the output shown. The database is an RDS for MySQL instance. You need to connect to it from an EC2 instance in the same VPC. Which connection string should be used?
⚠ Common exam trap
It's easy for candidates to confuse the default ports for MySQL (3306) and PostgreSQL (5432) or omit the account ID from the RDS endpoint, leading them to choose an option with an incorrect port or an incomplete hostname.
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
✓
mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u admin -p
The command uses the MySQL client (`mysql`) with the correct fully qualified domain name (FQDN) of the RDS instance, which includes the AWS account ID and region, and the default MySQL port 3306. The `-u admin -p` flags specify the master username and prompt for a password, which is the standard way to connect to an RDS for MySQL instance from an EC2 instance in the same VPC.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u admin -p
Why this is correct
Correct endpoint and port.
- ✗
psql -h mydb.123456789012.us-east-1.rds.amazonaws.com -p 5432 -U admin
Why it's wrong here
psql is for PostgreSQL.
- ✗
mysql -h mydb.us-east-1.rds.amazonaws.com -P 3306 -u admin -p
Why it's wrong here
Incorrect endpoint.
- ✗
mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 5432 -u admin -p
Why it's wrong here
Port 5432 is for PostgreSQL.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 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 DBS-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 DBS-C01 exam.