GCP BigQuery Flashcards
What is GCP BigQuery?
It is an analytics engine, runs queries over data. A data where house.
Is GCP BigQuery a managed service?
100% yes.
What is the query language used by BigQuery?
SQL like.
What are the interfaces to the GCP BigQiery service?
REST, WebUI and ODBC
For GCP BigQuery can I connect using ODBC?
Yes the ODBS interface is supported
For GCP BigQuery, can store an query TB’s of data?
Yes, GCP BigQuery is designed for storing and querying TB’s of data
Because GCP BigQuery enables you to run SQL to query the data, is BigQuery a database?
No, BigQuery is an analytics engine.
Is there a limit on the amount of data I can store in GCP BigQuery?
No, there is no limit.
Is data easy to import to BigQuery?
Yes, fast atomic imports
What is GCP BigQuery most like from a traditional data analytics perspective?
Data where house?
Can I store a PC of data in big query?
Yes, data storage and query iis unlimited
Is GCP BigQuery a row based database where data is ready by rows?
No, BgiQuery is a columnar database, data is read in rows, making it much faster to retreive only the relevent data.
How much data could I receive form BigQuery in one second?
1 TB
Is BigQuery a single-tenant compute cluster?
No it is a multi-tenant cluster and the cluster is shared between tenants.
What is the GCP BigQuery query language?
It is SQL
What is the BigQuery streaming API?
You can make a HTTP request and stream in uptp 100K rowes per sec
I have data in GCP Cloud Storage, is it possible to injest into GCP BigQuery?
Yes, this is supported, easy.
I have data in Hadoope, is it possible to injest into GCP BigQuery?
Yes, this is supported, easy.
I have data in GCP dataflow, I wnat to store in BigQuery, is this possible?
Yes, this is supported.
What is a GCP BigQuery connector?
It is a link form an external system such as hadoop thet enables the external system to use BigQuery to query data
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?
Yes. BigQuery enables you to carryout ETL jobs
Is BigQuery expensive to keep data around?
No, google says it is easier and costeffective to keep your data then to delete it
I have a billion rows in two cloums of data, how long would it take BigQuery to query this data?
Approx 5 seconds (Fast)
I have a 100 billion rows in two cloums of data, how long would it take BigQuery to query this data?
Approx 8 seconds (very Fast) (approx 4TB of data)
I have two tables with 1 billion rows in two cloums, how long would it take BigQuery to run a query with a join?
Approx 22 seconds (Fast)
Is there a CLI for GCP BigQuery?
Yes it is called bg
I have a CSV file and I would like to load it into BigQuery, do I have a conenctor?
No, BigQuery can directly import CSV file
I have a JSON file and I would like to load it into BigQuery, do I have a conenctor?
No, BigQuery can directly import CSV file
I have a Hadoop cluster can I directly import data into BigQuery?
No, you have to use the BigQuery conetcor
Can I deploy BigQuery across region?
No BigQuery is regional and also deployed to one zone service/resource.
Can I deploy BigQuery to multi-zones in a single region?
No, BigQuery is deployed to a single Zone.