Free Access Google.Professional-Cloud-Database-Engineer.v2026-06-22.q177 Practice Test (Page 28)

Question 131

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

A.Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

B.Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

C.Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

D.Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

Question 132

Your Cloud SQL for PostgreSQL database supporting a financial application has been experiencing "deadlock detected" errors during end-of-month processing. You notice that CPU utilization spikes to 90% during these periods, and several long-running queries are consuming significant resources. You need to identify the specific queries causing the deadlocks and implement monitoring to solve similar issues before they cause application failures.
What should you do?

A.Use Cloud SQL System Insights to identify long-running queries and number of deadlocks that occurred in the database. Enable a log_lock_waitsflag to determine if lock waits are causing poor performance. Set up Cloud Monitoring alerts for higher CPU utilization and connection count.

B.Optimize SQL queries by adding appropriate indexes to frequently accessed columns and rewriting complex joins to use LEFT JOINinstead of INNER JOIN, where applicable.

C.Implement connection pooling at the application layer to reduce the number of direct database connections and optimize shared_buffersand work_memparameters in Cloud SQL for PostgreSQL to improve query execution efficiency.

D.Increase the deadlock_timeoutparameter on the Cloud SQL for PostgreSQL instance. Export logs to Cloud Logging, and create log-based metrics to track deadlock occurrences.

Question 133

You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

A.Use Cloud SQL instance monitoring.

B.Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

C.Use Cloud SQL logs.

D.Use the SQL Server Always On Availability Group dashboard.

Question 134

You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

A.Enable the Cloud SQL Admin API.

B.Check whether your service account has cloudsql.instances.connect permission.

C.Ensure that you are using an external (public) IP address interface.

D.Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

Question 135

You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

A.Use log messages produced by Cloud SQL.

B.Use Query Insights for Cloud SQL.

C.Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

D.Use Cloud SQL instance monitoring in the Google Cloud Console.

Other Version: 1373Google.Professional-Cloud-Database-Engineer.v2024-04-26.q86

Latest Upload: 131Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 142SAP.C_CR125_2601.v2026-08-17.q28; 181Salesforce.Field-Service-Consultant.v2026-08-17.q134; 151Oracle.1Z0-1170.v2026-08-16.q64; 158Oracle.1Z1-1170.v2026-08-16.q64; 193Juniper.JN0-336.v2026-08-13.q60; 327EMC.NCP-AII.v2026-08-13.q200; 205CIRO.RSE.v2026-08-12.q41; 175CrowdStrike.CCSE-204.v2026-08-12.q50; 163ISQI.CT-GenAI.v2026-08-11.q14

Question 131

Question 132

Question 133

Question 134

Question 135

Download PDF File