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

Questions 6–10

1. 6foundation · easy

   Which Google Cloud tool is specifically designed for migrating databases to Cloud SQL, Cloud Spanner, or AlloyDB?

   • ACloud Dataflow
   • BStorage Transfer Service
   • CDatabase Migration Service
   • DBigQuery Data Transfer Service
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   When migrating a database from an on-premises environment to Google Cloud, which of the following is a key consideration?

   • AThe brand of the on-premises database software
   • BThe number of employees in the IT department
   • CThe color of the server racks in the on-premises data center
   • DNetwork connectivity between the on-premises environment and Google Cloud
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A team is migrating an on-premises MySQL database to Cloud Spanner. The source schema uses AUTO_INCREMENT columns, and the application queries rely on the LAST_INSERT_ID() function. During the migration planning, what must the team address?

   • AChange the application to use UUIDs for all primary keys, but keep the AUTO_INCREMENT columns for legacy reports.
   • BConvert AUTO_INCREMENT columns to INT64 with a sequence or a client-generated key, and update the application to use the generated key.
   • CUse a Cloud Function to generate the next ID for each insert, mimicking LAST_INSERT_ID().
   • DKeep the AUTO_INCREMENT columns as-is because Cloud Spanner supports them for compatibility.
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   A company has migrated its on-premises PostgreSQL database to Cloud SQL using Database Migration Service with continuous replication. After the cutover, the team wants to keep the on-premises database as a fallback for 30 days. They have enabled reverse replication. What is the most critical ongoing task to ensure the fallback remains viable?

   • ADisable all writes to the Cloud SQL database to ensure the source remains consistent.
   • BRun a validation script on the source database every hour to check for data corruption.
   • CMonitor the reverse replication lag and ensure it stays within acceptable limits.
   • DTake a full backup of the Cloud SQL database every day and store it in Cloud Storage.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company is migrating its on-premises MySQL database to Cloud SQL for MySQL. The database is 1 TB and the team wants to use Database Migration Service. The source database is behind a firewall and not publicly accessible. What must the team do to allow DMS to connect to the source?

   • ACreate a VPN tunnel or use Cloud Interconnect to establish a private connection between the source network and Google Cloud.
   • BUse Storage Transfer Service to copy the database files to Cloud Storage and then import them.
   • CExpose the source database to the public internet and allowlist the DMS IP addresses.
   • DUse a Cloud VPN to connect the source network to Google Cloud, but DMS cannot use a private connection.
   Reveal Solution Discussion Select an answer first