GCP BigTable Flashcards

1
Q

Is BigTable a low-cost database for production?

A

No, BigTable required a minimum of 3 nodes to form a cluster with a cluster costing $1500pm.

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

I have 3 BigTable nodes and I have reached the max transactions per second, what can I do to increase traction per second?

A

BigTable scaled by adding more nodes, you would add one or more nodes. This si the same for storage.

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

Is GCP BigTable a global service?

A

No, Nodes are deployed in a single zone in a region. You can deploy a replica cluster in a separate zone in the same region.

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

Is GCP BigTable a noSQL database?

A

Sort of, it is what we call a wide column database, its a sort of persistent hash table. There is only one index, the key.

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

Is GCP BigTable a wide column database?

A

Yes

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

What type of DB is BigTable?

A

It is a wide column database, a sort of persistent hash table, there is only one index on the row, the key.

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

Can I store large amounts of data?

A

Yes BigTables is designed for petabytes, it’s not good for data below 1TB.

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

Is BigTable slow to put data in?

A

No, big tables is very fast, you can stream high through put into the database.

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

Is BigTable a DB that has managed nodes or is it just a service you use?

A

It is a service with managed nodes, where the n ode are managed by Google for you.

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

Is BigTable restricted to a region or a zone?

A

A zone, but you can have another replica cluster in a separate zone with in a region.

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

Can you scale out the node count to 1000nds of nodes?

A

Yes, BigTable scales very well.

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

Can we refer to BigTable as a single key database?

A

Yes, this is because BigTable has just one index on the key.

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

I need to use HBase, is the supported by BigTable?

A

Yes, 100%, HBase is a supported interface

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

I have an existing cluster and I need to process a workload just once off, what are my options?

A

Increase the number of BigTable nodes and decrease after you finish processing workload.

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

Is creating a BigTable cluster fast?

A

Yes, 1 to 2 seconds

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

Should I be concerned about the performance of BigTable , it is is a fully managed service of BigTable?

A

No, BigTable will split data and place it into new nodes as needed.

17
Q

I have 50 node BigTable cluster and I am storing data, do i use a sequential key or random key?

A

Use a random key, this will ensure data is distributed across all nodes in the cluster.

18
Q

Is data compressed in BigTable?

A

Yes

19
Q

I have less then 1TB of data, is BigTable a good solution.

A

No, BigTable is designed for large scale data sets, you need to be storing data above 1TB.

20
Q

What sort of data type is BigTable good for?

A

-Time-series data
-Marketing data
-Graph data
Internet of things data

21
Q

If the BigTable master sees a spike in a table, what will it do?

A

It will split the table and distribute between nodes.

22
Q

Why do we want to have distributed write sand reads in the BigTable cluster?

A

Distributed reads and writes ensure scaleability.

23
Q

I have a data set less than 1TB, is BigTable a good option?

A

No the cost of running BigTable is 3 modes in a zone and you may possibly have a replication cluster of 3 nodes in another zone.

24
Q

Is BigTable multi-region?

A

No, BigQuery clusters are created in a single zone in a region with the option to create a replication cluster in a separate zone.

25
Q

I require HBase interface compatable storage, what GCP options do i have?

A

BigTable has compatible HBase interface.