thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Cloud Computing · Foundational

BigQuery

Google Cloud's serverless, highly scalable enterprise data warehouse for SQL analytics.

Definition

BigQuery separates storage and compute, charging for storage and for queries via on-demand (per data scanned) or capacity-based (slots via editions) pricing. Partitioning and clustering reduce data scanned, and it supports streaming ingestion, BigQuery ML, BI Engine and federated queries. Cloud Billing data can be exported to BigQuery for cost analysis.

Example

Analysts run SQL over 5 TB of web logs partitioned by date, scanning only the last 7 days.

Exam tip

Limit cost with partitioning, clustering and selecting only needed columns; SELECT * scans every column.

Related terms