GCP Storage General Flashcards

1
Q

What storage would I use for unstructured data, requiring no analytics?

A

Google Cloud Storage

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

What is Cloud SQL?

A

It is a managed service for Postgres and MySQL

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

Is Cloud SQL structured or unstructured data?

A

Structured data

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

What is Cloud BigTable?

A

It is a manged noSQL database for structured data

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

Is GCP Cloud BigTable, structured database?

A

Yes

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

I have structured data what is my options in GCP for storing such data?

A
  • Cloud SQL
  • Datastore (noSQL)
  • Bigtable (noSQL)
  • Spanner (newSQL)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What options do I have in GCP for unstructured data?

A
  • Google Cloud Storage

- Firebase Cloud Storage

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

How do I choose between relational and non-relational database?

A
SQL
- Consistent
- ACID
-More table
noSQL
- Scalable
- Fewer tables
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

I am building a global scale application dealing with millions of user per min and I require a database, what are my options, SQL or noSQL?

A

noSQL

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

I require a noSQL database, what are my GCP options?

A

Bigtable, Satastore

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

I require a newSQL database, what GCP options do I have?

A

Spanner

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

I require a database for data that will be changing often, I intend to use GCP BigQuery, is this a valid option?

A

No BigQuery is aa data wherehouse and is intended for data storage and analytics, data is intended to be written once and not changed often.

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

I require a SQL database that has lo management, what GCP options do I have?

A

GCP CloudSQL, CloudSQL supports both MySQL and Postgres.

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

For an application, I use MySQL in my data centre and I am migrating to GCP, I also intend to make my application global scale dealing with millions of users per min, can I have GCP ClooudSQL?

A

No google CloudSQL has scale limits as it is a managed version of MySQL and Postgres. An option is to modify the application to use a noSQL option like GCP BigTable or DatStore.

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

Today I operate a MySQL database and intend to move the database to GCP, I need to scale out my the ability to provide my customers with reading operations, I do not need scaleout to write operations, what GCP options do I have when I migrate?

A

Because you what to make little changes to the database, the fastest and easy option are to use a readd replicate. Option to use a noSQL is the wrong option.

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

I require noSQL and ACID tranations, I am lookikng at using GCP Datastore, is this an option?

A

Yes noSQL and ACID as supported by GCP Datastore

17
Q

Is GCP CloudNSQ a noOPS database?

A

It is not a noOPS database, its requires some settig up and configuration at the start.

18
Q

What is the data size sutable for GCP Datastore?

A

0 to TB’s

19
Q

I require a database for petabytes of data with no acid required, database can be nosql, what options do I have?

A

BigTable is a nosql data base with the ability to deal withPB’s of data.

20
Q

I require high volume writes for a nosql database, what options do I have?

A

BigTable supports high volume writes.

21
Q

Is DataStore lower cost and BigTable?

A

Yes, BigTable costs more then DataStore. The reason BigTable cost more is it is designed for PB scale and uses nodes and you have to have a minium of 3 mode running at all times and you are chanrged for the 3 nodes.

22
Q

I have less then a TB of data and require a noSQL database, my options, Bigtable, Datastore. What is my best cost option?

A

DataStore, as it is lower cost then BigTable and still sutable for TB amounts of data?

23
Q

I have PB of data and require a noSQL database, my options, Bigtable, Datastore. What is my best option?

A

BigTable as it can deal with PB of data?

24
Q

What is GCP Spanner?

A

It is a SQL like database, but with better scalability, it horozontaly scales.

25
Q

Has Spanner got SQL?

A

Yes

26
Q

Has Spanner got Schems?

A

Yes

27
Q

Has Spanner got consistancy?

A

Yes

28
Q

Has Spanner got availability?

A

Yes

29
Q

Can Spanner scale outr horozontaly?

A

Yes

30
Q

Has Spanner got atomic replication?

A

Yes

31
Q

Is Spanner a relational database?

A

Yes