cert
cert-1
cert-2

Pass Google Associate Cloud Engineer Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
Associate Cloud Engineer Exam - Verified By Experts
Associate Cloud Engineer Premium Bundle
$29.98

Associate Cloud Engineer Premium Bundle

$79.99
$109.97
  • Premium File 391 Questions & Answers. Last update: Nov 10, 2026
  • Training Course 234 Video Lectures
  • Study Guide 849 Pages
 
$109.97
$79.99
accept 42 downloads in last 7 days
block-screenshots
Purchase Google Associate Cloud Engineer Exam Training Products Individually
Google Associate Cloud Engineer Premium File
Premium File 391 Q&A
$76.99$69.99
Google Associate Cloud Engineer Video Training Course
Training Course 234 Lectures
$21.99 $19.99
Google Associate Cloud Engineer PDF Study Guide
Study Guide 849 Pages
$21.99 $19.99
Google Associate Cloud Engineer Practice Test 52

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?

  1. Restore authorized Cloud KMS key accessibility before performing operations that require decrypting the instance data.
  2. Select the supported maintenance window and track upcoming maintenance notifications before scheduling production changes.
  3. Change only the Cloud SQL machine tier without addressing the database configuration described.
  4. 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.

Question 511

A Cloud SQL operator attempts to restore to an exact timestamp outside the configured point-in-time recovery retention window. What recovery path must be evaluated?

  1. Practice supported restore into a designated recovery instance and verify application cutover without destroying current evidence.
  2. Move the database to a Compute Engine VM and assume the managed database behavior remains unchanged.
  3. Locate an eligible retained backup or older recovery copy and choose a supported restore target rather than requesting unavailable transaction logs.
  4. Change only the Cloud SQL machine tier without addressing the database configuration described.

Explanation

Correct Answer

C:

Point-in-time recovery can only replay logs that remain inside the configured retention window; earlier timestamps require another backup source.

Incorrect Answers

A:

That change does not satisfy the database engine, read/write or recovery constraint. The specific requirement concerns retention or recoverability controls.

B:

That change does not satisfy the database engine, read/write or recovery constraint. The necessary distinction is retention or recoverability controls.

D:

Resizing the database cannot repair every requested engine, access or recovery setting. The case instead depends on retention or recoverability controls.

Question 512

A team rapidly increases Cloud SQL storage to address free-space alerts but expects to shrink the volume after deleting temporary tables. What constraint should influence planning?

  1. Verify the private service connectivity and address allocation, routes, firewall and client DNS resolving to the intended instance.
  2. Enable scheduled exports without checking the requested database compatibility or recovery behavior.
  3. Add a read replica and treat it as a replacement for every backup, failover and access-control requirement.
  4. Plan for supported automatic storage growth and the limitation that provisioned Cloud SQL storage generally cannot shrink in place.

Explanation

Correct Answer

D:

Provisioned managed database storage and logical free space differ; expanding storage should be justified with retention cleanup.

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: Plan for supported automatic storage growth and the limitation that provisioned Cloud SQL storage generally cannot shrink in place.

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: Plan for supported automatic storage growth and the limitation that provisioned Cloud SQL storage generally cannot shrink in place.

C:

A read replica does not replace all required backups, writer failover or access restrictions. It leaves the database engine and managed SQL operation unaddressed.

Question 513

A Spanner application shows high aborted transactions because clients read and write many overlapping keys concurrently. What client behavior should be reviewed?

  1. Evaluate Spanner processing-unit/node capacity and workload distribution, then adjust compute and query performance accordingly.
  2. Use supported transaction retries with exponential backoff and reduce unnecessary overlapping mutations or transaction duration.
  3. Change only the Spanner instance label, leaving placement and schema untouched.
  4. Move the transaction to BigQuery and assume its analytics engine provides identical OLTP behavior.

Explanation

Correct Answer

B:

Spanner serializable transaction contention can abort conflicting work, so applications must safely retry aborted transactions.

Incorrect Answers

A:

It does not supply the specified transactional schema or consistency behavior. The case instead depends on the transactional schema or consistency requirement.

C:

It does not supply the specified transactional schema or consistency behavior. It leaves the transactional schema or consistency requirement unaddressed.

D:

