Exam AWS Certified Database - Specialty topic 1 question 264 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 264
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company wants to migrate its on-premises Oracle database to Amazon RDS for PostgreSQL by using AWS Database Migration Service (AWS DMS). A database specialist needs to evaluate the migration task settings and data type conversion in an AWS DMS task.

What should the database specialist do to identify the optimal migration method?

A. Use the AWS Schema Conversion Tool (AWS SCT) database migration assessment report
B. Use the AWS Schema Conversion Tool (AWS SCT) multiserver assessor.
C. Use an AWS DMS pre-migration assessment
D. Use the AWS DMS data validation tool

Show Suggested Answer

Suggested Answer: C 🗳️

by Sab at Nov. 30, 2022, 11:13 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Pranava_GCP

1 year, 9 months ago

Selected Answer: C

C. AWS DMS pre-migration assessment "With the current release of this feature, the task assessment report includes information about unsupported and partially supported data types in AWS DMS. The assessment process scans all the source data types in the tables that are to be migrated. It then compares this list with the supported data types for this type of database and generates a report. This report indicates the data types that are not supported or that are partially supported for the present database migration." https://aws.amazon.com/blogs/database/migration-validation-part-1-introducing-migration-assessment-in-aws-database-migration-service/#:~:text=With%20the%20current,present%20database%20migration.

upvoted 1 times

...

aviathor

2 years ago

Selected Answer: C

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.AssessmentReport.html

upvoted 3 times

...

clarksu

2 years, 1 month ago

Selected Answer: C

Key word: evaluate the migration task settings and data type conversion Per : Enabling and working with premigration assessments for a task https://docs.aws.amazon.com/zh_cn/dms/latest/userguide/CHAP_Tasks.AssessmentReport.html Quote: Each individual assessment evaluates a specific element of a supported relational source or target database depending on considerations such as the migration type, supported objects, index configuration, and other task settings, such as table mappings that identify the schemas and tables to migrate. Supported by: https://aws.amazon.com/blogs/database/migration-validation-part-1-introducing-migration-assessment-in-aws-database-migration-service/ Quote: AWS DMS does a great job of helping you move your data between multiple supported sources and targets. However, migrations can be difficult, especially when you’re moving from one database engine to another (known as a heterogeneous migration).

upvoted 3 times

...

backbencher2022

2 years, 2 months ago

Selected Answer: A

A is the correct answer. Option C makes more sense in case of homogeneous migration but this is a case of heterogenous migration

upvoted 3 times

...

guau

2 years, 3 months ago

Selected Answer: C

I will go with C https://aws.amazon.com/blogs/database/migration-validation-part-1-introducing-migration-assessment-in-aws-database-migration-service/

upvoted 4 times

...

Aleolived

2 years, 3 months ago

Selected Answer: A

A - Because the DMS don't valide diferents database types.

upvoted 2 times

guau

2 years, 3 months ago

Not totally agree https://aws.amazon.com/blogs/database/migration-validation-part-1-introducing-migration-assessment-in-aws-database-migration-service/

upvoted 2 times

Mintwater

2 years, 2 months ago

To identify the optimal migration method for migrating an on-premises Oracle database to Amazon RDS for PostgreSQL by using AWS DMS, the database specialist should use the AWS Schema Conversion Tool (AWS SCT) database migration assessment report. An AWS DMS pre-migration assessment can be used to check the source database for compatibility with AWS DMS, but it does not provide a recommended migration approach.

upvoted 1 times

...