Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Professional Cloud Database Engineer practice bank has an additional 769 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
An e-commerce company is building two microservices on Google Cloud:
Which database architecture should the company select?
Bigtable is a petabyte-scale, wide-column key-value NoSQL database engineered for ultra-high throughput and consistent single-digit millisecond latency. While it is schemaless and stores sparse columns flexibly per row, its data model and query engine differ sharply from a document database.
The Product Catalog Service needed to ingest hundreds of thousands of writes per second at sub-10ms latency with predictable row-key prefix lookups, rather than flexible multi-attribute document queries and multi-item transactions.
Firestore is a fully managed, serverless, document-oriented NoSQL database designed for storing semi-structured data as collections of documents. Cloud SQL is a fully managed relational database management system (RDBMS) supporting MySQL, PostgreSQL, and SQL Server for structured online transaction processing (OLTP) workloads.
Attempting to force semi-structured, rapidly evolving data into a rigid SQL table creates constant migration overhead, whereas forcing normalized relational billing records into a NoSQL store shifts join and constraint enforcement into application code. Aligning each microservice with the engine built for its data structure and schema governance model maximizes developer agility and data integrity.
Firestore is a schemaless document-oriented NoSQL database that stores records as JSON-like documents organized into collections. Because it does not enforce a fixed schema at the database layer, documents in the same collection can hold different fields and data types.
NOT NULL constraints across a table at write time. Shifting financial validation entirely to application code increases the risk of inconsistent records when multiple services write data.The Financial Billing Service used self-contained, hierarchical documents with minimal cross-entity joins and did not require database-enforced relational constraints or complex SQL reporting.
Cloud SQL is a fully managed relational database service that stores data in highly structured tables of rows and columns. It relies on Data Definition Language (DDL) statements—such as CREATE TABLE and ALTER TABLE—to enforce a strict schema-on-write contract for every record inserted or updated.
NULL values, complicating queries and application models.Both microservices managed uniform, strictly structured data with rare schema changes and both required complex multi-table SQL joins and database-enforced foreign keys across entities.
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