Answer-first summary for fast verification
Answer: Keep the composite primary key as is in Aurora.
Maintaining the composite primary key in Aurora ensures that the data integrity and relationships established in the original MySQL database are preserved. This approach allows for consistent querying and data management across the migration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is using the AWS Schema Conversion Tool (AWS SCT) to migrate a MySQL database to Amazon Aurora. The MySQL database includes a table with customer orders, which has a composite primary key consisting of customer ID and order date. What steps should be taken to ensure the schema conversion maintains data integrity in Aurora?
A
Convert the composite primary key to a single primary key in Aurora.
B
Keep the composite primary key as is in Aurora.
C
Remove the primary key and use a unique identifier for each order.
D
Create a new table for each customer order.
No comments yet.