Professional Cloud Database Engineer Practice Test

Professional Cloud Database Engineer Practice Test practice questions, page 6 of 8, with answer review and explanations.

Question 26

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

  1. Drop or disable all users except database administration users.
  2. Disable all foreign key constraints on the source PostgreSQL database.
  3. Ensure that all PostgreSQL tables have a primary key.
  4. Shut down the database before the Data Migration Service task is started.
  5. Ensure that pglogical is installed on the source PostgreSQL database.

Question 27

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

  1. Use external server replication.
  2. Use Data Migration Service.
  3. Use Cloud SQL for MySQL external replica.
  4. Use the mysqldump utility and binary logs.

Question 28

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

  1. Use Database Migration Service to migrate the databases to Cloud SQL.
  2. Use a cross-region read replica to migrate the databases to Cloud SQL.
  3. Use replication from an external server to migrate the databases to Cloud SQL.
  4. Use an external read replica to migrate the databases to Cloud SQL.
  5. Use a read replica to migrate the databases to Cloud SQL.

Question 29

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

  1. 1. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL. 2. Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination. 3. Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.
  2. 1. Create migration job using Database Migration Service. 2. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode. 3. Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete. 4. Update your application connections to the new instance.
  3. 1. Create migration job using Database Migration Service. 2. Set the migration job type to One-time, and perform this migration during a maintenance window. 3. Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database. 4. Update your application connections to the new instance.
  4. 1. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window. 2. Move the files to Cloud Storage, and import each database into your Cloud SQL instance. 3. Continue to dump each database until all the databases are migrated. 4. Update your application connections to the new instance.

Question 30

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

  1. Normalize the database to the third normal form.
  2. Compress the data using a different compression algorithm.
  3. Manually or automatically increase the storage capacity.
  4. Create another schema to load older data.