Data Consistency Google Professional Data Engineer GCP

Selecting Specific Application

• For a relational database with full SQL support for an online transaction processing (OLTP) system, consider Cloud SQL.
• If data is not highly structured or no need for ACID transactions Cloud Bigtable is apt.
• For interactive querying in an OLAP system, BigQuery is suitable.
• For storing large immutable blobs, like large images or movies, Cloud Storage is suitable.
• Strong consistency – entity groups (this will slow down writes to 1 per second), regular read and write
• Eventual consistency – global entities, indexes