PAS-C01 Migration Practice Question
Exhibit
Refer to the exhibit. Error: "SAP HANA database migration failed: Incompatible character set. Source database uses 'UTF-8', target database uses 'ISO-8859-1'."
A company is using AWS Database Migration Service (DMS) to migrate an SAP HANA database from on-premises to Amazon RDS for SAP HANA. The migration task fails with the error shown. Which step should the administrator take to resolve this?
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
✓
Modify the DMS task to include character set conversion settings.
The error indicates a character set mismatch between the source and target databases. AWS DMS can handle character set conversion if configured correctly. By modifying the DMS task to include character set conversion settings, the administrator can resolve the mismatch without altering the source or creating a new instance. Option A is incorrect because changing the source database character set is unnecessary and could impact other applications. Option C is incorrect because creating a new RDS instance is overkill; the issue lies in the DMS task configuration. Option D is incorrect because AWS Server Migration Service (SMS) is for server-level migration, not database migration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Change the source database character set to ISO-8859-1.
Why it's wrong here
Changing source may break applications.
- ✓
Modify the DMS task to include character set conversion settings.
Why this is correct
DMS supports character set conversion.
- ✗
Create a new RDS instance with the correct character set.
Why it's wrong here
You can modify the existing instance's character set.
- ✗
Use AWS Server Migration Service (SMS) instead of DMS.
Why it's wrong here
SMS is for server-level migration, not database.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every PAS-C01 question from scratch — 1,616 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 PAS-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 PAS-C01 exam.