GCP · Data & ML interview questions

72 real GCP · Data & ML questions from the Cloud bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is BigQuery?

Junior
  1. A.a managed Apache Spark and Hadoop service for batch processing and analytics
  2. B.a serverless, columnar data warehouse for petabyte-scale SQL analytics
  3. C.GCP's unified platform for building, training, and deploying machine learning models
  4. D.a managed Apache Airflow service for orchestrating data workflows
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.BigQuery — a managed service for stream and batch data processing built on Apache Beam
  2. B.BigQuery — a managed relational database service for MySQL, PostgreSQL, and SQL Server
  3. C.BigQuery — a serverless, columnar data warehouse for petabyte-scale SQL analytics
  4. D.BigQuery — a visual service for exploring, cleaning, and preparing data without code
Reveal the answer + AI explanation — free account

4. What is Pub/Sub?

Junior
  1. A.a visual service for exploring, cleaning, and preparing data without code
  2. B.a global, scalable messaging service for event ingestion and delivery
  3. C.GCP's unified platform for building, training, and deploying machine learning models
  4. D.a managed in-memory data store for Redis and Memcached
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Junior
  1. A.Pub/Sub — a globally distributed, strongly consistent relational database with horizontal scaling
  2. B.Pub/Sub — a managed relational database service for MySQL, PostgreSQL, and SQL Server
  3. C.Pub/Sub — a managed Apache Airflow service for orchestrating data workflows
  4. D.Pub/Sub — a global, scalable messaging service for event ingestion and delivery
Reveal the answer + AI explanation — free account

7. What is Cloud SQL?

Junior
  1. A.an in-memory analysis layer that accelerates BigQuery dashboard queries
  2. B.a managed relational database service for MySQL, PostgreSQL, and SQL Server
  3. C.a globally distributed, strongly consistent relational database with horizontal scaling
  4. D.a managed Apache Spark and Hadoop service for batch processing and analytics
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Junior
  1. A.Cloud SQL — a global, scalable messaging service for event ingestion and delivery
  2. B.Cloud SQL — a globally distributed, strongly consistent relational database with horizontal scaling
  3. C.Cloud SQL — a managed service for stream and batch data processing built on Apache Beam
  4. D.Cloud SQL — a managed relational database service for MySQL, PostgreSQL, and SQL Server
Reveal the answer + AI explanation — free account

10. What is Dataflow?

Mid
  1. A.a managed service for stream and batch data processing built on Apache Beam
  2. B.a managed in-memory data store for Redis and Memcached
  3. C.a serverless, document NoSQL database with real-time sync and offline support
  4. D.a managed Apache Airflow service for orchestrating data workflows
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Mid
  1. A.Dataflow — a managed relational database service for MySQL, PostgreSQL, and SQL Server
  2. B.Dataflow — a global, scalable messaging service for event ingestion and delivery
  3. C.Dataflow — a visual service for exploring, cleaning, and preparing data without code
  4. D.Dataflow — a managed service for stream and batch data processing built on Apache Beam
Reveal the answer + AI explanation — free account

13. What is Bigtable?

Mid
  1. A.a managed Apache Spark and Hadoop service for batch processing and analytics
  2. B.a globally distributed, strongly consistent relational database with horizontal scaling
  3. C.a managed relational database service for MySQL, PostgreSQL, and SQL Server
  4. D.a fully managed, wide-column NoSQL database for large analytical and operational workloads
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Mid
  1. A.Bigtable — an in-memory analysis layer that accelerates BigQuery dashboard queries
  2. B.Bigtable — a fully managed, wide-column NoSQL database for large analytical and operational workloads
  3. C.Bigtable — a managed relational database service for MySQL, PostgreSQL, and SQL Server
  4. D.Bigtable — a managed service for stream and batch data processing built on Apache Beam
Reveal the answer + AI explanation — free account

16. What is Dataproc?

Mid
  1. A.a managed service for stream and batch data processing built on Apache Beam
  2. B.a managed Apache Spark and Hadoop service for batch processing and analytics
  3. C.a fully managed, wide-column NoSQL database for large analytical and operational workloads
  4. D.a managed in-memory data store for Redis and Memcached
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Mid
  1. A.Dataproc — a managed relational database service for MySQL, PostgreSQL, and SQL Server
  2. B.Dataproc — a managed Apache Spark and Hadoop service for batch processing and analytics
  3. C.Dataproc — GCP's unified platform for building, training, and deploying machine learning models
  4. D.Dataproc — a managed Apache Airflow service for orchestrating data workflows
Reveal the answer + AI explanation — free account

19. What is Vertex AI?

Senior
  1. A.a managed Apache Airflow service for orchestrating data workflows
  2. B.GCP's enterprise business intelligence and data modeling platform
  3. C.GCP's unified platform for building, training, and deploying machine learning models
  4. D.a serverless, document NoSQL database with real-time sync and offline support
Reveal the answer + AI explanation — free account

21. Which statement is correct?

Senior
  1. A.Vertex AI — GCP's enterprise business intelligence and data modeling platform
  2. B.Vertex AI — a managed relational database service for MySQL, PostgreSQL, and SQL Server
  3. C.Vertex AI — a managed service for stream and batch data processing built on Apache Beam
  4. D.Vertex AI — GCP's unified platform for building, training, and deploying machine learning models
Reveal the answer + AI explanation — free account

22. What is Spanner?

Senior
  1. A.a globally distributed, strongly consistent relational database with horizontal scaling
  2. B.a global, scalable messaging service for event ingestion and delivery
  3. C.a managed Apache Spark and Hadoop service for batch processing and analytics
  4. D.a serverless, document NoSQL database with real-time sync and offline support
Reveal the answer + AI explanation — free account

24. Which statement is correct?

Senior
  1. A.Spanner — a fully managed, wide-column NoSQL database for large analytical and operational workloads
  2. B.Spanner — GCP's enterprise business intelligence and data modeling platform
  3. C.Spanner — a globally distributed, strongly consistent relational database with horizontal scaling
  4. D.Spanner — a serverless, document NoSQL database with real-time sync and offline support
Reveal the answer + AI explanation — free account

25. What does bq query do?

Junior
  1. A.registers a model with Vertex AI Model Registry
  2. B.launches a Dataflow job from a template
  3. C.runs a SQL query against BigQuery from the command line
  4. D.provisions a new Cloud SQL instance
Reveal the answer + AI explanation — free account

27. Which statement is correct?

Junior
  1. A.bq query — exports a BigQuery table to Cloud Storage
  2. B.bq query — runs a SQL query against BigQuery from the command line
  3. C.bq query — provisions a new Cloud SQL instance
  4. D.bq query — launches a Dataflow job from a template
Reveal the answer + AI explanation — free account

28. What does bq mk do?

Junior
  1. A.creates BigQuery datasets, tables, or views
  2. B.provisions a new Cloud SQL instance
  3. C.runs a SQL query against BigQuery from the command line
  4. D.creates a subscription to receive messages from a Pub/Sub topic
Reveal the answer + AI explanation — free account

30. Which statement is correct?

Junior
  1. A.bq mk — publishes a message to a Pub/Sub topic
  2. B.bq mk — provisions a new Cloud SQL instance
  3. C.bq mk — creates BigQuery datasets, tables, or views
  4. D.bq mk — registers a model with Vertex AI Model Registry
Reveal the answer + AI explanation — free account

Showing 30 of 72 GCP · Data & ML questions — the full set, with answers, explanations and an AI tutor on every question, is inside.

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice GCP · Data & ML free