Google Cloud · PCDE
Google Cloud Certified - Professional Cloud Database Engineer (PCDE) Practice Test
Validates expertise in designing, creating, managing, and troubleshooting Google Cloud databases, with focus on scalable and highly available database solutions spanning multiple database technologies.
Exam Details
Questions
608
Duration
120 minutes
Passing Score
Not publicly disclosed
Difficulty
ProfessionalLast Updated
Jan 2025
Topics Covered
Database DesignCloud SQLCloud SpannerBigtableFirestoreData MigrationDatabase SecurityMonitoring and Troubleshooting
Google Cloud Certified - Professional Cloud Database Engineer (PCDE) Practice Exam Preparation
Use this PCDE practice exam to prepare for Google Cloud Certified - Professional Cloud Database Engineer (PCDE) with realistic questions, detailed explanations, and focused study modes. The practice bank includes 608 questions for Google Cloud PCDE, so you can review the exam steadily instead of relying on one long cram session.
As you practice, pay extra attention to recurring topics such as Database Design, Cloud SQL, Cloud Spanner, Bigtable, and Firestore. Start with short sessions to identify weak areas, then move into timed quizzes once your accuracy is consistent.
The explanations are especially useful when you want to connect exam wording to the responsibilities and scenarios described in the official certification guidance. Use the free preview first, then unlock the full question bank when you are ready to build a complete study routine.
Exam Domain Breakdown
Design innovative, scalable, and highly available cloud database solutions32%
Manage a solution that can span multiple database technologies25%
Migrate data solutions23%
Deploy scalable and highly available databases in Google Cloud20%
Exam Overview
The Google Cloud Certified Professional Cloud Database Engineer (PCDE) certification validates the expertise of database professionals who design, create, manage, and troubleshoot Google Cloud databases. Holders of this credential demonstrate the ability to translate complex business and technical requirements into scalable, cost-effective, and highly available database solutions spanning multiple Google Cloud database technologies — including Cloud SQL, AlloyDB, Cloud Spanner, Cloud Bigtable, Firestore, and Memorystore.
The exam covers the full database lifecycle on Google Cloud: from architecting multi-region, regionally resilient deployments to selecting the right storage paradigm (relational, NoSQL, in-memory, vector) for a given workload. Candidates must demonstrate proficiency in database migration strategies, security and IAM configuration, backup and recovery planning (RTO/RPO/PITR), performance monitoring, and troubleshooting. As of its most recent update, the exam also includes coverage of generative AI use cases with Google Cloud databases.
Who Should Take This Exam
This certification is designed for experienced database professionals and cloud engineers who work hands-on with Google Cloud database services. Typical roles include Database Administrators (DBAs), Database Engineers, Cloud Architects, and Backend Engineers who are responsible for provisioning, managing, and optimizing database infrastructure on Google Cloud.
Google recommends candidates have at least 5 years of overall database and IT experience, including a minimum of 2 years of hands-on experience working specifically with Google Cloud database solutions. It is best suited for professionals who regularly make architectural decisions involving trade-offs between relational and NoSQL systems, manage migrations from on-premises or other cloud platforms, and are responsible for database availability and disaster recovery.
Prerequisites
There are no formal prerequisites required to register for the exam. However, Google strongly recommends candidates possess 5 or more years of general database and IT experience, with at least 2 years of practical, hands-on experience working with Google Cloud database products such as Cloud SQL, Cloud Spanner, Bigtable, and Firestore.
Candidates should be comfortable with SQL and NoSQL concepts, IAM and database security models, replication and high availability configurations, data migration tooling, and performance tuning across multiple database engines. Familiarity with the Google Cloud Console, gcloud CLI, and Cloud Monitoring is also beneficial before attempting the exam.
Exam Format
The Professional Cloud Database Engineer exam consists of 50–60 multiple-choice and multiple-select questions. The exam must be completed within 2 hours (120 minutes). It is available in English and can be taken either online via remote proctoring or in person at an authorized Kryterion testing center worldwide. The registration fee is $200 USD plus applicable taxes.
Google does not publicly disclose the passing score threshold. The exam is scored holistically across all domains, so candidates are not required to achieve a minimum score in any individual domain — balanced preparation across all four domains is recommended. Certification is valid for a defined period, after which candidates may renew within an eligible renewal window.
Skills Measured
- 1.Domain 1 – Design innovative, scalable, and highly available cloud database solutions (~32%): Covers selecting the appropriate database product (Cloud SQL, AlloyDB, Spanner, Bigtable, Firestore) based on business and technical requirements; sizing compute and storage for performance and cost; evaluating trade-offs between SQL, NoSQL, and vector storage; designing multi-region, regional, and zonal deployment strategies; planning for high availability and disaster recovery; and addressing generative AI use cases with Google Cloud databases.
- 2.Domain 2 – Manage a solution that can span multiple database technologies (~25%): Covers implementing IAM roles and database-level access controls; monitoring database performance using Cloud Monitoring and Query Insights; managing backup and restore operations including point-in-time recovery (PITR); defining and meeting RTO/RPO objectives; automating database operations; and troubleshooting performance and connectivity issues across Cloud SQL, Spanner, Bigtable, and Firestore.
- 3.Domain 3 – Migrate data solutions (~23%): Covers planning and executing database migrations with minimal downtime; selecting appropriate migration tools (Database Migration Service, Datastream, pg_dump, etc.); performing schema and query conversion including DDL/DML transformation; developing fallback and rollback plans; and handling heterogeneous migrations between database engines and from on-premises to Google Cloud.
- 4.Domain 4 – Deploy scalable and highly available databases in Google Cloud (~20%): Covers provisioning database instances and clusters; configuring read replicas and multi-region replication; setting up and periodically testing HA failover and disaster recovery procedures; configuring network connectivity and Private Service Connect; implementing encryption at rest and in transit; and validating deployment configurations against performance and availability requirements.
Study Tips
- Start with the official Professional Cloud Database Engineer exam guide (PDF available at services.google.com/fh/files/misc/professional_cloud_database_engineer_exam_guide_english.pdf) and map every subtopic to your existing knowledge gaps before building a study schedule.
- Complete Google's official Cloud Database Engineer Learning Path on Cloud Skills Boost (cloudskillsboost.google/paths/22), which includes structured courses, hands-on Qwiklabs, and skill badges covering Cloud SQL, Spanner, Bigtable, and Firestore.
- Practice database selection trade-offs extensively — the exam frequently presents scenarios requiring you to choose between Cloud SQL, AlloyDB, Cloud Spanner, and Bigtable based on consistency, scalability, latency, and cost constraints. Build a comparison matrix for each product.
- Use Google's official sample questions form (linked from the certification page) to calibrate your readiness, then focus remediation on Domain 1 (database design, ~32%) and Domain 3 (migration, ~23%), which together represent over half the exam weight.
- Get hands-on experience with Database Migration Service and Datastream by completing migration labs — migration scenarios are heavily tested and require knowing tool selection, minimal-downtime strategies, and schema conversion specifics that are difficult to learn from reading alone.
- Study IAM roles, VPC configuration, Private Service Connect, and encryption options for each database product, as security and access control questions appear across multiple domains.
- Review the Cloud Monitoring and Query Insights documentation for Cloud SQL and Spanner, and practice interpreting performance metrics and identifying bottlenecks — operational management and troubleshooting questions are prominent in Domain 2.
Career Benefits
Earning the Professional Cloud Database Engineer certification signals to employers a validated, senior-level ability to architect and operate Google Cloud database infrastructure — a skill set in high demand as enterprises migrate legacy database workloads to managed cloud services. Certified professionals are well-positioned for roles such as Cloud Database Engineer, Cloud Infrastructure Architect, Data Platform Engineer, and Site Reliability Engineer with a database specialization.
Google Cloud certifications at the Professional level are widely recognized in the industry and often listed as preferred or required qualifications in job postings at companies running workloads on Google Cloud. While Google does not publish salary data tied to this specific certification, cloud database engineering roles commanding this skill set typically command competitive salaries in line with other Google Cloud Professional-level certifications. The credential complements adjacent certifications such as the Professional Data Engineer and Professional Cloud Architect, and can serve as a differentiator for professionals seeking to specialize in the growing field of cloud-native database management.
Sample Questions
5 sample questions with answers and explanations. Start a practice session to test yourself across all 608 questions.
Preview — answers shown1. You have a Dedicated Interconnect connection between your on-premises network and a Google Cloud region. Your Bare Metal Solution for Oracle database is deployed in a different region. You need to connect to the Oracle machine using its IP address. What should you do?
AAdd a high availability VPN connection between the two regions
BSet the VPC dynamic routing mode to global
CAdd VPC peering between the two regions
DSet the VPC dynamic routing mode to regional
Explanation
Global dynamic routing mode enables cross-region routing for Cloud Router, allowing routes learned via Dedicated Interconnect in one region to be advertised to resources in other regions. This enables connectivity to Bare Metal Solution resources across multiple regions through a single Dedicated Interconnect without explicit peering. Regional routing mode limits route propagation to the local region. VPC peering is unnecessary when using global routing. HA VPN adds complexity and cost when global routing provides the solution.
2. An IoT platform stores device telemetry in Bigtable and device configuration in Firestore. The application needs to display a dashboard showing device status (combining telemetry and configuration). Queries must complete in under 500 milliseconds for 10,000 devices. What approach meets this latency requirement?
AQuery Bigtable and Firestore in parallel, merge results in the application layer
BReplicate Bigtable data to Firestore using Cloud Functions for unified queries
CDenormalize configuration data into Bigtable for single-system queries
DStream both datasets to BigQuery and query the unified view
Explanation
Denormalizing configuration into Bigtable enables single-system queries with predictable low latency. Bigtable can easily serve 10,000 row reads in under 500ms. Configuration changes are typically infrequent, making denormalization practical. Parallel queries to two systems introduce coordination overhead and latency from the slower system. BigQuery is designed for analytics, not sub-500ms operational queries. Replicating Bigtable to Firestore reverses the performance characteristics - Firestore isn't optimized for this query pattern. Strategic denormalization to optimize read paths is a fundamental database design principle, especially when read performance is critical and updates are infrequent.
3. An application uses Cloud Spanner for user data and Cloud Storage for user-uploaded documents. The document metadata (filename, size, upload date) must be transactionally consistent with user records. How should you maintain this consistency?
AImplement two-phase commit between Cloud Spanner and Cloud Storage APIs
BStore document metadata in Cloud Spanner and reference Cloud Storage object paths
CUse Cloud Storage notifications to trigger Cloud Functions that update Cloud Spanner
DStore documents as BYTES columns in Cloud Spanner for transactional consistency
Explanation
Storing metadata in Cloud Spanner provides transactional consistency for the metadata while keeping large binary objects in Cloud Storage (which is optimized for blob storage). The application can atomically update metadata and write the object in a coordinated manner, using the metadata transaction to store the Cloud Storage path. Cloud Storage notifications are asynchronous and don't provide transaction guarantees. Two-phase commit is not supported between Cloud Storage and Cloud Spanner. Storing large documents in Cloud Spanner BYTES columns is inefficient and hits document size limits (10 MB per column). The pattern of metadata in a transactional database with object references is standard for managing structured data alongside binary objects.
4. A financial application migrating from SQL Server to Cloud SQL for SQL Server uses Windows Authentication for user access. How should you handle authentication in Cloud SQL for SQL Server?
AUse Cloud IAM database authentication instead of Windows Authentication
BConfigure Cloud SQL to use Active Directory integration for Windows Authentication
CDeploy SQL Server on Compute Engine to maintain Windows Authentication support
DMigrate to SQL Server Authentication with strong password policies
Explanation
Cloud SQL for SQL Server supports Active Directory integration for Windows Authentication. Configure Cloud SQL to connect to your AD domain (using Managed Microsoft AD or on-premises AD via VPN/Interconnect). This maintains existing authentication patterns and user management. SQL Server Authentication requires user migration and password management changes. Cloud IAM database auth is for Cloud SQL MySQL/PostgreSQL, not SQL Server. Compute Engine defeats managed service benefits.
5. During PostgreSQL to Cloud SQL migration, compliance requires maintaining an auditable record of all data transformations applied during migration. The migration involves data masking of PII and schema modifications. How should you implement auditable migrations?
ADocument all transformations in a migration runbook and store in version control
BImplement ETL pipeline in Cloud Dataflow with transformation logging to BigQuery
CUse Cloud Logging to capture all DMS operations and data transformation events
DEnable Cloud SQL audit logging and Cloud Data Loss Prevention for PII detection
Explanation
Cloud Dataflow pipelines provide programmatic, version-controlled transformation logic. Writing transformation metadata to BigQuery creates queryable audit logs: which records were transformed, what transformations applied, when, and by which pipeline version. This provides comprehensive audit trail for compliance. Dataflow's Apache Beam allows explicit logging of data masking and schema changes. Runbooks aren't programmatically auditable. Cloud Logging captures operational events but doesn't log specific data transformations. Cloud SQL audit logging tracks database access, not migration transformations.
More Google Cloud Practice Exams
Google Cloud Certified - Professional Cloud Architect (PCA)
PCA · 1397 questions
Google Cloud Certified - Professional Cloud DevOps Engineer (PCDOps)
PCDOps · 1132 questions
Google Cloud Certified - Professional Machine Learning Engineer (PMLE)
PMLE · 1100 questions
Google Cloud Certified - Associate Data Practitioner (ADP)
ADP · 1089 questions
Google Cloud Certified - Professional Security Operations Engineer (PSOE)
PSOE · 1089 questions
Google Cloud Certified - Professional Cloud Security Engineer (PCSE)
PCSE · 1075 questions
$17.99
One-time access to this exam
Full access to all 608 questions
Or $15/mo for all 253 exams
Detailed explanations
Free preview stays available