Professional Cloud Database Engineer Practice Test

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

Question 36

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

  1. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
  2. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
  3. If the corruption is significant, use import and export.
  4. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
  5. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

Question 37

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

  1. Close idle connections or restart the instance before beginning the import operation.
  2. Increase the amount of memory allocated to your instance.
  3. Ensure that the service account has the Storage Admin role.
  4. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

Question 38

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

  1. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
  2. Set up Serverless VPC Access.
  3. Set up Private Service Connect.
  4. Set up Traffic Director.

Question 39

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

  1. Use Cloud Functions to run the export in Avro format.
  2. Use Cloud Functions to run the export in text format.
  3. Use Dataflow to run the export in Avro format.
  4. Use Dataflow to run the export in text format.