Get real Professional-Cloud-Database-Engineer exam questions for better preparation

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

• A. Take one manual backup per day, and turn off transaction log retention.
• B. Turn on automated backup, and turn on transaction log retention.
• C. Take no backups, and turn off transaction log retention.
• D. Turn on automated backup, and turn off transaction log retention.

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

• A. Create the database with customer-managed encryption keys.
• B. Create the database persistent disk with customer-managed encryption keys.
• C. Create the database persistent disk with Google-managed encryption keys.
• D. Create the database with Google-managed encryption keys.

You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

• A. Maintain a target of 35% CPU utilization by locating:
  cluster-a in zone us-central1-a
  cluster-b in zone australia-southeast1-a
  cluster-c in zone europe-west1-d
  cluster-d in zone asia-east1-b
• B. Maintain a target of 23% CPU utilization by locating:
  cluster-a in zone us-central1-a
  cluster-b in zone us-central1-b
  cluster-c in zone us-east1-a
• C. Maintain a target of 23% CPU utilization by locating:
  cluster-a in zone us-central1-a
  cluster-b in zone europe-west1-d
  cluster-c in zone asia-east1-b
• D. Maintain a target of 35% CPU utilization by locating:
  cluster-a in zone us-central1-a
  cluster-b in zone us-central2-a
  cluster-c in zone asia-northeast1-b
  cluster-d in zone asia-east1-b

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

• A. Disable and remove the internal IP address assignment.
• B. Disable and remove the external IP address assignment.
• C. Specify an authorized network with the CIDR range of the VM.
• D. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that inefficient queries might be contributing to these issues. You want to pinpoint and analyze these problematic queries and pass them to the application team for optimizations. What should you do-

• A. Enable and use Query Insights.
• B. Create a Cloud Monitoring alert based on the database/mysql/queriesmetric.
• C. Increase the Cloud SQL instance read_buffer_sizeflag.
• D. Use the underprovisioned instance recommender.