Diagram
A decision tree branching on data type and workload to choose among Cloud Storage, BigQuery, Cloud SQL, Spanner, Bigtable, and Firestore.
What Each of the Six Services Does Best
Each of the six data services matches a different workload pattern for transactions, operations, or analytics. Cloud Storage fits unstructured retention such as images, backups, and data lake files. Cloud SQL fits regional transactions with MySQL, PostgreSQL, or SQL Server, while Cloud Spanner fits globally consistent transactions with horizontal scale and strong consistency across regions.
Cloud Bigtable is a wide-column NoSQL database for massive operational throughput with high throughput and low latency, but it does not support complex joins or multi-row transactions. BigQuery is a serverless warehouse with columnar storage and SQL for large-scale analytics, with data flowing from Cloud Storage and software-as-a-service apps into BigQuery. Firestore, also called Cloud Firestore, is a document NoSQL database with schema flexibility, real-time sync, offline support, and automatic scaling for mobile, web, and IoT apps, where data flows from one client to Firestore and then to other connected clients.
Domain 2 of 3
166 practice questions
Practice this DomainLast updated