EnglishDeutschFrançaisEspañolPortuguês

Google Cloud · GCP-PCDB · Advanced

Professional Cloud Database Engineer — Practice Questions and Mock Exam

The Professional Cloud Database Engineer certification validates your ability to design, create, manage, and troubleshoot Google Cloud databases.

Practice for freeTry a practice question first
Try a practice question firstPractice for free
Start practicing GCP-PCDB freeBuy GCP-PCDB access for $29.99
55Questions per Pass-IT mock exam
120minPass-IT mock exam time limit

Checked against Google Cloud · September 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a GCP-PCDB sample question and read the explanation with its source. Right here, with no sign-up.

Migrate data solutions1 / 5

You are designing a migration strategy for moving a 5 TB Oracle database to Cloud SQL for PostgreSQL. The application can tolerate a maximum of 30 minutes of downtime. Which migration approach is most appropriate?

AlexFull explanation from Alex

Database Migration Service (DMS) supports continuous migration for Oracle to Cloud SQL for PostgreSQL. During continuous migration, DMS first performs a full dump of source data, then switches to Change Data Capture (CDC) using Oracle LogMiner to replicate ongoing changes. This enables near-zero downtime: you stop source writes, verify data, and promote the destination. For a 5 TB database with a 30-minute downtime window, continuous migration is ideal because CDC keeps the destination synchronized until cutover. A SQL dump export requires extended downtime proportional to database size. Manual re-entry is impractical at scale. Datastream to Cloud Storage via Dataflow adds unnecessary intermediate steps and complexity compared to DMS's native CDC pipeline. Ref: cloud.google.com/database-migration/docs/oracle-to-postgresql/scenario-overview

Sourcedocs.cloud.google.com

Design innovative, scalable, and highly available cloud database solutions2 / 5

A global fintech application requires a relational database that offers strong consistency, horizontal write scalability, and a 99.999% monthly availability SLA that protects against an entire region becoming unavailable. The architecture team wants Google Cloud to handle replication and failover automatically without application-level sharding. Which database configuration should you design?

AlexFull explanation from Alex

Spanner is Google's horizontally scalable, strongly consistent relational database. Its availability is determined by the instance configuration: regional configurations keep replicas within a single region and carry a 99.99% SLA, while multi-region configurations spread read-write replicas across regions and carry the higher 99.999% SLA (under five minutes of downtime per year). Multi-region configurations contain at least three regions and five replicas, and Spanner automatically handles failover when a region becomes unavailable. This contrasts with Cloud SQL, where HA is only zonal-within-a-region. Choosing the instance configuration is therefore the central design lever for both availability and data residency. Exam tip: map the magic number 99.999% directly to Spanner multi-region, and 99.99% (regional Spanner) or 99.95% (Cloud SQL HA) to the lower tiers.

Sourcecloud.google.com

Manage a solution that can span multiple database technologies3 / 5

You are managing a Cloud SQL for MySQL instance and need to configure the maintenance window. The application has peak usage between 9 AM and 6 PM on weekdays. When should you schedule the maintenance window?

AlexFull explanation from Alex

Cloud SQL lets you configure a maintenance window specifying the day and hour for updates. Google's documentation recommends scheduling maintenance during low-traffic periods to minimize user impact. The default maintenance windows are already set to off-peak: weekdays 10 PM–6 AM and weekends. Google's own example shows a retailer scheduling maintenance at midnight on Sundays—the lowest traffic period. With peak usage from 9 AM–6 PM on weekdays, scheduling during off-peak hours (weekends or late night) is correct. Maintenance is fully schedulable (the option “Maintenance cannot be scheduled and occurs randomly” is wrong—it does not occur randomly). Scheduling after backup windows has no correlation with low impact. During peak hours would maximize disruption. You can also set deny maintenance periods for up to 90 days to block updates during critical business periods. Ref: cloud.google.com/sql/docs/mysql/maintenance

Sourcedocs.cloud.google.com

Deploy scalable and highly available databases in Google Cloud4 / 5

You are deploying a Cloud SQL for PostgreSQL instance with high availability and need to test the disaster recovery process. How can you verify that automatic failover works correctly?

AlexFull explanation from Alex

Cloud SQL provides a manual failover capability specifically for testing HA disaster recovery. Google's documentation states: "Testing failover is optional, but is recommended so that you can see how your application responds in the event of a failover." You trigger it via gcloud sql instances failover INSTANCE_NAME or the Cloud SQL Admin API (instances.failover), or through the Console's Failover button. This simulates a zone failure and triggers the automatic failover mechanism to the standby instance, letting you validate application reconnection logic and measure actual failover time. Deleting the primary destroys the instance permanently—this is not a test. Shutting down a zone via Console is not possible for individual users. Disconnecting the network is unreliable and doesn't test the actual Cloud SQL failover mechanism. Ref: cloud.google.com/sql/docs/postgres/configure-ha#initiate-failover

Sourcecloud.google.com

Migrate data solutions5 / 5

You are planning a zero-downtime migration from an on-premises Oracle database to Spanner. Which migration approach should you follow?

AlexFull explanation from Alex

