Answer-first summary for fast verification
Answer: Identify whether the database has over 512 tables., Identify all tables that do not have a primary key.
When migrating a PostgreSQL database to Cloud SQL using Database Migration Service, it's important to assess known limitations to ensure a smooth migration. Two critical factors to consider are: 1) The number of tables in the database, as Cloud SQL has a limitation on the number of tables (option A). Databases with over 512 tables may face issues. 2) Tables without a primary key (option B), as primary keys are essential for replication and ensuring data integrity during the migration process. Options C, D, and E, while important for database design and security, are not directly related to known limitations of the Database Migration Service for PostgreSQL to Cloud SQL migrations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What steps should you take to evaluate the known limitations when migrating a PostgreSQL database from another cloud provider to Cloud SQL using Database Migration Service? (Select two.)
A
Identify whether the database has over 512 tables.
B
Identify all tables that do not have a primary key.
C
Identity all tables that do not have at least one foreign key.
D
Identify whether the source database is encrypted using pgcrypto extension.
E
Identify whether the source database uses customer-managed encryption keys (CMEK).