Storage in the Cloud (advanced) Flashcards

A set of general and more detailed questions around cloud storage options.

1
Q

List Google’s core storage options?

A

Cloud Storage, SQL, Spanner, Datastore, Firestore, BigTable

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

What type of storage is Cloud storage?

A

Object storage (not file or block storage)

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

Name Google’s object storage service?

A

Cloud Storage

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

How do you reference objects stored in Cloud Storage?

A

By a URL

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

Why does Cloud Storage interact well with Web technologies?

A

Because the unique object references can be defined as URLs.

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

What is Cloud Storage?

A

A fully managed, scalable, high durability and high availability object storage service.

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

Which storage service would you use for a Website?

A

Cloud Storage

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

Which storage service would you use for archival and/or disaster recovery?

A

Cloud Storage

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

Which storage service would you use for distributing large data objects to your end users via direct download?

A

Cloud Storage

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

How are object organised in Cloud Storage?

A

In Buckets

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

Can you re-use the same bucket name in a different project?

A

No, by definition the bucket name is globally unique.

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

What are the 3 attributes you need to specify when creating a bucket?

A
  1. A Globally Unique Name, 2. A Geographic location, 3. A default storage class
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Can you edit objects stored in Cloud Storage?

A

No: objects are immutable

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

How does Google secure data transit for Cloud Storage?

A

HTTPS - data is encrypted on the server side before it is written to disk

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

How does Google apply modifications to a given object when version control is disabled?

A

It overwrites the definition of the original object.

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

What life cycle management policies can you define on Cloud Storage?

A

Delete objects based on age, creation date or number of versions (keep x most recent).

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

When enabling Cloud Storage version control, what should you do?

A

Define a life cycle management policy to avoid bloat.

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

At what level is version control defined in Cloud Storage?

A

Bucket level (not object).

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

What does ACL stand for?

A

Access Control List

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

What storage classes can you choose from for Cloud Storage?

A

Multi‑regional, Regional, Nearline and Coldline.

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

Which storage classes would you choose from for backup and archival?

A

Nearline or Coldine

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

Which storage classes would you choose from for high-performance access?

A

Multi-regional or Regional

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

Order storage classes in descending order of storage price?

A

Multi-regional, Regional, Nearline, Coldine

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

Order storage classes in descending order of retreival price?

A

Coldline, Nearline, Regional, Multi-regional

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

What is the intended access frequency of nearline storage?

A

Once a month or less.

26
Q

What is the intended access frequency of coldine storage?

A

Less than once a year.

27
Q

What storage class would you use for data archival?

A

Coldine

28
Q

What storage class would you use for disaster recovery?

A

Coldine

29
Q

What storage class would you use for backups (you might need to access within 30 days)?

A

Nearline

30
Q

What is the minimum number of days storage you are committing to when you opt for coldline storage?

A

90 days

31
Q

What unit of measure is used to charge for Cloud Storage?

A

Gb of stored data / Month

32
Q

Do egress and data transfer charges apply when accessing Cloud Storage?

A

Yes

33
Q

How do you transfer small objects into Cloud Storage?

A

Online using gsutil command line or drag-and-drop in GCP Console.

34
Q

How do you transfer large volumes (terabytes - TB) of data to Cloud Storage?

A

(Online) Storage Transfer Service, (Offline) Transfer Appliance.

35
Q

What type of source points can the Transfer Storage Service schedule and manage batch transfers into Cloud Storage?

A

From: another cloud provider, a different Cloud Storage region, or an HTTPS endpoint.

36
Q

What is the Transfer Appliance?

A

A rackable server with high capacity storage that you lease from Google.

37
Q

How do you use Google’s data Transfer Appliance?

A

Connect it to your network, load it with data, and then ship it to an upload facility where the data is uploaded to Cloud Storage.

38
Q

What is the maximum capacity of a given transfer Appliance?

A

Up to a petabyte (PB) of data

39
Q

What type of DB is Cloud Bigtable?

A

No SQL

40
Q

Which NoSQL DB options can you choose from?

A

Cloud Bigtable, Firestore, Datastore, Memorystore and Firebase Realtime Database

41
Q

Which DB technology open source API does Cloud Bigtable use?

A

HBase - which is the native database for the Apache Hadoop project

42
Q

What simplifies portability between HBase and Bigtable?

A

They both use the same open source API.

43
Q

Which 3 types of application APIs coud you use to read/write data to Cloud Bigtable?

A

A data service layer like managed VMs, the HBase REST Server, a Java server using the HBase client.

44
Q

Which 3 stream processing frameworks can you use to read/write data to Cloud Bigtable?

A

Cloud Dataflow streaming, Spark streaming or Storm

45
Q

Which 3 batch processing frameworks can you use to read/write data to Cloud Bigtable?

A

Cloud Dataflow, Spark or Hadoop MapReduce

46
Q

What 3 different ways do you have to read/write to Cloud Bigtable?

A

Realtime, streaming or batch processes.

47
Q

What does RDBMS stand-for?

A

Relational Database Management System

48
Q

Which GCP services allow you to set up a relational database (as opposed to a NoSQL DB)?

A

Cloud SQL, Cloud Spanner and BigQuery

49
Q

Which DB engines can you select from in Cloud SQL?

A

MySQL, PostgreSQL and SQLServer

50
Q

What is Google Cloud SQL?

A

A managed service for relational databases

51
Q

Which cloud storage options support transactions?

A

Cloud SQL, Spanner, Datastore, Firestore and Bigtable (but only single row)

52
Q

Does BigQuery support transactions?

A

No

53
Q

Which cloud storage options would you use for blob storage?

A

Cloud Storage

54
Q

Which cloud services support complex SQL queries?

A

Cloud SQL, Cloud Spanner and BigQuery

55
Q

Which cloud storage options support Petabytes+ of data capacity?

A

Bigtable, Cloud Datastore, Firestore and BigQuery

56
Q

What is the max unit size for a Cloud Datastore object?

A

1 MB / unit

57
Q

What is the max unit size for a Bigtable object?

A

~10 MB / cell, ~100 MB / row

58
Q

What is the max unit size for a Cloud Storage object?

A

5 TB / Object

59
Q

What detemines the max unit size for a Cloud SQL object?

A

The DB engine you’ve selected (MySQL or PostgreSQL)

60
Q

What is the max unit size for a Cloud Spanner row?

A

10,240 MiB (Mebibyte = 2^20 bytes) / row

61
Q

What is the max unit size for a BigQuery row?

A

10 MB / row

62
Q

Excluding Cloud SQL options, list cloud storage options in ascending order of row size they support?

A

BigQuery (10 MB), Bigtable (100 MB), Cloud Spanner (10,240 MiB - mebibytes)