Top Google BigQuery Interview Questions (2021) | CodeUsingJava
















Most frequently asked Google BigQuery Interview Questions


  1. What is BigQuery?
  2. What are the features of Google BigQuery?
  3. What are the benefits of Google BigQuery?
  4. What is Google Cloud SDK?
  5. What are the features of Google Cloud SDK?
  6. Explain Data Processing in GC?
  7. What are different NoSQL databases used in GCP ?
  8. How can we build Ethereum dataset?
  9. What is VPC in the Google cloud platform?
  10. Name some of the GCP Components?
  11. What is the process of BigQuery at WePay?
  12. How to convert stringified array into array in BigQuery?
  13. How to convert stringified array into array in BigQuery?
  14. How to get BigQuery storage size for a single table?
  15. How to Auth to Google Cloud using Service Account in Python?
  16. What is Snowplow BigQuery Loader?
  17. How to Manage Google API Errors in Python?


What is BigQuery?

Google BigQuery is used for processing large read only data sets.It enables scalable analysis over petabytes of data and this platform which supports querying by using ANSI SQL.BigQuery is a cloud based data analytics web service for processing very large read-only data sets.

What are the features of Google BigQuery?

  • BigQuery ML - It enables all the data analysts for building and operationalizing ML models on planet scale structured or semi-structured data, directly inside BigQuery, using simple SQL-in a fraction of the time.
  • BigQuery Omni - It is fully managed, multicloud analytics solution which allows us to analyze data across clouds such as AWS and Azure.
  • BigQuery BI Engine - It is used in analyzing service built in BigQuery which also enables users to analyze large and complex datasets interactively with sub-second query response time and high concurrency.
  • BigQuery GIS - Used for combining serverless architecture of BigQuery with native support geospatial analysis, so you can augment your analytics workflows with location intelligence.

What are the benefits of Google BigQuery?

  • Gain insights with real-time and predictive analytics.
  • Access data and share insights with ease.
  • Protect our data and operate with trust.

What is Google Cloud SDK?

Google Cloud SDK is used for the development of the Google Cloud, it can access the compute engine, cloud storage, bigquery, and other services directly from the command line.It also contains client libraries and API libraries, we can work with VM instances, manage computer engine networks, firewalls & storage, and more.

What are the features of Google Cloud SDK?

  • gcloud command-line tool - Google Cloud manages manages authentication, local configuration, developer workflow, interactions with Google Cloud APIs.
  • Client Libraries - Thses libraries are used for supporting natural conventions and styles, handling authentication, reducing the amount of necessary boilerplate code, and optimizing the developer workflow.
  • Product-specific command-line tools - The gsutil is used for allowing us to manage Cloud Store Buckets and objects using the command line.

Explain Data Processing in GC?


BigQuery


What are different NoSQL databases used in GCP ?

There are 3 types of NoSQL Databases:
Cloud Datastore
Cloud Firestore
Cloud Bigtable


How can we build Ethereum dataset?


BigQuery


What is VPC in the Google cloud platform?

Virtual Private Cloud is used for providing networking functionality to Compute Engine VM instance, Google Kubernetes Engine clusters and the App Engine Flexible environment.It also provides networking our cloud bases resource and services which is glbal, scalable and flexible and also helps in creating subnets in each region automatically.We can create more than one subnet per regoin and assigns Google Cloud to an instance address from the range of available addresses in the subnet.

Name some of the GCP Components?

Some of the GCP Components are as follows:
VPCs
Projects
Networks
Regions
Zones
Subnets
Switching
Routing
Firewalls


What is the process of BigQuery at WePay?


BigQuery


How to convert stringified array into array in BigQuery?

#standardSQL
WITH k AS (
  SELECT 1 AS id, '["a","b","c"]' AS x UNION ALL
  SELECT 2, '["x","y"]'
)
SELECT
  id,
  ARRAY(SELECT * FROM UNNEST(SPLIT(SUBSTR(x, 2 , LENGTH(x) - 2)))) AS x
FROM k


Explain the procedure of marketers in Google BigQuery?


BigQuery


How to get BigQuery storage size for a single table?

select
  sum(size_bytes)/pow(10,9) as size
from
  <your_dataset>.__TABLES__
where
  table_id = '<your_table>'


How to Auth to Google Cloud using Service Account in Python?

import os
from google.cloud.bigquery.client import Client

os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = 'path_to_json_file'
bq_client = Client()


What is Snowplow BigQuery Loader?


BigQuery


How to Manage Google API Errors in Python?

from googleapiclient.errors import HttpError
try:
   ...
except HttpError as err:
  # If the error is a rate limit or connection error,
  # wait and try again.
  if err.resp.status in [403, 500, 503]:
    time.sleep(5)
  else: raise