AWS Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.