Google Associate Cloud Engineer Practice Test 51
Question 500
A Cloud Run job handles a weekly data export but reports success even though one parallel task failed. What should be evaluated?
- Create a Cloud Run job for finite background processing with appropriate task timeout and retries.
- Delete the working revision before confirming that the replacement can serve requests.
- Change only the Cloud Run maximum instance count and assume all other service configuration follows.
- Inspect per-task statuses, retry limits and aggregate job completion criteria rather than relying on a single container log line.
Explanation
Correct Answer
D:Cloud Run jobs can run multiple tasks; operational success requires every required task to satisfy the job's completion policy.
Incorrect Answers
A:Timeouts control waiting time, not the missing platform feature or access right. The necessary distinction is the Cloud Run service setting.
B:The change does not configure the Cloud Run runtime or traffic behavior at issue. The case instead depends on the Cloud Run service setting. The appropriate action here is: Inspect per-task statuses, retry limits and aggregate job completion criteria rather than relying on a single container log line.
C:The change does not configure the Cloud Run runtime or traffic behavior at issue. It leaves the Cloud Run service setting unaddressed. The appropriate action here is: Inspect per-task statuses, retry limits and aggregate job completion criteria rather than relying on a single container log line.
Question 501
A Cloud SQL PostgreSQL instance encounters too many client connections during a traffic spike even though CPU is low. Which operational control should be adjusted?
- Verify the private service connectivity and address allocation, routes, firewall and client DNS resolving to the intended instance.
- Use managed application connection pooling, verify Cloud SQL connection limits and right-size the database tier when justified.
- Move the database to a Compute Engine VM and assume the managed database behavior remains unchanged.
- Change only the instance labels and assume they govern database behavior.
Explanation
Correct Answer
B:Connection exhaustion can occur independently of CPU saturation; opening more short-lived sessions may worsen the incident.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. The case instead depends on the database engine and managed SQL operation. The appropriate action here is: Use managed application connection pooling, verify Cloud SQL connection limits and right-size the database tier when justified.
C:That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed. The appropriate action here is: Use managed application connection pooling, verify Cloud SQL connection limits and right-size the database tier when justified.
D:That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns the database engine and managed SQL operation.
Question 502
A Cloud SQL instance must undergo maintenance outside its peak business hours, but the team has never selected a maintenance window. What should be configured?
- Check the flag's support and restart requirement, then schedule a controlled restart and validate the effective setting.
- Enable a database backup schedule and assume that it also sets the preferred Cloud SQL maintenance time.
- Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
- Enable scheduled exports without checking the requested database compatibility or recovery behavior.
Explanation
Correct Answer
C:Cloud SQL maintenance can cause restarts or failovers; an approved maintenance schedule reduces surprises to the workload.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed. The appropriate action here is: Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
B:Backups protect recoverable data; they do not specify the maintenance window for the instance.
D:That change does not satisfy the database engine, read/write or recovery constraint. The necessary distinction is the database engine and managed SQL operation. The appropriate action here is: Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
Question 503
A production MySQL database uses long-running analytic SQL that blocks OLTP response time despite low average storage utilization. What should be investigated?
- Use managed application connection pooling, verify Cloud SQL connection limits and right-size the database tier when justified.
- Add a read replica and treat it as a replacement for every backup, failover and access-control requirement.
- Change only the Cloud SQL machine tier without addressing the database configuration described.
- Use Cloud SQL query diagnostics and execution plans to identify expensive scans and adjust indexes or query patterns.
Explanation
Correct Answer
D:Storage capacity is not a substitute for query-plan analysis when inefficient reads hold sessions or consume database resources.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns the database engine and managed SQL operation. The appropriate action here is: Use Cloud SQL query diagnostics and execution plans to identify expensive scans and adjust indexes or query patterns.
B:A read replica does not replace all required backups, writer failover or access restrictions. The necessary distinction is the database engine and managed SQL operation.
C:Resizing the database cannot repair every requested engine, access or recovery setting. The case instead depends on the database engine and managed SQL operation.
Question 504
Cloud SQL's automated backup exists, but a recovery exercise fails because the operator assumes the instance's current data can be overwritten instantly by an older backup. What should be tested?
- Locate an eligible retained backup or older recovery copy and choose a supported restore target rather than requesting unavailable transaction logs.
- Practice supported restore into a designated recovery instance and verify application cutover without destroying current evidence.
- Change only the Cloud SQL machine tier without addressing the database configuration described.
- Enable scheduled exports without checking the requested database compatibility or recovery behavior.
Explanation
Correct Answer
B:Backup existence does not guarantee a tested, non-destructive restore or meet the system's recovery time objective.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. The necessary distinction is the database engine and managed SQL operation. The appropriate action here is: Practice supported restore into a designated recovery instance and verify application cutover without destroying current evidence.
C:Resizing the database cannot repair every requested engine, access or recovery setting. The case instead depends on the database engine and managed SQL operation. The appropriate action here is: Practice supported restore into a designated recovery instance and verify application cutover without destroying current evidence.
D:That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed. The appropriate action here is: Practice supported restore into a designated recovery instance and verify application cutover without destroying current evidence.
Question 505
A Cloud SQL replica falls hours behind primary after a sudden write surge, but dashboards report healthy VM metrics. What should be monitored?
- Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
- Inspect replica lag, replication status, write throughput and replica capacity, then scale or reduce load as needed.
- Change only the Cloud SQL machine tier without addressing the database configuration described.
- Move the database to a Compute Engine VM and assume the managed database behavior remains unchanged.
Explanation
Correct Answer
B:Replication lag measures data freshness; ordinary instance CPU or disk health does not prove an async replica is current.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. The case instead depends on the database engine and managed SQL operation. The appropriate action here is: Inspect replica lag, replication status, write throughput and replica capacity, then scale or reduce load as needed.
C:Resizing the database cannot repair every requested engine, access or recovery setting. It leaves the database engine and managed SQL operation unaddressed.
D:That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns the database engine and managed SQL operation. The appropriate action here is: Inspect replica lag, replication status, write throughput and replica capacity, then scale or reduce load as needed.
Question 506
A project uses Cloud SQL IAM database authentication for its PostgreSQL app, but the developer assumes Google Cloud IAM roles alone create database privileges. What must be configured?
- Rotate and trust the current supported Cloud SQL server CA certificates in the client and verify encrypted connectivity.
- Change only the instance labels and assume they govern database behavior.
- Modify the client connection timeout but leave the underlying Cloud SQL setting unchanged.
- Set up supported IAM database authentication and grant the mapped database principal the required database-level rights.
Explanation
Correct Answer
D:Cloud project IAM and SQL in-database privileges operate at different layers and must both be satisfied.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed. The appropriate action here is: Set up supported IAM database authentication and grant the mapped database principal the required database-level rights.
B:That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns the database engine and managed SQL operation. The appropriate action here is: Set up supported IAM database authentication and grant the mapped database principal the required database-level rights.
C:Timeouts control waiting time, not the missing platform feature or access right. The necessary distinction is the database engine and managed SQL operation.
Question 507
An older app needs client certificate verification for Cloud SQL, but its CA rotation has expired the pinned server trust bundle. What must be updated?
- Rotate and trust the current supported Cloud SQL server CA certificates in the client and verify encrypted connectivity.
- Set up supported IAM database authentication and grant the mapped database principal the required database-level rights.
- Change only the Cloud SQL machine tier without addressing the database configuration described.
- Change only the instance labels and assume they govern database behavior.
Explanation
Correct Answer
A:Certificate trust must be updated across clients when the database server CA changes; a healthy database can still reject outdated TLS clients.
Incorrect Answers
B:That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns the database engine and managed SQL operation. The appropriate action here is: Rotate and trust the current supported Cloud SQL server CA certificates in the client and verify encrypted connectivity.
C:Resizing the database cannot repair every requested engine, access or recovery setting. The necessary distinction is the database engine and managed SQL operation.
D:That change does not satisfy the database engine, read/write or recovery constraint. The case instead depends on the database engine and managed SQL operation. The appropriate action here is: Rotate and trust the current supported Cloud SQL server CA certificates in the client and verify encrypted connectivity.
Question 508
A Cloud SQL maintenance team changes a database flag that requires restart but expects the new setting immediately in running sessions. What is required?
- Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
- Change only the instance labels and assume they govern database behavior.
- Check the flag's support and restart requirement, then schedule a controlled restart and validate the effective setting.
- Enable scheduled exports without checking the requested database compatibility or recovery behavior.
Explanation
Correct Answer
C:Some database flags are not dynamic; changing configured flags doesn't alter live session behavior until a required restart.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. The necessary distinction is the database engine and managed SQL operation. The appropriate action here is: Check the flag's support and restart requirement, then schedule a controlled restart and validate the effective setting.
B:That change does not satisfy the database engine, read/write or recovery constraint. The case instead depends on the database engine and managed SQL operation. The appropriate action here is: Check the flag's support and restart requirement, then schedule a controlled restart and validate the effective setting.
D:That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed. The appropriate action here is: Check the flag's support and restart requirement, then schedule a controlled restart and validate the effective setting.
Question 509
An application experiences intermittent connection failures to a private Cloud SQL instance after its subnet IP range is expanded. What should be checked?
- Use managed application connection pooling, verify Cloud SQL connection limits and right-size the database tier when justified.
- Modify the client connection timeout but leave the underlying Cloud SQL setting unchanged.
- Verify the private service connectivity and address allocation, routes, firewall and client DNS resolving to the intended instance.
- Change only the instance labels and assume they govern database behavior.
Explanation
Correct Answer
C:Private database access depends on correct service networking and address space rather than the database account password alone.
Incorrect Answers
A:That change does not satisfy the database engine, read/write or recovery constraint. The case instead depends on the effective firewall policy.
B:Timeouts control waiting time, not the missing platform feature or access right. It leaves the effective firewall policy unaddressed.
D:That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns the effective firewall policy.
Question 510
A Cloud SQL instance is provisioned with a customer-managed encryption key, and the key is disabled before a scheduled maintenance task. What is the immediate risk?
- Restore authorized Cloud KMS key accessibility before performing operations that require decrypting the instance data.
- Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
- Change only the Cloud SQL machine tier without addressing the database configuration described.
- Move the database to a Compute Engine VM and assume the managed database behavior remains unchanged.
Explanation
Correct Answer
A:CMEK-protected resources depend on the configured key and authorized service-agent access to remain usable.
Incorrect Answers
B:That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed. The appropriate action here is: Restore authorized Cloud KMS key accessibility before performing operations that require decrypting the instance data.
C:Resizing the database cannot repair every requested engine, access or recovery setting. The specific requirement concerns the database engine and managed SQL operation.
D:That change does not satisfy the database engine, read/write or recovery constraint. The necessary distinction is the database engine and managed SQL operation. The appropriate action here is: Restore authorized Cloud KMS key accessibility before performing operations that require decrypting the instance data.