Google Professional Cloud Database Engineer Exam Questions Instant Access

Question 1

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

AUse query parameters to speed up frequently executed queries.

BChange the Cloud Spanner configuration from multi-region to single region.

CUse SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

DUse SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

Answer : C

To troubleshoot high read latency, you can use SQL statements to analyze the SPANNER_SYS.READ_STATS* tables. These tables contain statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take appropriate action to resolve the issue. Other options, such as using query parameters to speed up frequently executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS* tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.

Question 2

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:

Work with transactions and offer strong consistency.

Work with structured and semi-structured (JSON) data.

Scale transparently to multiple regions globally as the operation grows.

You need a Google Cloud database that meets all the requirements of the application. What should you do?

AUse Cloud SQL for PostgreSQL with both cross-region read replicas.

BUse Cloud Spanner in a multi-region configuration.

CUse Firestore in Datastore mode.

DUse a Bigtable instance with clusters in multiple regions.

Answer : B

https://cloud.google.com/blog/products/databases/manage-semi-structured-data-in-cloud-spanner-with-json

Question 3

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?

ASet up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.

BConnect by using the private IP address of the AlloyDB cluster directly from the application.

CConnect by using AlloyDB Auth Proxy installed in the GKE cluster.

DInstall a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.

Answer : B

Question 4

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

ACreate a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

BUse the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

CCreate a Compute Engine VM, install MySQL on the VM, and then import the dump file.

DCreate an external replica, and use Cloud SQL to synchronize the data to the replica.

Answer : D

https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external

Question 5

Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do?

ACreate a Cloud SQL instance in HA mode with a cross-region read replica.

BCreate an AlloyDB instance in HA mode with a cross-region read replica.

CCreate a spanner instance across regions for optimal performance.

DImplement Bigtable with replication across multiple regions and configure to prioritize data accuracy.

Answer : C

Question 6

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?

ACheck the cloudsql.googleapis.com/postgres.log instance log.

BPerform the gcloud sql operations list command.

CUse Cloud Audit Logs to verify the status.

DUse the Google Cloud Console.

Answer : B

https://cloud.google.com/sql/docs/postgres/backup-recovery/backups#troubleshooting-backups Under Troubleshooting: Issue: 'You can't see the current operation's status.' The Google Cloud console reports only success or failure when the operation is done. It isn't designed to show warnings or other updates. Run the gcloud sql operations list command to list all operations for the given Cloud SQL instance.

Question 7

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?

AProvision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-west1-b.
Create a read replica in us-east1-c.

BProvision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-central1-b.
Create a read replica in us-east1-b.

CProvision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east-b.
Create a read replica in us-east1-c.

DProvision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east1-b.
Create a read replica in us-central1-b.

Answer : B

https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery