3.1 Design and Implement Data Migration and Replication PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   What is the purpose of reverse replication from Google Cloud to the source database?

   • ATo speed up the initial data transfer to Google Cloud
   • BTo convert the source schema to match the target
   • CTo delete the source database after migration
   • DTo keep the source database synchronized with changes made in Google Cloud during and after migration
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A company is migrating a critical 10 TB Oracle database to Cloud SQL for PostgreSQL. The business has a strict requirement that the migration must not exceed a 2-hour downtime window, but the team has only tested the migration on a small sample and is unsure if the full migration will complete in time. What is the best strategy to mitigate the risk of exceeding the downtime window?

   • APerform a full test migration on a production-sized dataset before the actual cutover to validate the timing.
   • BPlan for a longer downtime window and inform the business that the migration may take up to 6 hours.
   • CUse a third-party tool that claims to migrate Oracle to PostgreSQL in under an hour.
   • DSkip the test migration and proceed directly with the cutover to save time.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A financial services company is migrating a legacy on-premises Oracle database to Cloud SQL for MySQL. The migration can only occur during a scheduled maintenance window on a weekend. The team must ensure that no data is lost and that the target is fully consistent before the application is pointed to it. What is the most appropriate approach?

   • AUse Database Migration Service to perform a one-time full dump and restore, then cut over during the maintenance window.
   • BSet up continuous replication from Oracle to Cloud SQL using a third-party tool, then cut over during the maintenance window.
   • CStop the application, take a consistent backup of the source, restore it to Cloud SQL, validate, and then restart the application against the target.
   • DUse Storage Transfer Service to copy the Oracle data files to Cloud SQL, then run a validation script.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is the primary goal of DDL conversion during a database migration?

   • ATo encrypt the data in transit
   • BTo make the schema definitions compatible with the target database engine
   • CTo optimize the performance of the target database
   • DTo reduce the size of the migrated data
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   A company needs to migrate a large set of on-premises files to Google Cloud Storage. Which Google Cloud tool is most appropriate for this task?

   • ACloud Spanner
   • BCloud SQL
   • CStorage Transfer Service
   • DDatabase Migration Service
   Reveal Solution Discussion Select an answer first