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