Ch. 2 Storage and Databases

When should you store data in Cloud Storage?

when data is unstructured

When should you store data in Cloud Spanner?

when data is structured, needs to be analyzed, relational, and needs to scale

When should you store data in Cloud SQL?

when data is structured, needs to be analyzed, relational, and does not need to scale

When should you store data in Cloud Firestore?

when data is semi-structured, does not need to be analyzed, nonrelational, NoSQL

When should you store data in Cloud Bigtable?

when data is structured, needs to be analyzed, and needs low latency

When should you store data in BigQuery?

when data is structured, needs to be analyzed, and does not need low latency

When should you store data in Cloud Memorystore?

when your app needs a Redis key value in memory DB

What are the 3 steps in Data Modeling?

conceptual, logical, physical

What is Lifecycle Management?

an automation script that manages objects storage tier, based on a condition

What makes Cloud Spanner special?

its a SQL storage service that is able to scale horizontally, while being highly available and consistent

Your application requires access to a Cloud Storage bucket. What is the best way to achieve this?

create a custom service account that uses principle of least privilege

What is the best way to grant someone temporary access to a file if they do not have a Google account?

use a signed URL with an expiration date

How are Cloud SQL/ PostgreSQL instances High Availability?

instances share a regional replicated persistent disk