🎯BigQuery Interview Questions

🔺As many of you struggle on how to prepare for an Interview(GCP Based) So here I am Sharing the list of questions which I faced during the Interview based on the Bigquery Service.

🚀These are the commonly asked questions during the interview So for better understanding.

I have classified them in Easy , Medium and Hard Category !!!

📍 Easy:

🔹What is Bigquery and What is the purpose of using Bigquery ?

🔹What is the Architecture of Bigquery?

🔹What are the different types of file format supported in Bigquery?

🔹What is Materialized and Generic views in Bigquery and What is the use of both of them?

🔹What are the Optimization techniques in Bigquery?

🔹What are the different ways of loading data in Bigquery Table OR How to Ingest data into BigQuery?

🔹What is the difference between Row level and columnar base Datawarehouse and What do you understand by them?

🔹What is the Difference between Teradata and Bigquery?

📍 Medium:

🔹What is the difference between REQUIRED and NULLABLE in Bigquery?

🔹How to create tables in Bigquery and what are the different ways to do it?

🔹What is the difference between IS and EXISTS ?

🔹”What is the difference between in both the below queries in terms of computation and storage ?

SELECT * FROM EMPLOYEE;

SELECT * FROM EMPLOYEE LIMIT 10;”

🔹What are Window Functions in Bigquery?

🔹Why parquet is used in Datawarehouse or Bigquery?

📍 Hard:

🔹How to Edit schema in Bigquery?

🔹How to add columns in a Table while editing the Schema?

🔹If you have 100 columns in a table how will you query a table with 1 column and except 99 columns?

🔹What is a slot in Bigquery?

🔹How to transfer data from GCS to Bigquery and How many ways are there to achieve this?

🔹How to give access on Bigquery Tables,Datasets and Views?

🔹How to retrieve deleted Table in Bigquery?

🔹How to apply restrictions to Bigquery Tables?

Prepare the answers to all of the questions mentioned above and you are good to Go ‼‼‼ 🔥 ……

Please do Share it across the people ,Let’s help each other in learning and growing 👜💻 ❗

Happy Learning . . . . 📖