It does not supply the specified transactional schema or consistency behavior. The specific requirement concerns the transactional schema or consistency requirement. The appropriate action here is: Use supported transaction retries with exponential backoff and reduce unnecessary overlapping mutations or transaction duration.

Question 514

A Spanner read-only analytics service requests the strongest consistency on every historical report and pays a latency penalty. What option should be evaluated?

  1. Assess instance configuration, leader placement and read replica options that match data locality and consistency requirements.
  2. Store the hot key values in a single monotonically increasing primary-key range.
  3. Replace global transaction behavior with independent per-region copies and no coordination.
  4. Use a justified bounded-staleness or exact-staleness read for reports that explicitly allow older snapshots.

Explanation

Correct Answer

D:

Spanner offers different read consistency options; not every workload needs current strong reads when historical snapshots suffice.

Incorrect Answers

A:

A read replica does not replace all required backups, writer failover or access restrictions. It leaves the requested latency measurement unaddressed.

B:

It does not supply the specified transactional schema or consistency behavior. The specific requirement concerns the requested latency measurement.

C:

Placement changes do not automatically implement the required resource-level feature. The necessary distinction is the requested latency measurement.

Question 515

A production Spanner schema adds a large index and the operator expects it to become available instantly without backfill overhead. What rollout consideration is needed?

  1. Create an appropriate secondary index after verifying selectivity and backfill cost, and validate the query plan.
  2. Store the hot key values in a single monotonically increasing primary-key range.
  3. Monitor supported index backfill and schema update progress, and avoid assuming immediate query eligibility.
  4. Replace global transaction behavior with independent per-region copies and no coordination.

Explanation

Correct Answer

C:

Distributed index creation can require asynchronous processing; schema changes have workload and deployment implications.

Incorrect Answers

A:

It does not supply the specified transactional schema or consistency behavior. The specific requirement concerns the transactional schema or consistency requirement. The appropriate action here is: Monitor supported index backfill and schema update progress, and avoid assuming immediate query eligibility.

B:

It does not supply the specified transactional schema or consistency behavior. The necessary distinction is the transactional schema or consistency requirement. The appropriate action here is: Monitor supported index backfill and schema update progress, and avoid assuming immediate query eligibility.

D:

Placement changes do not automatically implement the required resource-level feature. The case instead depends on the transactional schema or consistency requirement.

Question 516

Spanner CPU is steady high while storage usage is modest and an operator adds more disk quota alone. What capacity lever matters?

  1. Use supported transaction retries with exponential backoff and reduce unnecessary overlapping mutations or transaction duration.
  2. Replace global transaction behavior with independent per-region copies and no coordination.
  3. Move the transaction to BigQuery and assume its analytics engine provides identical OLTP behavior.
  4. Evaluate Spanner processing-unit/node capacity and workload distribution, then adjust compute and query performance accordingly.

Explanation

Correct Answer

D:

Spanner capacity for transaction throughput depends on processing resources, not simply remaining storage space.

Incorrect Answers

A:

It does not supply the specified transactional schema or consistency behavior. The necessary distinction is the transactional schema or consistency requirement. The appropriate action here is: Evaluate Spanner processing-unit/node capacity and workload distribution, then adjust compute and query performance accordingly.

B:

Placement changes do not automatically implement the required resource-level feature. The case instead depends on the transactional schema or consistency requirement. The appropriate action here is: Evaluate Spanner processing-unit/node capacity and workload distribution, then adjust compute and query performance accordingly.

C:

It does not supply the specified transactional schema or consistency behavior. It leaves the transactional schema or consistency requirement unaddressed. The appropriate action here is: Evaluate Spanner processing-unit/node capacity and workload distribution, then adjust compute and query performance accordingly.

Question 517

A Spanner operations team needs to restore one deleted table but has not tested available backup consistency or point-in-time recovery. What should they validate?

  1. Assess instance configuration, leader placement and read replica options that match data locality and consistency requirements.
  2. Store the hot key values in a single monotonically increasing primary-key range.
  3. Confirm the available backup or PITR window and perform a supported restore into a controlled database before production cutover.
  4. Increase client connection retries without examining the Spanner schema or consistency requirement.

Explanation

Correct Answer

C:

Spanner recovery has explicit backup/retention windows; missing recovery tests make a backup configuration insufficient evidence.

Incorrect Answers

