GCP BigQuery Flashcards

1
Q

What is GCP BigQuery?

A

It is an analytics engine, runs queries over data. A data where house.

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

Is GCP BigQuery a managed service?

A

100% yes.

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

What is the query language used by BigQuery?

A

SQL like.

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

What are the interfaces to the GCP BigQiery service?

A

REST, WebUI and ODBC

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

For GCP BigQuery can I connect using ODBC?

A

Yes the ODBS interface is supported

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

For GCP BigQuery, can store an query TB’s of data?

A

Yes, GCP BigQuery is designed for storing and querying TB’s of data

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

Because GCP BigQuery enables you to run SQL to query the data, is BigQuery a database?

A

No, BigQuery is an analytics engine.

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

Is there a limit on the amount of data I can store in GCP BigQuery?

A

No, there is no limit.

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

Is data easy to import to BigQuery?

A

Yes, fast atomic imports

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

What is GCP BigQuery most like from a traditional data analytics perspective?

A

Data where house?

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

Can I store a PC of data in big query?

A

Yes, data storage and query iis unlimited

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

Is GCP BigQuery a row based database where data is ready by rows?

A

No, BgiQuery is a columnar database, data is read in rows, making it much faster to retreive only the relevent data.

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

How much data could I receive form BigQuery in one second?

A

1 TB

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

Is BigQuery a single-tenant compute cluster?

A

No it is a multi-tenant cluster and the cluster is shared between tenants.

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

What is the GCP BigQuery query language?

A

It is SQL

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

What is the BigQuery streaming API?

A

You can make a HTTP request and stream in uptp 100K rowes per sec

17
Q

I have data in GCP Cloud Storage, is it possible to injest into GCP BigQuery?

A

Yes, this is supported, easy.

18
Q

I have data in Hadoope, is it possible to injest into GCP BigQuery?

A

Yes, this is supported, easy.

19
Q

I have data in GCP dataflow, I wnat to store in BigQuery, is this possible?

A

Yes, this is supported.

20
Q

What is a GCP BigQuery connector?

A

It is a link form an external system such as hadoop thet enables the external system to use BigQuery to query data

21
Q

I have a dataset in GCP BigQuery and I need to transform the data and store a copy back in BigQuery, an ETL job, is this somethign I can do?

A

Yes. BigQuery enables you to carryout ETL jobs

22
Q

Is BigQuery expensive to keep data around?

A

No, google says it is easier and costeffective to keep your data then to delete it

23
Q

I have a billion rows in two cloums of data, how long would it take BigQuery to query this data?

A

Approx 5 seconds (Fast)

24
Q

I have a 100 billion rows in two cloums of data, how long would it take BigQuery to query this data?

A

Approx 8 seconds (very Fast) (approx 4TB of data)

25
Q

I have two tables with 1 billion rows in two cloums, how long would it take BigQuery to run a query with a join?

A

Approx 22 seconds (Fast)

26
Q

Is there a CLI for GCP BigQuery?

A

Yes it is called bg

27
Q

I have a CSV file and I would like to load it into BigQuery, do I have a conenctor?

A

No, BigQuery can directly import CSV file

28
Q

I have a JSON file and I would like to load it into BigQuery, do I have a conenctor?

A

No, BigQuery can directly import CSV file

29
Q

I have a Hadoop cluster can I directly import data into BigQuery?

A

No, you have to use the BigQuery conetcor

30
Q

Can I deploy BigQuery across region?

A

No BigQuery is regional and also deployed to one zone service/resource.

31
Q

Can I deploy BigQuery to multi-zones in a single region?

A

No, BigQuery is deployed to a single Zone.