Answer-first summary for fast verification
Answer: Keep the JSON column as is in RDS, as RDS supports JSON data types.
Keeping the JSON column as is in RDS leverages the support for JSON data types in RDS, allowing for efficient querying and manipulation of the data. This approach maintains the integrity of the data model and simplifies the migration process.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is using AWS DMS to migrate a MySQL database to Amazon RDS. The MySQL database includes a table with product inventory, which has a JSON column for storing product attributes. What approach should be taken to handle the JSON column during the migration?
A
Convert the JSON column to a string and store it in a text column in RDS.
B
Flatten the JSON column and create separate columns for each attribute in RDS.
C
Keep the JSON column as is in RDS, as RDS supports JSON data types.
D
Remove the JSON column and store product attributes in a separate table.
No comments yet.