BigQuery - Fundamentals
BigQuery architecture, datasets, tables, schemas, data types, console, costs
1What is BigQuery?
What is BigQuery?
Answer
BigQuery is Google Cloud Platform's fully managed, serverless data warehouse. It allows running analytical SQL queries on very large volumes of data (petabytes) without managing any infrastructure. Its architecture separates storage and compute, enabling each component to scale independently based on needs.
2What is the main characteristic of BigQuery's architecture?
What is the main characteristic of BigQuery's architecture?
Answer
BigQuery is built on an architecture that separates storage (Colossus) and compute (Dremel). This separation allows storing massive amounts of data at low cost while dynamically allocating the necessary compute power only when queries are executed. This avoids provisioning and maintaining fixed clusters.
3What is a dataset in BigQuery?
What is a dataset in BigQuery?
Answer
A dataset in BigQuery is a logical container that groups tables, views, and functions. It plays a role similar to a schema in traditional databases. Each dataset is associated with a Google Cloud project and has its own geographic location settings and access control.
What is the organizational hierarchy of resources in BigQuery?
How to reference a table in a BigQuery query?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Fundamentals
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Python & Pandas - Fundamentals
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Cohort and Retention Analysis
Google Tag Manager and Tracking
APIs and Webhooks
dbt - Fundamentals
AB Testing and Applied Statistics
Looker Studio (Google Data Studio)
Power BI - Fundamentals
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free