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 global financial enterprise is re-architecting its core payment processing platform on Google Cloud. The system has the following requirements:
Which Google Cloud database service natively satisfies these requirements?
Firestore in Datastore mode is a highly scalable, serverless NoSQL document database optimized for web and mobile backends requiring automatic scaling and hierarchical document storage.
While Firestore supports multi-document ACID transactions across entity groups, it is a NoSQL document database that lacks relational schema constructs, multi-table relational SQL semantics, and the external consistency guarantees across arbitrarily sharded relational schemas provided by Spanner.
The system required a serverless document store with basic multi-document transaction capabilities for hierarchical entity models.
Cloud SQL is a fully managed relational database service supporting PostgreSQL, MySQL, and SQL Server, offering traditional ACID compliance within a single instance or primary/read-replica architecture.
While Cloud SQL provides full ACID guarantees on a single instance, it relies on vertical scaling for write throughput and does not support native horizontal scale-out for distributed writes or multi-region synchronous ACID transactions.
The application required standard PostgreSQL compatibility within a single primary database instance without requiring horizontal scale-out for writes.
Cloud Bigtable is Google Cloud's sparsely populated, petabyte-scale NoSQL wide-column store designed for high-throughput operational and analytical workloads like IoT telemetry, time-series data, and clickstreams.
Cloud Bigtable supports atomicity and consistency only at the single-row level. It lacks native multi-row or multi-table ACID transaction support, making it unsuitable for distributed ledger workloads requiring strict multi-table relational consistency.
The workload required massive throughput for time-series or streaming data where updates and reads are restricted strictly to individual row keys.
Cloud Spanner is a fully managed, mission-critical, enterprise-grade relational database service designed for global scale. It uniquely combines the structure and ACID compliance of traditional relational databases with the horizontal scalability and high availability of NoSQL systems.
None of the other Google Cloud managed database engines provide both multi-region distributed relational ACID transactions with external consistency and horizontal write scalability.
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