placd.in

GCP · Data & ML interview questions

72 GCP · Data & ML questions from the Cloud bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.

Free to start: the 2-minute IT readiness check — six questions and a result.

Take the free IT readiness check

or take a mock interview set up for this area

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

Answer + AI explanation with Pro

2. Which term means: "a serverless, columnar data warehouse for petabyte-scale SQL analytics"?

Junior
  1. A.Dataproc
  2. B.Looker
  3. C.Memorystore
  4. D.BigQuery

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

5. Which term means: "a global, scalable messaging service for event ingestion and delivery"?

Junior
  1. A.BigQuery
  2. B.Firestore
  3. C.Dataflow
  4. D.Pub/Sub

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

8. Which term means: "a managed relational database service for MySQL, PostgreSQL, and SQL Server"?

Junior
  1. A.Composer
  2. B.Spanner
  3. C.Cloud SQL
  4. D.Dataprep

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

11. Which term means: "a managed service for stream and batch data processing built on Apache Beam"?

Mid
  1. A.Firestore
  2. B.Memorystore
  3. C.Dataflow
  4. D.Spanner

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

14. Which term means: "a fully managed, wide-column NoSQL database for large analytical and operational workloads"?

Mid
  1. A.Spanner
  2. B.Bigtable
  3. C.Vertex AI
  4. D.Dataprep

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

17. Which term means: "a managed Apache Spark and Hadoop service for batch processing and analytics"?

Mid
  1. A.Cloud SQL
  2. B.BigQuery
  3. C.Dataproc
  4. D.Looker

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

20. Which term means: "GCP's unified platform for building, training, and deploying machine learning models"?

Senior
  1. A.Looker
  2. B.Vertex AI
  3. C.Dataprep
  4. D.BigQuery

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

23. Which term means: "a globally distributed, strongly consistent relational database with horizontal scaling"?

Senior
  1. A.BigQuery BI Engine
  2. B.Bigtable
  3. C.Spanner
  4. D.BigQuery

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

26. Which command will runs a SQL query against BigQuery from the command line?

Junior
  1. A.bq query
  2. B.gcloud pubsub subscriptions create
  3. C.gcloud sql instances create
  4. D.gcloud ai models upload

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

29. Which command will creates BigQuery datasets, tables, or views?

Junior
  1. A.bq mk
  2. B.gcloud dataflow jobs run
  3. C.bq show
  4. D.bq load

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Start with a free readiness check

Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every GCP · Data & ML question come with Pro.

Take the free IT readiness check

or take a mock interview set up for this area

More Cloud topics (all Cloud questions)

AWS · Compute (72)AWS · Storage (72)AWS · Networking (VPC) (75)AWS · IAM & Security (72)AWS · Databases (72)AWS · Serverless (72)GCP · Core (72)Azure · Core (42)Azure · Identity (42)Cloud · Networking & CDN (42)Cloud · Cost & Billing (42)Cloud · Well-Architected/Reliability (42)
24,000+ questions & coding problemsSoftware & IT16,274 questionsGovernment jobs26 examsAptitudenew questions every timeAI practice interviewwith feedback65 topics to practiseMechanical1,149 questionsGATE ME9 papersEngineering Mathematics381 questions2-minute checkfreeDSA Problems1,422Civil1,005 questionsGATE CE9 papersCS Fundamentals1,209 questionsYour scores6 skillsSystem Design25Electrical / EEE1,047 questionsGATE EE9 papersRun your codeC++ · Java · PythonLow-Level Design144Electronics & Comm.975 questionsGATE EC9 papersAI help on every questionFull-Stack6,282Chemical1,005 questionsGATE CH9 papersAI whiteboardsystem designWork abroadEurope · remote · transfersESE ME1 paperGATE practice papers2019–2026ESE CE1 paperDate alertsbefore the last dateESE EE1 paperBehavioural courseHR round practiceESE ET1 paperResume optimizerProSSC JE ME1 paperApplication trackerSSC JE CE1 paperCompany-wise prepSSC JE EE1 paperRole roadmapsRRB JE1 subjectPriced in ₹UPI · cardsISRO SC1 paperGATE CS9 papersIBPS SO IT1 paperUGC NET CS1 paperSSC CGL26 papersIBPS PO26 papersRRB NTPC26 papersSSC CHSL26 papersIBPS Clerk26 papersSBI Clerk26 papersRRB Group D26 papersSSC CPO26 papersSSC GD26 papers