A:

A read replica does not replace all required backups, writer failover or access restrictions. The case instead depends on the transactional schema or consistency requirement.

B:

It does not supply the specified transactional schema or consistency behavior. It leaves the transactional schema or consistency requirement unaddressed. The appropriate action here is: Confirm the available backup or PITR window and perform a supported restore into a controlled database before production cutover.

D:

It does not supply the specified transactional schema or consistency behavior. The specific requirement concerns the transactional schema or consistency requirement. The appropriate action here is: Confirm the available backup or PITR window and perform a supported restore into a controlled database before production cutover.

Question 518

A global Spanner deployment must lower read latency for Europe while retaining writes in the designated regional leader. What configuration should be reviewed?

  1. Use a justified bounded-staleness or exact-staleness read for reports that explicitly allow older snapshots.
  2. Use a backup as the only solution to a live Spanner query or scaling constraint.
  3. Replace global transaction behavior with independent per-region copies and no coordination.
  4. Assess instance configuration, leader placement and read replica options that match data locality and consistency requirements.

Explanation

Correct Answer

D:

Spanner's replication and leader topology influence latency; relocating compute alone does not change database leader geography.

Incorrect Answers

A:

Snapshots are recovery artifacts and do not directly reconfigure a running resource. It leaves the requested latency measurement unaddressed.

B:

It does not supply the specified transactional schema or consistency behavior. The specific requirement concerns the requested latency measurement. The appropriate action here is: Assess instance configuration, leader placement and read replica options that match data locality and consistency requirements.

C:

Placement changes do not automatically implement the required resource-level feature. The necessary distinction is the requested latency measurement. The appropriate action here is: Assess instance configuration, leader placement and read replica options that match data locality and consistency requirements.

Question 519

A Spanner query plan shows a full-table scan on a frequently filtered high-cardinality column, and read latency grows with dataset size. What optimization should be considered?

  1. Create an appropriate secondary index after verifying selectivity and backfill cost, and validate the query plan.
  2. Monitor supported index backfill and schema update progress, and avoid assuming immediate query eligibility.
  3. Replace global transaction behavior with independent per-region copies and no coordination.
  4. Use a backup as the only solution to a live Spanner query or scaling constraint.

Explanation

Correct Answer

A:

A selective index can reduce scanned rows but must be evaluated against additional write and storage overhead.

Incorrect Answers

B:

It does not supply the specified transactional schema or consistency behavior. The specific requirement concerns the requested latency measurement. The appropriate action here is: Create an appropriate secondary index after verifying selectivity and backfill cost, and validate the query plan.

C:

Placement changes do not automatically implement the required resource-level feature. The necessary distinction is the requested latency measurement. The appropriate action here is: Create an appropriate secondary index after verifying selectivity and backfill cost, and validate the query plan.

D:

It does not supply the specified transactional schema or consistency behavior. The case instead depends on the requested latency measurement.

Question 520

A Spanner tenant adds a change stream but consumers assume event messages are unique and apply duplicate updates when partitions retry. What consumer design is required?

  1. Use position/sequence or transaction metadata to process change-stream records idempotently and handle partition lifecycle.
  2. Use supported transaction retries with exponential backoff and reduce unnecessary overlapping mutations or transaction duration.
  3. Increase client connection retries without examining the Spanner schema or consistency requirement.
  4. Store the hot key values in a single monotonically increasing primary-key range.

Explanation

Correct Answer

A:

Change stream consumers can encounter retries or partition changes; exactly-once business effects require consumer-level controls.

Incorrect Answers

B:

It does not supply the specified transactional schema or consistency behavior. The necessary distinction is the transactional schema or consistency requirement. The appropriate action here is: Use position/sequence or transaction metadata to process change-stream records idempotently and handle partition lifecycle.

C:

It does not supply the specified transactional schema or consistency behavior. The case instead depends on the transactional schema or consistency requirement. The appropriate action here is: Use position/sequence or transaction metadata to process change-stream records idempotently and handle partition lifecycle.

D:

It does not supply the specified transactional schema or consistency behavior. It leaves the transactional schema or consistency requirement unaddressed. The appropriate action here is: Use position/sequence or transaction metadata to process change-stream records idempotently and handle partition lifecycle.

Associate Cloud Engineer Practice Tests