Google Cloud Professional Cloud Database Engineer — Question 93

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

Answer options

• 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).

Correct answer: B, E

Explanation

The correct answers are B and E because tables without a primary key can cause issues during migration, as primary keys are essential for data integrity. Additionally, knowing whether the database uses customer-managed encryption keys (CMEK) is crucial for compliance and security considerations. Options A, C, and D are not as critical in assessing migration limitations in this context.