20+ practice questions focused on Plan and manage database infrastructure — one of the most tested topics on the Google Professional Cloud Database Engineer exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Plan and manage database infrastructure PracticeYour organization uses Cloud Spanner for a global financial application. You are designing a backup and disaster recovery strategy. Which TWO considerations are important for meeting RPO of 1 hour and RTO of 2 hours?
Explanation: Cloud Spanner's point-in-time recovery (PITR) allows you to restore the database to any point within the retention window (up to 7 days). With a 1-hour RPO, PITR can recover data to within the last hour, meeting the requirement without needing separate backup jobs. Option C is correct because a multi-region Spanner instance uses synchronous replication across regions, ensuring durability and automatic failover within seconds, which satisfies the RTO of 2 hours. Option B is incorrect because Cloud Spanner does not support incremental backups; only full backups are available. Option D is incorrect because while backups can be stored in multi-regional Cloud Storage, this alone does not meet the RPO/RTO as it requires separate backup scheduling and restoration. Option E is incorrect because Cloud Spanner does not use read replicas for failover; it uses multi-region synchronous replication.
A Database Engineer is designing a tiered storage strategy for a large BigQuery dataset. The dataset contains data that is accessed frequently for the first 30 days, moderately for the next 6 months, and rarely after that. The engineer wants to minimize overall storage cost while maintaining fast query performance on recent data. Which approach should the engineer take?
Explanation: Using logical storage billing and partitioning by date allows BigQuery to automatically apply long-term storage discounts to partitions that have not been modified for 90 days. This reduces storage cost for older data without any manual action or data movement. Partitioning by date also enables efficient queries that scan only relevant partitions, maintaining fast performance on recent data. Option D is incorrect because partition expiration deletes the data, not moves it to long-term storage; long-term storage is applied automatically after 90 days of no modifications, not via partition expiration.
A company is planning to migrate a large on-premises MySQL database (5 TB) to Cloud SQL. They need to choose the appropriate Cloud SQL edition. Which two factors should they consider? (Choose two.)
Explanation: Cloud SQL editions have different maximum storage capacities: Enterprise Plus supports up to 30 TB, while Enterprise supports up to 16 TB. For a 5 TB database, the edition must support at least that capacity, making this a key factor. Option D is correct because performance characteristics like maximum IOPS and throughput vary by edition and directly impact database performance, especially for a large 5 TB workload.
Which TWO considerations are critical when migrating from Cassandra to Cloud Bigtable?
Explanation: Cloud Bigtable is a NoSQL wide-column database that does not support joins. Denormalization ensures efficient single-row lookups and avoids performance penalties. Option D is correct because row key design is critical for even distribution across nodes, preventing hotspots. Option C is wrong because Cloud Bigtable provides strong consistency, not eventual consistency, so maintaining eventual consistency is unnecessary when migrating. Options A and E are incorrect: CQL is Cassandra-specific and not supported by Bigtable, and secondary indexes in Bigtable are limited and not recommended for efficient filtering.
A company is migrating their on-premises Oracle database to Cloud SQL for PostgreSQL. They want to minimize downtime during the cutover. Which two strategies should the database engineer recommend? (Choose 2.)
Explanation: Database Migration Service (DMS) with continuous replication is the only strategy that enables minimal downtime migration from Oracle to Cloud SQL for PostgreSQL. DMS handles full data load and ongoing change replication until cutover. Option C (pglogical) is invalid because pglogical only supports replication between PostgreSQL databases, not from Oracle. Option D (read replicas and promote) is not a migration strategy from an external Oracle database; it is for scaling within PostgreSQL. Options A and E involve significant downtime.
+15 more Plan and manage database infrastructure questions available
Practice all Plan and manage database infrastructure questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Plan and manage database infrastructure. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Plan and manage database infrastructure questions on the PCDE frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Plan and manage database infrastructure is tested as part of the Google Professional Cloud Database Engineer blueprint. Practicing with targeted Plan and manage database infrastructure questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free PCDE practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Plan and manage database infrastructure is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Plan and manage database infrastructure practice session with instant scoring and detailed explanations.
Start Plan and manage database infrastructure Practice →