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 SQL Server 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 Microsoft SQL Server database to Amazon Aurora. The SQL Server database includes a table with employee records, which has a composite primary key consisting of employee ID and department ID. 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 employee.
D
Create a new table for each employee record.
No comments yet.