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 29

Question 280

A globally distributed transactional schema uses a monotonically increasing leading primary-key segment and suffers write hotspots. What should be redesigned?

  1. Select an eligible Spanner multi-region instance configuration with an approved replication topology and data residency.
  2. Use a backup as the only solution to a live Spanner query or scaling constraint.
  3. Change only the Spanner instance label, leaving placement and schema untouched.
  4. Use a Spanner key scheme that distributes sequential writes while preserving required query access patterns.

Explanation

Correct Answer

D:

Sequential leading keys can produce write hotspots in distributed databases even when the service automatically shards storage.

Incorrect Answers

A:

Placement changes do not automatically implement the required resource-level feature. The necessary distinction is distributed write-key placement.

B:

It does not supply the specified transactional schema or consistency behavior. The case instead depends on distributed write-key placement.

C:

It does not supply the specified transactional schema or consistency behavior. It leaves distributed write-key placement unaddressed.

Question 281

A large analytic table is scanned in full on every dashboard refresh although most queries filter by event date. What table design can reduce processed data?

  1. Load the analytic dataset into BigQuery with an appropriate table design and query controls.
  2. Set a shorter result-cache lifetime as the only correction for the described query behavior.
  3. Partition the BigQuery table by an appropriate event-date column and use partition filters.
  4. Add a dataset label instead of changing the query or table feature involved.

Explanation

Correct Answer

C:

Partition pruning can avoid scanning unrelated date partitions when queries are written to use the partition predicate.

Incorrect Answers

A:

The alternative does not address the query or storage behavior driving the workload. The case instead depends on the requested BigQuery operation. The appropriate action here is: Partition the BigQuery table by an appropriate event-date column and use partition filters.

B:

The alternative does not address the query or storage behavior driving the workload. It leaves the requested BigQuery operation unaddressed. The appropriate action here is: Partition the BigQuery table by an appropriate event-date column and use partition filters.

D:

The alternative does not address the query or storage behavior driving the workload. The specific requirement concerns the requested BigQuery operation.

Question 282

A BigQuery table is queried repeatedly by a few high-cardinality predicates and the team considers partitioning by every field. What secondary optimization is more suitable?

  1. Use supported clustering on frequently filtered columns alongside any appropriate partitioning.
  2. Partition the BigQuery table by an appropriate event-date column and use partition filters.
  3. Materialize an unrestricted full-table copy every minute regardless of data volume.
  4. Grant every analyst BigQuery Admin without modifying the requested dataset behavior.

Explanation

Correct Answer

A:

Clustering organizes data within tables or partitions to improve selective scans without creating an impractical number of partitions.

Incorrect Answers

B:

The alternative does not address the query or storage behavior driving the workload. It leaves the requested BigQuery operation unaddressed. The appropriate action here is: Use supported clustering on frequently filtered columns alongside any appropriate partitioning.

C:

The alternative does not address the query or storage behavior driving the workload. The specific requirement concerns the requested BigQuery operation. The appropriate action here is: Use supported clustering on frequently filtered columns alongside any appropriate partitioning.

D:

The alternative does not address the query or storage behavior driving the workload. The necessary distinction is the requested BigQuery operation. The appropriate action here is: Use supported clustering on frequently filtered columns alongside any appropriate partitioning.

Question 283

A Firestore Standard edition query filters by one property and orders by another. It fails with a missing-composite-index error. Which change resolves the indexed query requirement?

  1. Increase the Firestore database instance CPU allocation; the error is only a compute-capacity problem.
  2. Disable indexing for both queried fields so the database performs the combined query without an index.
  3. Create the required composite index for the query shape, then test after the index reaches its ready state.
  4. Create a Bigtable replica in a second region because Firestore automatically inherits Bigtable indexes.

Explanation

Correct Answer

C:

Create the required composite index for the query shape, then test after the index reaches its ready state. Firestore Standard edition uses composite indexes for many multi-field query shapes. Creating the suggested index and allowing its build to complete resolves the missing-index condition.

Incorrect Answers

A:

Increase the Firestore database instance CPU allocation; the error is only a compute-capacity problem. A missing-index error identifies absent query-index support, not insufficient CPU. Firestore query planning needs the appropriate composite index.

