2.3 Planning and configuring data storage options

Question 1

Storage option: not structured data, need mobile SDKs

Answer 1

Cloud Storage by Firebase

Question 2

Storage option: not structured data, don’t need mobile SDKs

Answer 2

Cloud storage

Question 3

Cloud storage

Answer 3

• highly durable and highly available object store
• objects are immutable, but can be overwritten
• stored in buckets, but can’t be nested

Question 4

Storage options provided by Cloud Storage

Answer 4

1. multi-regional
2. regional
3. nearline
4. coldline

Question 5

Storage option for: hosting static website

Answer 5

Cloud Storage

Question 6

Storage option: structured data, for analytics, low latency

Answer 6

BigTable

Question 7

BigTable

Answer 7

• sparsely populated
• lookup by row key
• scalable, high availability, high performance
• for massive amount of data (petabytes)

Question 8

Storage option: structure data, for analytics, don’t need low latency

Answer 8

BigQuery

Question 9

How to calculate cost for BigQuery

Answer 9

UI: query validator
CLI: --dry-run flag
REST: set dryRun flag to true

Then use Pricing Calculator

Question 10

Storage option: structured data, non-analytical, relational, don’t need horizontal scaling

Answer 10

Cloud SQL (supports MySQL and PostgreSQL)

Question 11

Storage option: structured data, non-analytical, relational, horizontal scaling

Answer 11

Cloud Spanner

Question 12

Cloud Spanner

Answer 12

• globally distributed
• strongly consistent
• highly available
• secure
• SQL like syntax

Question 13

Storage option: structured data, non-analytical, non-relational, don’t need mobile SDK

Answer 13

Cloud Datastore

Question 14

Cloud Datastore

Answer 14

• No SQL
• built on BigTable
• SQL like syntax
• can group operations in transactions

Question 15

Storage option: structured data, non-analytical, non-relational, need mobile SDK

Answer 15

Cloud Firebase for Firebase