Migrating Oracle to Spanner requires a phased approach because it is a heterogeneous migration—Spanner has a fundamentally different data model (no stored procedures, no triggers, different key design). Google's official migration guide prescribes: (1) convert schema and data model, (2) translate SQL queries, (3) modify the application to write to both databases (dual-write), (4) bulk export/import data via Dataflow, (5) maintain consistency using CDC (e.g., Striim or Oracle LogMiner), (6) validate and cut over. This phased approach enables zero downtime by maintaining both systems in sync until confidence is established. Datastream cannot stream directly into Spanner. DMS does not support direct Oracle-to-Spanner migration. CSV export/import requires downtime and lacks change synchronization. Ref: cloud.google.com/spanner/docs/migrating-oracle-to-cloud-spanner

Sourcedocs.cloud.google.com

How to prepare for GCP-PCDB with Pass-IT.

Currently 304 practice questions for GCP-PCDB, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Meet Alex →

Conversation preview · GCP-PCDB

Cloud SQL maintenance timing

  1. You

    Should maintenance run during the weekday traffic peak?

  2. Alex · AI tutor

    Choose a maintenance window during a lower-traffic period.

    Read the documentation ↗
  3. You

    What should guide the day and hour?

  4. Alex · AI tutor

    Use the application’s actual usage pattern to reduce user impact.

    Read the documentation ↗

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Animated feature preview

Turn your mistakes into knowledge you can rely on.

How Pass-IT works

Your review

Answered a question incorrectly?

Pass-IT saves it for your review.

GCP-PCDB · Question excerpt

Cloud SQL maintenance timing

View the full question

You are managing a Cloud SQL for MySQL instance and need to configure the maintenance window. The application has peak usage between 9 AM and 6 PM on weekdays. When should you schedule the maintenance window?

Understand the correct answer.

During off-peak hours such as weekends or late night

Schedule the maintenance window when application traffic is lower.

Read the documentation ↗

How confidently do you remember?

During review, you assess how well you still know the answer.

Correct after hesitating

Pass-IT schedules your next review.

The date depends on your self-assessment and previous reviews.

Simplified demonstration. No learning progress is saved.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your GCP-PCDB mock exam

Questions
55
Minutes
120

Illustration of an exam session

  1. Start
  2. Answer questions
  3. Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for GCP-PCDB.

Exam topics, relevant practice and sources you can check.

Designing database solutionsSee the guide for weighting90 QuestionsPass-IT questions

Choose a database architecture that fits capacity, availability and application needs.

  • Size compute and storage from workload measurements and expected growth, balancing performance against cost.
  • Compare zonal, regional and multiregional designs and plan maintenance around availability and recovery requirements.
  • Design application connections, session pooling, encryption, key management and auditing.
  • Choose managed or self-managed SQL, NoSQL or vector solutions, considering dependencies, compliance, hybrid integration and generative AI uses.
Official certification objectives
Operating databasesSee the guide for weighting81 QuestionsPass-IT questions

Manage access, recovery, performance and routine database work.

  • Configure database users, authentication and IAM policies for appropriate access.
  • Investigate slow queries, locks, missing indexes and resource contention using metrics, logs, quotas and alerts.
  • Plan backups, imports, exports and retention around recovery time, acceptable data loss and point-in-time recovery.
  • Tune queries, scaling and replication to meet changing workloads and control costs.
  • Automate maintenance and exports, manage upgrades and monitor service-level commitments and objectives.
Official certification objectives
Migrating databasesSee the guide for weighting65 QuestionsPass-IT questions

Plan and execute database moves with an explicit recovery path.

  • Choose migration tools and a strategy that matches the permitted outage and the source database.
  • Plan schema and data changes, including DDL and DML conversion, and perform the migration.
  • Prepare fallback and reverse replication so data can return to the source when the migration plan requires it.
Official certification objectives
Deploying resilient databasesSee the guide for weighting68 QuestionsPass-IT questions

Put database availability and scaling plans into practice.

  • Provision highly available databases and automate repeatable instance creation.
  • Configure replication across regions and deploy or scale read replicas.
  • Test availability and disaster recovery, and configure monitoring to track the deployed solution.
Official certification objectives
Question formats you can practice
Multiple Choice
Select one answer.
Multiple Response
Select multiple applicable answers.

These are practice formats in Pass-IT. See the Official certification objectives for the official exam requirements.

Frequently asked questions

Your preparation

How much study time should I plan for GCP-PCDB?

For planning, Pass-IT estimates roughly 50–120 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Google Cloud or a promise that you will be exam-ready within that time.

What experience does the Cloud Database Engineer exam assume?

Google Cloud recommends five or more years of overall database work including two years hands-on with its own database services. That is the highest recommended background of any exam in our catalog. Nothing is enforced at booking, but the catalog budget of 80 hours assumes that experience is already there.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Google Cloud for the languages available for the official exam.

How long does my GCP-PCDB access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the GCP-PCDB exam

Where can I take the GCP-PCDB exam?

Pearson VUE (online-proctored or testing center).

How often do you have to recertify as a Cloud Database Engineer?

Every two years, inside the renewal eligibility period. Google Cloud has no continuing-education route, so recertification means sitting an exam rather than logging credits.

How soon can you retake the Cloud Database Engineer exam?

After 14 days for the second attempt, 60 days for the third and 365 days beyond that, capped at four attempts in a two-year period. The escalation is the same across the Google Cloud professional range.

Your preparation for GCP-PCDB

$29.99one-time

12 months of access for GCP-PCDB · No automatic renewal

Buy GCP-PCDB access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days.

Full guarantee terms →

Related certifications

Associate Cloud EngineerAssociate Data PractitionerAssociate Google Workspace AdministratorCloud Digital LeaderAll Google Cloud certifications →