Professional Cloud Database Engineer Practice Test

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

Question 31

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

  1. Check the cloudsql.googleapis.com/postgres.log instance log.
  2. Perform the gcloud sql operations list command.
  3. Use Cloud Audit Logs to verify the status.
  4. Use the Google Cloud Console.

Question 32

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

  1. Increase the number of processing units.
  2. Modify the database schema, and add additional indexes.
  3. Shard data required by the application into multiple instances.
  4. Decrease the number of processing units.

Question 33

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

  1. Recommend solid-state drives (SSD).
  2. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
  3. Recommend hard disk drives (HDD).
  4. Recommend mixed storage types.

Question 34

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

  1. 1. Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-west1-b. 3. Create a read replica in us-east1-c.
  2. 1. Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-central1-b. 3. Create a read replica in us-east1-b.
  3. 1. Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-east-b. 3. Create a read replica in us-east1-c.
  4. 1. Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-east1-b. 3. Create a read replica in us-central1-b.

Question 35

You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

  1. Use Firestore.
  2. Use Cloud SQL with an external (public) IP address.
  3. Use an in-app embedded database.
  4. Use Cloud Spanner.