Skip to content

Design innovative, scalable, and highly available cloud database solutions Questions

Practice questions for Design innovative, scalable, and highly available cloud database solutions topic in Google Professional Cloud Database Engineer. 65 questions covering this domain.

65 questions18 easy33 medium14 hard
Q1
medium

An IoT workload must ingest very high write volume and serve low-latency reads on semi-structured time-series data. Which database is most appropriate...

Q2
medium

A globally distributed application uses Spanner and most write traffic now originates near one region. Which action best reduces write latency?

Q3
medium

A payment platform needs a relational database for a global ledger, requires strong ACID transactions, and cannot accept manual sharding. Which design...

Q4
medium

A retailer wants to run business intelligence queries directly on its operational PostgreSQL database without affecting transactional performance. Whi...

Q5
hard

A PostgreSQL-based SaaS platform needs horizontal read scaling with low lag, wants to remain 100 percent PostgreSQL compatible, and may later add a se...

Q6
medium

A company must standardize on the AlloyDB engine across Google Cloud, its own data center, and other clouds. Which product should it deploy?

Q7
hard

A regional PostgreSQL workload needs managed high availability and automatic failover within one region, but it does not need global consistency or un...

Q8
medium

A mobile shopping app needs offline-capable clients and real-time updates to many connected users. Which database best matches those requirements?

Q9
medium

A team runs a standard PostgreSQL application and wants full PostgreSQL compatibility with much higher transactional performance than self-managed Pos...

Q10
easy

Which Google Cloud database is a wide-column and key-value service intended for low-latency, high-throughput workloads?

Q11
easy

Which Google Cloud database is a serverless document database with built-in real-time synchronization for mobile and web applications?

Q12
hard

An ad platform wants sub-100 ms access close to users in multiple regions and can tolerate asynchronous replication between regions. Each regional clu...

Q13
medium

A company wants the easiest lift-and-shift of a standard PostgreSQL workload to Google Cloud and prefers the lowest-cost managed relational option. Wh...

Q14
easy

Which Google Cloud database is built for strong transactional consistency across regions and horizontal scaling for both reads and writes?

Q15
hard

A global commerce company needs a single source of truth for orders and inventory, requires serializable transactions, and expects worldwide traffic g...

Q16
easy

Which AlloyDB capability is specifically designed to accelerate analytical queries on operational PostgreSQL data?

Q17
medium

An architect evaluates Bigtable versus Spanner for a new workload. The workload requires multi-row transactions with strong consistency across arbitra...

Q18
easy

Which Google Cloud NoSQL database is purpose-built for caching and session storage with in-memory speed and supports both Redis and Memcached?

Q19
medium

A Spanner database has a parent-child interleaved relationship. What is the main performance benefit of interleaving?

Q20
hard

An AlloyDB workload experiences high CPU when analytical dashboards run alongside OLTP queries. The team wants to serve analytical queries from a dedi...

Sign in to see all 65 questions

Create a free account to browse all questions — completely free during our launch phase.