Answer-first summary for fast verification
Answer: Keep the JSONB column as is in RDS, as RDS supports JSONB data types.
Keeping the JSONB column as is in RDS leverages the support for JSONB 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 PostgreSQL database to Amazon RDS. The PostgreSQL database includes a table with user profiles, which has a JSONB column for storing user preferences. What approach should be taken to handle the JSONB column during the migration?
A
Convert the JSONB column to a string and store it in a text column in RDS.
B
Flatten the JSONB column and create separate columns for each preference in RDS.
C
Keep the JSONB column as is in RDS, as RDS supports JSONB data types.
D
Remove the JSONB column and store user preferences in a separate table.
No comments yet.