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?

Simulated

Convert the composite primary key to a single primary key in Aurora.

22.2%

Keep the composite primary key as is in Aurora.

55.6%

Remove the primary key and use a unique identifier for each employee.

11.1%

Create a new table for each employee record.

11.1%

AWS Certified Data Engineer - Associate