AWS Certified Data Engineer - Associate
Get started today
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?
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?
Simulated
A
Convert the JSONB column to a string and store it in a text column in RDS.
18.8%
B
Flatten the JSONB column and create separate columns for each preference in RDS.
18.8%
C
Comments
Loading comments...