Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
A multinational financial services company is re-architecting its core payment processing and ledger management system on Google Cloud. The system architecture must satisfy the following technical requirements:
Which database solution and schema design strategy should the company implement?
Cloud Spanner is a fully managed, mission-critical relational database service designed for global scale, zero scheduled downtime, and strict transactional consistency (ACID). It provides horizontal scaling across regions while maintaining relational schema structures, secondary indexes, and SQL support.
Ledger rows with their parent Customer row in the same split. This allows queries that join parent and child data on the primary key hierarchy to execute locally within the same storage split, avoiding distributed cross-process network hops.Cloud Spanner is the only fully managed Google Cloud database engine designed specifically to deliver global relational transactions with sub-10ms latencies alongside schema-level features like table interleaving and fine-tuned primary key distribution.
This option configures Cloud Spanner within a single Google Cloud region and uses standard, non-interleaved relational tables indexed with sequential timestamps.
The workload were strictly local to a single region and primary keys were generated via distributed random hashing rather than sequential timestamps.
Cloud Storage is an object store for unstructured and semi-structured data, and BigLake with Apache Iceberg is an open-format data lakehouse architecture designed for batch and streaming analytical processing.
The goal was to build an enterprise analytical data lakehouse for running business intelligence reports and ad-hoc aggregations over historical ledger logs.
Analytical lakehouse engines complement operational engines like Spanner by ingesting change streams for downstream reporting, but they cannot replace the primary operational transaction tier.
Cloud Bigtable is a sparsely populated, distributed NoSQL wide-column store optimized for massive read and write throughput at sub-10 millisecond latency on single-keyed lookups, analytical scans, and streaming workloads.
The workload was a real-time, petabyte-scale IoT or time-series event ingestion system where queries are strictly single-key lookups or sequential scans without relational joins or multi-entity ACID constraints.
While Bigtable excels at operational analytics and high-volume key-value lookups, it cannot replace a transactional relational database like Cloud Spanner for financial ledgers.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated