PCD · topic practice

Design Scalable and Highly Available Cloud Database Solutions practice questions

Q: How should I use these Design Scalable and Highly Available Cloud Database Solutions 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.

Q: Can I practise just Design Scalable and Highly Available Cloud Database Solutions 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 Design Scalable and Highly Available Cloud Database Solutions domain.

Practise Google Professional Cloud Developer Design Scalable and Highly Available Cloud Database Solutions 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: Design Scalable and Highly Available Cloud Database Solutions

Practice 10 questions Browse domain →

What the exam tests

What to know about Design Scalable and Highly Available Cloud Database Solutions

Cloud concepts questions usually test the service model (IaaS/PaaS/SaaS) and deployment model (public/private/hybrid/community) appropriate for a given scenario.

IaaS, PaaS and SaaS responsibilities and examples.

Public, private, hybrid and community cloud deployment models.

On-premises vs cloud trade-offs: cost, control, scalability.

How cloud connectivity options (VPN, Direct Connect, ExpressRoute) work.

Watch out for

Common Design Scalable and Highly Available Cloud Database Solutions exam traps

▸IaaS gives you infrastructure control; SaaS gives you only the application.
▸Hybrid cloud combines on-premises and public cloud — not two public clouds.
▸Cloud does not automatically mean cheaper or more secure.
▸Management responsibility shifts with each service model (IaaS → PaaS → SaaS).

Practice set

Design Scalable and Highly Available Cloud Database Solutions questions

20 questions · select your answer, then reveal the explanation

Question 1easymultiple choice

Read the full Design Scalable and Highly Available Cloud Database Solutions explanation →

A company is migrating an on-premises MySQL 8.0 OLTP application to Google Cloud. The application requires high availability with automatic failover and zero RPO. Which Google Cloud database and configuration should they use?

Trap 1: Cloud Spanner with multi-region configuration

Cloud Spanner is overkill for a simple MySQL migration and does not support MySQL wire protocol.

Trap 2: Cloud SQL for MySQL with read replicas

Read replicas are asynchronous and do not provide automatic failover or zero RPO.

Trap 3: AlloyDB for PostgreSQL with HA

AlloyDB is PostgreSQL-compatible, not MySQL. The application uses MySQL 8.0.

Study all Design Scalable and Highly Available Cloud Database Solutions common traps →

A
Cloud Spanner with multi-region configuration
Why wrong: Cloud Spanner is overkill for a simple MySQL migration and does not support MySQL wire protocol.
B
Cloud SQL for MySQL with read replicas
Why wrong: Read replicas are asynchronous and do not provide automatic failover or zero RPO.
C
AlloyDB for PostgreSQL with HA
Why wrong: AlloyDB is PostgreSQL-compatible, not MySQL. The application uses MySQL 8.0.
D
Cloud SQL for MySQL with HA configuration
HA configuration uses synchronous replication to a standby in the same zone/region, automatic failover, and zero RPO.

Design Scalable and Highly Available Cloud Database Solutions practice questions

What to know about Design Scalable and Highly Available Cloud Database Solutions

Common Design Scalable and Highly Available Cloud Database Solutions exam traps

Design Scalable and Highly Available Cloud Database Solutions questions

A company is migrating an on-premises MySQL 8.0 OLTP application to Google Cloud. The application requires high availability with automatic failover and zero RPO. Which Google Cloud database and configuration should they use?

An e-commerce company is designing a global product inventory system that requires strong consistency across regions, horizontal scaling for millions of users, and 99.999% availability. Which Google Cloud database meets all these requirements?

A mobile app developer wants a serverless NoSQL database that automatically syncs data offline and provides security rules for access control. Which Google Cloud database should they choose?

A financial services company requires a relational database that can handle hybrid transactional/analytical processing (HTAP) workloads with sub-millisecond transactional latency and real-time analytics without ETL. Which Google Cloud database is BEST suited?

An engineer is configuring Cloud SQL for PostgreSQL with HA. They notice that after a failover, the original primary instance does not automatically resume as a standby. What is the likely cause?

Which Google Cloud database service should be used to implement a low-latency session store for a web application that requires pub/sub capabilities and rate limiting?

A company is migrating a Cassandra-based time-series application to Google Cloud. They need to maintain single-digit millisecond write latency at petabyte scale. Which Google Cloud database is the BEST replacement?

An engineer is designing a Cloud Spanner schema for a social media application. The Users table and the Posts table have a parent-child relationship. To optimize read performance for fetching all posts of a user, which schema design approach should be used?

A company is using Cloud Bigtable for ad tech data. They have a single table with a column family containing frequently accessed columns and another with rarely accessed columns. To optimize performance, what column family design change should they implement?

Which Google Cloud database is a serverless data warehouse designed for analytical queries on petabyte-scale data, with SQL interface and built-in machine learning capabilities?

A company is designing a disaster recovery strategy for a global e-commerce platform using Cloud Spanner. They need to ensure that the system can survive a regional outage with minimal data loss and automatic failover. Which TWO configurations should they choose? (Choose 2.)

A company is using Cloud Bigtable for IoT data ingestion. They are experiencing high latency and write throttling. The current row key format is 'device_id#timestamp'. Which THREE actions can help distribute the write load and reduce hotspots? (Choose 3.)

A company is building a real-time leaderboard for an online game using Memorystore for Redis. They need to support millions of concurrent users, update scores frequently, and retrieve top 100 players. Which TWO features should they use? (Choose 2.)

A company needs to store petabytes of time-series IoT sensor data and query it with single-digit millisecond latency at millions of reads per second. The data has a simple key-value structure with timestamps. Which Google Cloud database is MOST appropriate?

You are designing a global e-commerce application with a product catalog that must be strongly consistent across continents and have 99.999% availability. Transactions must span multiple items and maintain ACID guarantees. Which Google Cloud database should you choose?

A startup is migrating an on-premises PostgreSQL 14 database to Cloud SQL. The database is 500 GB and handles OLTP workloads. They want to minimize downtime during migration. Which approach should they use?

You are designing a Cloud Spanner schema for a global user profile table. The primary key is a UUID generated client-side. Users report high write latency and hotspotting on a specific node. What is the most likely cause?

A mobile app needs to synchronize user data across devices with offline support. The data is structured as documents with hierarchical relationships. Which Google Cloud database is best suited for this use case?

Track your progress over time

Start a Design Scalable and Highly Available Cloud Database Solutions only practice session

Related PCD topic practice pages

Manage a Solution that Can Span Multiple Database Systems practice questions

Deploy Scalable and Highly Available Databases in Google Cloud practice questions

Design Scalable and Highly Available Cloud Database Solutions practice questions

Migrate Data Solutions practice questions

Designing highly scalable, available, and reliable cloud-native applications practice questions

Building and testing applications practice questions

Deploying applications practice questions

Integrating Google Cloud services practice questions

Managing application performance monitoring practice questions

PCD fundamentals practice questions

PCD scenario practice questions

PCD troubleshooting practice questions

Frequently asked questions

Track your progress

Study resources

Exam traps to avoid