GCP BigQuery

Question 1

What is GCP BigQuery?

Answer 1

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

Question 2

Is GCP BigQuery a managed service?

Answer 2

100% yes.

Question 3

What is the query language used by BigQuery?

Answer 3

SQL like.

Question 4

What are the interfaces to the GCP BigQiery service?

Answer 4

REST, WebUI and ODBC

Question 5

For GCP BigQuery can I connect using ODBC?

Answer 5

Yes the ODBS interface is supported

Question 6

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

Answer 6

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

Question 7

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

Answer 7

No, BigQuery is an analytics engine.

Question 8

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

Answer 8

No, there is no limit.

Question 9

Is data easy to import to BigQuery?

Answer 9

Yes, fast atomic imports

Question 10

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

Answer 10

Data where house?

Question 11

Can I store a PC of data in big query?

Answer 11

Yes, data storage and query iis unlimited

Question 12

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

Answer 12

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

Question 13

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

Answer 13

1 TB

Question 14

Is BigQuery a single-tenant compute cluster?

Answer 14

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

Question 15

What is the GCP BigQuery query language?

Answer 15

It is SQL

Question 16

What is the BigQuery streaming API?

Answer 16

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

Question 17

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

Answer 17

Yes, this is supported, easy.

Question 18

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

Answer 18

Yes, this is supported, easy.

Question 19

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

Answer 19

Yes, this is supported.

Question 20

What is a GCP BigQuery connector?

Answer 20

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

Question 21

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?

Answer 21

Yes. BigQuery enables you to carryout ETL jobs

Question 22

Is BigQuery expensive to keep data around?

Answer 22

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

Question 23

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

Answer 23

Approx 5 seconds (Fast)

Question 24

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

Answer 24

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

Question 25

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

Answer 25

Approx 22 seconds (Fast)

Question 26

Is there a CLI for GCP BigQuery?

Answer 26

Yes it is called bg

Question 27

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

Answer 27

No, BigQuery can directly import CSV file

Question 28

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

Answer 28

No, BigQuery can directly import CSV file

Question 29

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

Answer 29

No, you have to use the BigQuery conetcor

Question 30

Can I deploy BigQuery across region?

Answer 30

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

Question 31

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

Answer 31

No, BigQuery is deployed to a single Zone.