Courseiva
Optimizing service performancehardMultiple ChoiceObjective-mapped

PCDOE Optimizing service performance Practice Question

You are designing a globally distributed application using Cloud Spanner. The application has a write-heavy workload. You notice that write latency increases as the number of nodes increases. What is the most likely cause?

⚠ Common exam trap

A common mix-up: candidates assume adding nodes always improves performance, but this scenario tests the counterintuitive behavior where cross-node coordination overhead in distributed databases like Cloud Spanner can degrade write latency with scale.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

The workload has many cross-node transactions due to split rows.

In Cloud Spanner, write-heavy workloads with many cross-node transactions cause increased write latency as nodes are added. This occurs because Spanner splits rows across nodes, and transactions that span multiple splits require two-phase commit (2PC) coordination between nodes, which adds network overhead and latency. Adding more nodes increases the likelihood that a transaction touches multiple splits, exacerbating the coordination cost.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • The instance is using a multi-region configuration with too many read-only replicas.

    Why it's wrong here

    Read-only replicas do not affect write latency.

  • The workload has many cross-node transactions due to split rows.

    Why this is correct

    Cross-split transactions require coordination, increasing latency.

  • The application is using stale reads for write transactions.

    Why it's wrong here

    Stale reads are for read-only transactions.

  • The number of splits is too low, causing hotspots.

    Why it's wrong here

    Low splits cause hotspots but not uniform latency increase.

About these practice questions

One of 486 original PCDOE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This PCDOE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PCDOE exam.