How should I use these Plan and manage database infrastructure practice questions?

Read each scenario carefully and choose your answer before revealing the explanation. Then check why your choice was right or wrong. Repeat until the reasoning feels automatic.

PCDE · topic practice

Plan and manage database infrastructure practice questions

Q: Can I practise just Plan and manage database infrastructure questions in a focused session?

Yes — use the session launcher on this page to start a 10-, 20-, 30- or 50-question session drawn entirely from the Plan and manage database infrastructure domain.

Practise Google Professional Cloud Database Engineer Plan and manage database infrastructure practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security

20 questionsDomain: Plan and manage database infrastructure

Practice 10 questions Browse domain →

What the exam tests

What to know about Plan and manage database infrastructure

Plan and manage database infrastructure questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Plan and manage database infrastructure exam traps

▸Answering from memory before reading the full scenario.
▸Missing a constraint such as cost, availability, security, scope or command context.
▸Choosing a broad answer when the question asks for the most specific fix.
▸Ignoring why the wrong options are tempting.

Practice set

Plan and manage database infrastructure questions

20 questions · select your answer, then reveal the explanation

Question 1hardmulti select

Read the full Plan and manage database infrastructure explanation →

Your 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?

Trap 1: Schedule incremental backups every hour using Cloud Scheduler.

Cloud Spanner does not support incremental backups; only full backups are available, and scheduling backups with Cloud Scheduler is not the recommended approach for meeting a 1-hour RPO.

Trap 2: Store backups in a multi-regional Cloud Storage bucket.

Spanner backups are stored within the instance's location; you can export to Cloud Storage but that is separate.

Trap 3: Set up read replicas in a different region for failover.

Spanner does not use read replicas; multi-region instances handle failover.

Study all Plan and manage database infrastructure common traps →

A
Enable point-in-time recovery (PITR) with a 7-day retention.
PITR allows recovery to any point within the retention period, meeting RPO.
B
Schedule incremental backups every hour using Cloud Scheduler.
Why wrong: Cloud Spanner does not support incremental backups; only full backups are available, and scheduling backups with Cloud Scheduler is not the recommended approach for meeting a 1-hour RPO.
C
Configure a multi-region Spanner instance to survive a regional outage.
Multi-region instances provide automatic failover for DR.
D
Store backups in a multi-regional Cloud Storage bucket.
Why wrong: Spanner backups are stored within the instance's location; you can export to Cloud Storage but that is separate.
E
Set up read replicas in a different region for failover.
Why wrong: Spanner does not use read replicas; multi-region instances handle failover.

Plan and manage database infrastructure practice questions

What to know about Plan and manage database infrastructure

Common Plan and manage database infrastructure exam traps

Plan and manage database infrastructure questions

Your 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?

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.)

Which TWO considerations are critical when migrating from Cassandra to Cloud Bigtable?

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.)

A company runs a production Cloud SQL for PostgreSQL instance used by a web application. The instance experiences intermittent latency spikes during peak hours. You need to diagnose the cause without downtime. Which tool should you use first?

A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. The database is 2 TB in size and the network bandwidth to Google Cloud is limited to 500 Mbps. The migration window is 48 hours. Which migration strategy should the Database Engineer recommend?

A financial services company uses Cloud Spanner for transaction processing. They need to ensure zero downtime during a schema change that adds a new column with a default value to a large table. Which approach should the Database Engineer take?

A company runs a BigQuery data warehouse. They notice that query performance has degraded over time. The data is loaded daily from Cloud Storage using batch loads. Which action is most likely to improve query performance?

A gaming company uses Memorystore for Redis to cache player session data. They need to ensure high availability with automatic failover in case of a zone failure. Which configuration should the Database Engineer choose?

A company is designing a global application using Cloud Spanner. They need to ensure low latency reads and writes across three continents. Which TWO configurations should they consider?

A company is migrating their on-premises MySQL database to Cloud SQL. The database is 500 GB and they have a 1 Gbps network connection. They want to minimize downtime. Which THREE steps should they take?

Your company runs a critical PostgreSQL database on Cloud SQL. You need to minimize downtime during a schema migration that could take up to 30 minutes. What should you do?

Your team is migrating a 5 TB MySQL database from on-premises to Cloud SQL. The database receives 2,000 writes per second and the network link has 500 Mbps bandwidth. You need to minimize migration time with zero data loss. What should you do?

Your organization requires that all database backups be stored in a different region for disaster recovery. You are using Cloud SQL for MySQL. What backup configuration should you use?

You are designing a database architecture for a global e-commerce application. The application requires low-latency reads in multiple regions and must handle up to 100,000 writes per second globally. Which Google Cloud database solution should you use?

Your team uses Cloud SQL for PostgreSQL and needs to run a one-time data correction query that will update 10 million rows. The instance has 8 vCPUs and 30 GB memory. The query is currently running for hours and impacting production performance. What should you do?

Your company is migrating a 2 TB SQL Server database to Cloud SQL. You need to choose a migration approach that minimizes downtime and supports ongoing changes. Which TWO options meet these requirements?

You run the above command to create a Spanner instance. Later, you need to increase the instance's compute capacity to handle higher traffic. What is the correct approach?

Exhibit

A company is migrating an on-premises PostgreSQL database to Cloud SQL. The database is 2 TB and must have minimal downtime during migration. Which migration strategy should the Database Engineer recommend?

Track your progress over time

Start a Plan and manage database infrastructure only practice session

Related PCDE topic practice pages

Design innovative, scalable, and highly available cloud database solutions practice questions

Manage a solution that can span multiple database technologies practice questions

Migrate data solutions practice questions

Deploy scalable and highly available databases in Google Cloud practice questions

Plan and manage database infrastructure practice questions

Design and implement database schemas practice questions

Monitor and optimize database performance practice questions

PCDE fundamentals practice questions

PCDE scenario practice questions

PCDE troubleshooting practice questions

Frequently asked questions

Track your progress

Study resources

Exam traps to avoid