B:

Disable indexing for both queried fields so the database performs the combined query without an index. Disabling the indexes makes the missing composite-index requirement worse; it does not enable the filtered-and-ordered query.

D:

Create a Bigtable replica in a second region because Firestore automatically inherits Bigtable indexes. Firestore and Bigtable are separate databases with independent query/indexing behavior. Bigtable replication cannot create a Firestore index.

Question 284

A development team expects arbitrary SQL joins across Bigtable tables as if they were relational Cloud SQL schemas. Which architecture issue must it resolve?

  1. Use Cloud SQL for PostgreSQL with approved network access, backups, and availability settings.
  2. Choose a relational/analytic engine for joins or remodel the Bigtable application around key-oriented access.
  3. Move the database to a Compute Engine VM and assume the managed database behavior remains unchanged.
  4. Modify the client connection timeout but leave the underlying Cloud SQL setting unchanged.

Explanation

Correct Answer

B:

Bigtable's wide-column serving model is not a drop-in replacement for relational SQL joins.

Incorrect Answers

A:

Network settings and service or application controls must be distinguished. The necessary distinction is the database engine and managed SQL operation.

C:

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.

D:

Timeouts control waiting time, not the missing platform feature or access right. It leaves the database engine and managed SQL operation unaddressed.

Question 285

A Cloud SQL application is bottlenecked by read-heavy reporting traffic on the primary instance. What option should it evaluate?

  1. Create eligible Cloud SQL read replicas and route appropriately compatible reads to them.
  2. Configure Cloud SQL regional high availability with its supported standby instance in another zone.
  3. Enable scheduled exports without checking the requested database compatibility or recovery behavior.
  4. Modify the client connection timeout but leave the underlying Cloud SQL setting unchanged.

Explanation

Correct Answer

A:

Read replicas can offload read operations from the primary while writes continue against the primary instance.

Incorrect Answers

B:

Placement changes do not automatically implement the required resource-level feature. The case instead depends on the database engine and managed SQL operation.

C:

That change does not satisfy the database engine, read/write or recovery constraint. It leaves the database engine and managed SQL operation unaddressed.

D:

Timeouts control waiting time, not the missing platform feature or access right. The specific requirement concerns the database engine and managed SQL operation.

Question 286

A Cloud SQL for PostgreSQL instance is configured as a single-zone primary. The application must withstand a primary-zone outage without restoring a manual backup. What should the DBA enable?

  1. Increase the machine's CPU count; additional vCPUs replicate the instance to a separate zone automatically.
  2. Configure Cloud SQL regional high availability with its supported standby instance in another zone.
  3. Create a Cloud Storage Nearline bucket; a storage class automatically becomes a running PostgreSQL standby.
  4. Add a DNS TXT record for the primary instance; this enables cross-zone database failover on a zonal database.

Explanation

Correct Answer

B:

Configure Cloud SQL regional high availability with its supported standby instance in another zone. Regional Cloud SQL HA provides an eligible standby in another zone with replicated storage and managed failover behavior for this failure scope.

Incorrect Answers

A:

Increase the machine's CPU count; additional vCPUs replicate the instance to a separate zone automatically. Scaling the primary changes its compute resources, not its availability topology. A single-zone instance remains vulnerable to that zone's outage.

C:

Create a Cloud Storage Nearline bucket; a storage class automatically becomes a running PostgreSQL standby. Object storage can hold backups but does not serve as a live relational standby instance when the primary zone fails.

D:

Add a DNS TXT record for the primary instance; this enables cross-zone database failover on a zonal database. DNS text metadata cannot provision a Cloud SQL standby or enable the regional high-availability configuration.

Question 287

A web application stores immutable JPEG photos and returns them by HTTP object URL. It does not require POSIX paths, file locks, or a mounted shared filesystem. Which primary storage model fits?

  1. Store the images as Cloud Storage objects in a bucket with appropriate location and authenticated or signed access.
  2. Use a Filestore NFS mount as a requirement even though no application accesses files through POSIX operations.
  3. Place each photo in Cloud SQL PostgreSQL solely because HTTP clients can request relational rows.
  4. Allocate a Compute Engine boot disk for each image so it obtains an HTTP URL without any serving application.

