Examice

Exam SAP-C02 All QuestionsBrowse all questions from this exam

Question 501

A company needs to migrate its on-premises database fleet to Amazon RDS. The company is currently using a mixture of Microsoft SQL Server, MySQL, and Oracle databases. Some of the databases have custom schemas and stored procedures.

Which combination of steps should the company take for the migration? (Choose two.)

Use Migration Evaluator Quick Insights to analyze the source databases and to identify the stored procedures that need to be migrated.

Use AWS Application Migration Service to analyze the source databases and to identify the stored procedures that need to be migrated.

Use the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for changes that are required

Use AWS Database Migration Service (AWS DMS) to migrate the source databases to Amazon RDS.

Use AWS DataSync to migrate the data from the source databases to Amazon RDS.

Correct Answer: C, D

To migrate a variety of databases with custom schemas and stored procedures to Amazon RDS, the company should use the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS). AWS SCT can analyze the source databases and identify necessary changes, including schema and stored procedure modifications. AWS DMS is designed to facilitate the migration of databases to Amazon RDS, ensuring that data is transferred accurately and efficiently. This combination ensures comprehensive analysis and effective migration of the databases.

Discussion

ebbff63Options: CD

Answer CD

awsazOptions: CD

C and D

MoghiteOptions: CD

answer CD

AhmedSalemOptions: CD

Answer CD

kupo777

B AWS Database Migration Service can convert Oracle and SQL Server to Amazon RDS for MySQL and Amazon RDS for PostgreSQL stored procedures. D AWS Database Migration Service (AWS DMS) performs data migration. The answer is DB.