VendorsExamsEnterprise
Support
Request an ExamContact UsFAQ

Google Cloud Professional Cloud Database Engineer Free Sample Questions

Description

Covers database capacity planning and high availability design, application connectivity and monitoring across database technologies, data migration and replication, and deployment.

17 free sample questions207 in the full practice test Other version: PCDBE(258)

Try simulator

GCP-PCDE Sample Questions

  1. Question 1

    Intermediate

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · Database capacity and usage planning

    An e-commerce platform relies on Cloud Spanner to handle extreme write-heavy burst traffic during flash sales. The current configuration uses 5 nodes. During bursts, CPU utilization hits 95% and write latencies spike unacceptably. Cost optimization is strictly required during non-burst periods. Which approach provides the optimal balance of performance and cost?

    Answer and explanation

    Correct answer: B

    Spanner autoscaling dynamically adjusts compute capacity based on CPU utilization. Setting a target of 65% for high-priority CPU ensures sufficient headroom to absorb sudden spikes (preventing the 95% saturation) while automatically scaling down during quiet periods to save costs.

  2. Question 2

    Advanced

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · Database capacity and usage planning

    A data analytics team is sizing a new Cloud Bigtable cluster for a real-time IoT ingestion pipeline. They have strict Service Level Agreements (SLAs) dictating that 99th percentile read latency must remain under 10ms. During peak ingestion, write throughput will reach 50,000 QPS. Which architectural decision best ensures these SLAs are met while optimizing cluster sizing?

    Answer and explanation

    Correct answer: D

    Workload isolation using app profiles is a best practice in Bigtable. By directing heavy write traffic to one cluster and latency-sensitive read traffic to another cluster within the same instance, you prevent write-induced CPU saturation from impacting the 10ms read latency SLA.

  3. Question 3

    Intermediate

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · Evaluating database solutions

    A retail organization is migrating its inventory management system to Google Cloud. The workload is a Hybrid Transactional/Analytical Processing (HTAP) scenario, requiring high-throughput ACID transactions alongside complex, real-time analytical queries over the same data. Which database service and specific feature should be utilized to satisfy these requirements without impacting transactional performance?

    Answer and explanation

    Correct answer: C

    AlloyDB is designed specifically for HTAP workloads. Its columnar engine automatically keeps frequently queried data in a columnar format in memory, drastically accelerating analytical queries without degrading the performance of concurrent transactional inserts and updates.

  4. Question 4

    Advanced

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · High availability and disaster recovery

    GlobalFin, a multinational financial institution, is re-architecting its core ledger system.

    The current system relies on an on-premises Oracle database. The business requires the new cloud-based system to support synchronous replication across continents, guarantee strict external consistency (ACID compliance), and provide a Recovery Point Objective (RPO) of absolutely zero in the event of a total regional failure.

    Which Google Cloud database architecture is the ONLY solution that natively meets all these constraints?

    graph TD Client((Client)) --> LB[Global Load Balancer] LB --> API_US[API Service US] LB --> API_EU[API Service EU] API_US --> DB[(Database)] API_EU --> DB
    Answer and explanation

    Correct answer: B

    Cloud Spanner is the only Google Cloud relational database that provides synchronous replication across regions/continents using TrueTime. This architecture guarantees strict external consistency and a true Zero RPO in the event of a regional failure, as transactions are hardened in multiple regions before being committed.

  5. Question 5

    Intermediate

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · High availability and disaster recovery

    A database engineer is designing a disaster recovery strategy for a mission-critical Cloud SQL for MySQL database. The business requires the ability to perform a planned failover (switchover) to a different region with absolutely zero data loss and minimal downtime during regular maintenance drills. Which feature should be implemented?

    Answer and explanation

    Correct answer: C

    Cloud SQL Enterprise Plus offers Advanced Disaster Recovery. This allows you to designate a DR Replica and perform a 'switchover'. During a switchover, the system automatically ensures zero data loss, demotes the primary, promotes the DR replica, and automatically re-establishes the replication topology in reverse.

  6. Question 6

    Beginner

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · High availability and disaster recovery

    True or False: AlloyDB for PostgreSQL secondary clusters located in different regions use synchronous replication to ensure strict global consistency.

    Answer and explanation

    Correct answer: B

    False. AlloyDB secondary clusters use asynchronous replication based on PostgreSQL's streaming replication. Because it is asynchronous, there is a replication lag, meaning it provides eventual consistency across regions, not strict global consistency.

  7. Question 7

    Beginner

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · High availability and disaster recovery

    An organization is using a multi-cluster Cloud Bigtable instance to serve a globally distributed application. They want to ensure that reads are always strongly consistent (Read-Your-Writes) for individual users, even if a cluster fails. Which App Profile configuration is required?

    Answer and explanation

    Correct answer: A

    To achieve strong consistency (Read-Your-Writes) in Bigtable, you must use an App Profile configured for single-cluster routing. This ensures that a specific client's reads and writes all go to the exact same cluster, avoiding replication lag.

  8. Question 8

    Intermediate

    Design Innovative, Scalable, and Highly Available Cloud Database Solutions · Application database connectivity

    A cloud architect is designing the network connectivity for a fleet of 50 Cloud SQL instances across multiple VPCs. The security team mandates that all traffic remain on internal IP addresses. The architect must choose between Private Service Access (PSA) and Private Service Connect (PSC). Which of the following is a critical limitation of PSA that PSC resolves in this scenario?

    Answer and explanation

    Correct answer: B

    Private Service Access (PSA) relies on VPC peering and requires allocating a contiguous range of IP addresses (often a /16 or /24) to the Google managed services VPC. In large environments, this quickly leads to IP exhaustion. Private Service Connect (PSC) solves this by mapping the database to a single IP address (endpoint) in your VPC.

Register free for 9 more questions

Or unlock all 207 GCP-PCDE questions with explanations, timed mode and flashcards.

Related practice tests

All Google practice exams