AWS Certified Database – Specialty — Question 202

A company wants to migrate its on-premises Oracle database to a managed open-source database engine in Amazon RDS by using AWS Database Migration Service (AWS DMS). A database specialist needs to identify the target engine in Amazon RDS based on the conversion percentage of database code objects such as stored procedures, functions, views, and database storage objects. The company will select the engine that has the least manual conversion effort.

What should the database specialist do to identify the target engine?

Answer options

• 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

Correct answer: B

Explanation

The correct answer is B because the AWS Schema Conversion Tool (AWS SCT) multiserver assessor provides a comprehensive assessment of multiple database instances and their conversion needs, helping identify the target engine with the least manual effort. Option A, while useful, focuses on a single migration assessment report rather than a broader evaluation. Options C and D are related to migration and validation but do not specifically address the conversion effort of database code objects.