Google Professional Data Engineer Question 49
Select 3Google Cloud PlatformYou are tasked with migrating an on-premises Oracle database to Google Cloud. The database contains sensitive financial data, requires high availability, and must ensure minimal downtime during the migration. Which considerations should you prioritize when designing the migration strategy?
- A
Using Database Migration Service to enable a near-zero downtime migration.
- B
Encrypting data in transit using Cloud Key Management Service (KMS).
- C
Selecting a high-availability configuration for the target database on Google Cloud.
- D
Manually exporting all database tables and re-importing them into Cloud SQL.
- E
Configuring a cold-line storage bucket for temporary data during the migration.
Show answer and explanation
Correct answers: A, B, C
Explanation
To ensure a successful migration of a critical, high-availability database containing sensitive data, you must prioritize tools and approaches that minimize downtime, secure data in transit, and ensure high availability on the target platform. Database Migration Service, encryption during data transfer, and high-availability configurations for the target database directly address these requirements, making them the correct considerations.
- A. Correct.
Using Database Migration Service is critical for minimizing downtime during the migration process, especially for databases requiring high availability.
- B. Correct.
Encrypting data in transit ensures the sensitive financial data remains secure during the migration, aligning with compliance and security requirements.
- C. Correct.
Ensuring the target database is configured with high availability is essential for maintaining uptime and resilience post-migration.
- D. Incorrect.
Manually exporting and importing tables is error-prone and time-consuming, making it unsuitable for a high-availability, low-downtime migration scenario.
- E. Incorrect.
Cold-line storage is designed for infrequently accessed data and is not suitable for temporary data during an active migration process.