Explanation

Correct Answer

A:

Store the images as Cloud Storage objects in a bucket with appropriate location and authenticated or signed access. Cloud Storage offers an HTTP object interface appropriate for immutable media while supporting independent access policies and storage location choices.

Incorrect Answers

B:

Use a Filestore NFS mount as a requirement even though no application accesses files through POSIX operations. Filestore is useful for shared POSIX/NFS workloads. For this explicitly object-oriented HTTP application, an NFS dependency is unnecessary.

C:

Place each photo in Cloud SQL PostgreSQL solely because HTTP clients can request relational rows. A relational database can store binary data but adds transactional database complexity not required for simple immutable object delivery.

D:

Allocate a Compute Engine boot disk for each image so it obtains an HTTP URL without any serving application. A VM boot disk is block storage attached to a machine and does not inherently offer an independently addressable HTTP object endpoint.

Question 288

Several Compute Engine workers need concurrent shared NFS access to a common POSIX directory. Which managed storage option fits?

  1. Deploy a suitable Filestore instance and mount it from authorized client VMs.
  2. Use a VM-local Persistent Disk as the only copy of the object data without the required bucket controls.
  3. Use a Filestore NFS share as though it implemented Cloud Storage object versioning and generation semantics.
  4. Give anonymous users Storage Admin as a shortcut to object access management.

Explanation

Correct Answer

A:

Filestore provides managed shared file protocols for concurrent readers and writers.

Incorrect Answers

B:

The option does not enforce the required object location, access or lifecycle behavior. The necessary distinction is the object's required data or access behavior.

C:

Object versioning and the requested retention or deletion safeguards are separate mechanisms. The case instead depends on the object's required data or access behavior.

D:

Broad Storage Admin access introduces privileges beyond the stated task. It leaves the object's required data or access behavior unaddressed.

Question 289

A scientific simulation uses hundreds of compute nodes that share one large parallel POSIX dataset and demand very high throughput. Which storage product fits?

  1. Evaluate Google Cloud Managed Lustre with appropriate HPC capacity and networking.
  2. Give anonymous users Storage Admin as a shortcut to object access management.
  3. Use a Filestore NFS share as though it implemented Cloud Storage object versioning and generation semantics.
  4. Use a VM-local Persistent Disk as the only copy of the object data without the required bucket controls.

Explanation

Correct Answer

A:

Managed Lustre is built for highly parallel AI/HPC filesystem workloads, not general object retrieval alone.

Incorrect Answers

B:

Broad Storage Admin access introduces privileges beyond the stated task. The case instead depends on the object's required data or access behavior. The appropriate action here is: Evaluate Google Cloud Managed Lustre with appropriate HPC capacity and networking.

C:

Object versioning and the requested retention or deletion safeguards are separate mechanisms. It leaves the object's required data or access behavior unaddressed. The appropriate action here is: Evaluate Google Cloud Managed Lustre with appropriate HPC capacity and networking.

D:

The option does not enforce the required object location, access or lifecycle behavior. The specific requirement concerns the object's required data or access behavior. The appropriate action here is: Evaluate Google Cloud Managed Lustre with appropriate HPC capacity and networking.

Question 290

An NFS file service must keep accepting operations after one zone in its region fails. Which tier should be considered?

  1. Use an eligible regional Filestore tier instead of a zonal-only instance.
  2. Deploy a suitable Filestore instance and mount it from authorized client VMs.
  3. Turn off object versioning and assume previous generations remain available indefinitely.
  4. Move objects into an unrelated project without first checking their location and policies.

Explanation

Correct Answer

A:

Regional Filestore offers zone-failure resilience unavailable to ordinary zonal instances.

Incorrect Answers

B:

The option does not enforce the required object location, access or lifecycle behavior. It leaves the object's required data or access behavior unaddressed.

C:

Object versioning and the requested retention or deletion safeguards are separate mechanisms. The specific requirement concerns the object's required data or access behavior.

D:

The option does not enforce the required object location, access or lifecycle behavior. The necessary distinction is the object's required data or access behavior. The appropriate action here is: Use an eligible regional Filestore tier instead of a zonal-only instance.

Associate Cloud Engineer Practice Tests