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 1easymultiple choice

Read the full Plan and manage database infrastructure explanation →

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?

Trap 1: Use Database Migration Service to failover to a read replica.

Failover is for availability, not diagnosing latency.

Trap 2: Use gcloud sql instances describe to check instance configuration.

This command shows metadata, not real-time performance.

Trap 3: Use VPC Flow Logs to analyze network traffic.

VPC Flow Logs capture network flows, not database query performance.

Study all Plan and manage database infrastructure common traps →

A
Use Database Migration Service to failover to a read replica.
Why wrong: Failover is for availability, not diagnosing latency.
B
Use Cloud SQL Insights to analyze query performance and identify slow queries.
Cloud SQL Insights provides query-level performance diagnostics without downtime.
C
Use gcloud sql instances describe to check instance configuration.
Why wrong: This command shows metadata, not real-time performance.
D
Use VPC Flow Logs to analyze network traffic.
Why wrong: VPC Flow Logs capture network flows, not database query performance.

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

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?

Your organization uses Cloud Spanner for a global financial application. You are designing a backup and disaster recovery strategy. Which THREE considerations are important for meeting RPO of 1 hour and RTO of 2 hours?

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?

A Database Engineer is responsible for managing a Cloud SQL for MySQL instance. The engineer needs to ensure that automated backups are retained for 14 days and that point-in-time recovery (PITR) is enabled. Which configuration should the engineer set?

A company runs a critical application on Cloud SQL for PostgreSQL. The database engineer needs to ensure that if the primary instance fails, a standby instance in a different region can take over with minimal data loss. Which configuration should the Database Engineer implement?

Track your progress over time

Start a Plan and manage database infrastructure only practice session

Related PCDE topic practice pages

Plan and manage database infrastructure practice questions

Define data structures and implement SQL for Business Intelligence 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