Try and practice the latest Google : Professional-Cloud-Database-Engineer real questions & answers

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

• A. Stop all running queries, and re-create the replicas.
• B. Identify and optimize slow running queries, or set parallel replication flags.
• C. Edit the primary instance to add additional memory.
• D. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

Your organization runs a high-volume, low-latency application on Bigtable. You need to reduce costs without compromising performance. What should you do-

• A. Consolidate multiple small clusters into a single large cluster.
• B. Switch to a lower-performance storage type for all clusters.
• C. Reduce replication factor across clusters.
• D. Analyze application access patterns to strategically redesign the schema and adjust the node count.

You are planning connectivity for a global retail analytics service that runs in multiple Google Cloud regions and must reach a Cloud Spanner database with very low latency, strong security, and high reliability. Which connection approach should the application adopt to satisfy these requirements?

• A. Access Cloud Spanner through the REST API from the app and add a cache layer to improve response time
• B. Connect to a fixed public IP address on the Cloud Spanner instance and enable SSL
• C. Use the Cloud Spanner client libraries with a regional instance and enable connection pooling
• D. Use the Cloud Spanner client libraries against a multi-region instance and configure connection pooling

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?

• A. Normalize the database to the third normal form.
• B. Manually or automatically increase the storage capacity.
• C. Create another schema to load older data.
• D. Compress the data using a different compression algorithm.

You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

• A. Create a custom app profile with multi-cluster routing.
• B. Create a custom app profile with single-cluster routing.
• C. Use the default app profile with multi-cluster routing.
• D. Use the default app profile with single-cluster routing.