GCP Storage Offerings Flashcards

1
Q

GCP NoSQL Storage Options

A
  • Cloud Datastore - NoSQL Document Storage
  • Cloud Bigtable - NoSQL Wide column
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

GCP Blob Storage

A

Cloud Storage - Binary or Object data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

GCP SQL offerings

A
  • Cloud SQL - Relational SQL for OLTP (transactional)
  • Cloud Spanner - Relational SQL for OLTP (transactional)
  • BigQuery - - Relational SQL for OLAP (analytical)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

GCP Storage Option Best for:

Getting started and App engine Applications

A

Cloud Datastore

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

GCP Storage Option Best for:

“Flat” data, Heavy read/write, events, Analytical data

A

Cloud Bigtable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

GCP Storage Option Best for:

Structured and unstructured data

binary and object data

A

Cloud Storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

GCP Storage Option Best for:

Web frameworks and existing applications

A

Cloud SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

GCP Storage Option Best for:

Large-scale database applications (>~2TB)

A

Cloud Spanner

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

GCP Storage Option Best for:

Interactive Querying, offline analytics

A

BigQuery

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

GCP Storage Use Cases:

Getting started, app engine applications

A

Cloud Datastore

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

GCP Storage Use Cases:

Adtech, financial and IoT data

A

Cloud Bigtable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

GCP Storage Use Cases:

Images, large media files, backups

A

Cloud Storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

GCP Storage Use Cases:

User credentials, customer orders

A

Cloud SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

GCP Storage Use Cases:

Whenever high I/O, global consistency is needed

A

Cloud Spanner

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

GCP Storage Use Cases:

Data warehousing

A

BigQuery

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is Firebase?

A

Google’s mobile development platform that shares 3 products with GCP:

Cloud Firestore, Cloud Functions, and Cloud Storage

17
Q

What is Cloud Datastore

(Type/Transactions/Complex Queries/Capacity/Unit Size)

A
  • Type: NoSQL document
  • Transactions: Yes
  • Complex queries: No
  • Capacity: TB+
  • Unit Size: 1 MB per entity
18
Q

What is Bigtable

(Type/Transactions/Complex Queries/Capacity/Unit Size)

A

Cloud Bigtable stores data in a file system called Colossus, which contains
data structures called Tablets that are used to identify and manage the data. Metadata about the Tablets is what is stored on the VMs in the Bigtable cluster itself.

  • Type: NoSQL wide column
  • Transactions: Single-Row
  • Complex queries: No
  • Capacity: PB+
  • Unit Size: ~10 MB/Cell; ~100 MB/Row
19
Q

What is Cloud Storage

(Type/Transactions/Complex Queries/Capacity/Unit Size)

A
  • Type: Blobstore
  • Transactions: No
  • Complex queries: No
  • Capacity: PB+
  • Unit Size: 5 TB/object
20
Q

What is Cloud SQL

(Type/Transactions/Complex Queries/Capacity/Unit Size)

A
  • Type: Relational SQL for OLTP (Transactions)
  • Transactions: Yes
  • Complex queries: Yes
  • Capacity: TB+
  • Unit Size: Determined by DB Engine
21
Q

What is Cloud Spanner

(Type/Transactions/Complex Queries/Capacity/Unit Size)

A
  • Type: Relational SQL for OLTP (transactions)
  • Transactions: Yes
  • Complex queries: Yes
  • Capacity: PB
  • Unit Size: 10,240 MiB/Row
22
Q

What is BigQuery

(Type/Transactions/Complex Queries/Capacity/Unit Size)

A
  • Type: Relational SQL for OLAP (Analytics)
  • Transactions: No
  • Complex queries: Yes
  • Capacity: PB+
  • Unit Size: 10 MB/row
23
Q

What is ACID?

A
  • Atomic - a transaction is all or nothing
  • Consistent - a transaction meets all requirements/validation rules
  • Isolated - a transaction will not affect, or be affected, by other transactions
  • Durability - a transaction that completed is persistent even under failure conditions
24
Q

What is BASE?

A
  • Basically Available - The database appears to work most of the time
  • Soft-state - data stores and replicas do not have to be write-consistent
  • Eventual consistency - data stores and replicas will eventually be consistent
25
Q

What are the 4 Cloud Storage Classes

A
  • Standard
  • Nearline
  • Coldline
  • Archive
26
Q

Storage Class Use case:

Access data frequently (“hot” data) and/or store data for brief periods

  • Serve Website content
  • Stream videos
  • Interactive workloads
  • Mobile and gaming apps
A

In this scenario, Standard Storage would be best

27
Q

Storage Class Use case:

Read/modify data ≤ once per month

  • Data backup
  • Serve long-tail multimedia content
A

Nearline storage would work well here. It has a minimum duration of 30 days.

28
Q

Storage Class Use case:

Read/modify data no more than once a quarter

A

Coldline storage: 90 day minimum duration

29
Q

Storage Class Use case:

Read/modify data < once a year

  • Cold data storage
  • Disaster recovery
A

Archive Storage with a minimum duration of 365 days