1. What is BigQuery ? Junior A. a managed Apache Spark and Hadoop service for batch processing and analytics B. a serverless, columnar data warehouse for petabyte-scale SQL analytics C. GCP's unified platform for building, training, and deploying machine learning models D. a managed Apache Airflow service for orchestrating data workflows Reveal the answer + AI explanation — free account
2. Which term means: "a serverless, columnar data warehouse for petabyte-scale SQL analytics"? Junior A. Dataproc B. Looker C. Memorystore D. BigQuery Reveal the answer + AI explanation — free account
3. Which statement is correct? Junior A. BigQuery — a managed service for stream and batch data processing built on Apache Beam B. BigQuery — a managed relational database service for MySQL, PostgreSQL, and SQL Server C. BigQuery — a serverless, columnar data warehouse for petabyte-scale SQL analytics 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 A. a visual service for exploring, cleaning, and preparing data without code B. a global, scalable messaging service for event ingestion and delivery C. GCP's unified platform for building, training, and deploying machine learning models D. a managed in-memory data store for Redis and Memcached Reveal the answer + AI explanation — free account
5. Which term means: "a global, scalable messaging service for event ingestion and delivery"? Junior A. BigQuery B. Firestore C. Dataflow D. Pub/Sub Reveal the answer + AI explanation — free account
6. Which statement is correct? Junior A. Pub/Sub — a globally distributed, strongly consistent relational database with horizontal scaling B. Pub/Sub — a managed relational database service for MySQL, PostgreSQL, and SQL Server C. Pub/Sub — a managed Apache Airflow service for orchestrating data workflows 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 A. an in-memory analysis layer that accelerates BigQuery dashboard queries B. a managed relational database service for MySQL, PostgreSQL, and SQL Server C. a globally distributed, strongly consistent relational database with horizontal scaling D. a managed Apache Spark and Hadoop service for batch processing and analytics Reveal the answer + AI explanation — free account
8. Which term means: "a managed relational database service for MySQL, PostgreSQL, and SQL Server"? Junior A. Composer B. Spanner C. Cloud SQL D. Dataprep Reveal the answer + AI explanation — free account
9. Which statement is correct? Junior A. Cloud SQL — a global, scalable messaging service for event ingestion and delivery B. Cloud SQL — a globally distributed, strongly consistent relational database with horizontal scaling C. Cloud SQL — a managed service for stream and batch data processing built on Apache Beam 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 A. a managed service for stream and batch data processing built on Apache Beam B. a managed in-memory data store for Redis and Memcached C. a serverless, document NoSQL database with real-time sync and offline support D. a managed Apache Airflow service for orchestrating data workflows Reveal the answer + AI explanation — free account
11. Which term means: "a managed service for stream and batch data processing built on Apache Beam"? Mid A. Firestore B. Memorystore C. Dataflow D. Spanner Reveal the answer + AI explanation — free account
12. Which statement is correct? Mid A. Dataflow — a managed relational database service for MySQL, PostgreSQL, and SQL Server B. Dataflow — a global, scalable messaging service for event ingestion and delivery C. Dataflow — a visual service for exploring, cleaning, and preparing data without code 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 A. a managed Apache Spark and Hadoop service for batch processing and analytics B. a globally distributed, strongly consistent relational database with horizontal scaling C. a managed relational database service for MySQL, PostgreSQL, and SQL Server D. a fully managed, wide-column NoSQL database for large analytical and operational workloads Reveal the answer + AI explanation — free account
14. Which term means: "a fully managed, wide-column NoSQL database for large analytical and operational workloads"? Mid A. Spanner B. Bigtable C. Vertex AI D. Dataprep Reveal the answer + AI explanation — free account
15. Which statement is correct? Mid A. Bigtable — an in-memory analysis layer that accelerates BigQuery dashboard queries B. Bigtable — a fully managed, wide-column NoSQL database for large analytical and operational workloads C. Bigtable — a managed relational database service for MySQL, PostgreSQL, and SQL Server 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 A. a managed service for stream and batch data processing built on Apache Beam B. a managed Apache Spark and Hadoop service for batch processing and analytics C. a fully managed, wide-column NoSQL database for large analytical and operational workloads D. a managed in-memory data store for Redis and Memcached Reveal the answer + AI explanation — free account
17. Which term means: "a managed Apache Spark and Hadoop service for batch processing and analytics"? Mid A. Cloud SQL B. BigQuery C. Dataproc D. Looker Reveal the answer + AI explanation — free account
18. Which statement is correct? Mid A. Dataproc — a managed relational database service for MySQL, PostgreSQL, and SQL Server B. Dataproc — a managed Apache Spark and Hadoop service for batch processing and analytics C. Dataproc — GCP's unified platform for building, training, and deploying machine learning models D. Dataproc — a managed Apache Airflow service for orchestrating data workflows Reveal the answer + AI explanation — free account
19. What is Vertex AI ? Senior A. a managed Apache Airflow service for orchestrating data workflows B. GCP's enterprise business intelligence and data modeling platform C. GCP's unified platform for building, training, and deploying machine learning models D. a serverless, document NoSQL database with real-time sync and offline support Reveal the answer + AI explanation — free account
20. Which term means: "GCP's unified platform for building, training, and deploying machine learning models"? Senior A. Looker B. Vertex AI C. Dataprep D. BigQuery Reveal the answer + AI explanation — free account
21. Which statement is correct? Senior A. Vertex AI — GCP's enterprise business intelligence and data modeling platform B. Vertex AI — a managed relational database service for MySQL, PostgreSQL, and SQL Server C. Vertex AI — a managed service for stream and batch data processing built on Apache Beam 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 A. a globally distributed, strongly consistent relational database with horizontal scaling B. a global, scalable messaging service for event ingestion and delivery C. a managed Apache Spark and Hadoop service for batch processing and analytics D. a serverless, document NoSQL database with real-time sync and offline support Reveal the answer + AI explanation — free account
23. Which term means: "a globally distributed, strongly consistent relational database with horizontal scaling"? Senior A. BigQuery BI Engine B. Bigtable C. Spanner D. BigQuery Reveal the answer + AI explanation — free account
24. Which statement is correct? Senior A. Spanner — a fully managed, wide-column NoSQL database for large analytical and operational workloads B. Spanner — GCP's enterprise business intelligence and data modeling platform C. Spanner — a globally distributed, strongly consistent relational database with horizontal scaling 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 A. registers a model with Vertex AI Model Registry B. launches a Dataflow job from a template C. runs a SQL query against BigQuery from the command line D. provisions a new Cloud SQL instance Reveal the answer + AI explanation — free account
26. Which command will runs a SQL query against BigQuery from the command line? Junior A. bq query B. gcloud pubsub subscriptions create C. gcloud sql instances create D. gcloud ai models upload Reveal the answer + AI explanation — free account
27. Which statement is correct? Junior A. bq query — exports a BigQuery table to Cloud Storage B. bq query — runs a SQL query against BigQuery from the command line C. bq query — provisions a new Cloud SQL instance D. bq query — launches a Dataflow job from a template Reveal the answer + AI explanation — free account
28. What does bq mk do? Junior A. creates BigQuery datasets, tables, or views B. provisions a new Cloud SQL instance C. runs a SQL query against BigQuery from the command line D. creates a subscription to receive messages from a Pub/Sub topic Reveal the answer + AI explanation — free account
29. Which command will creates BigQuery datasets, tables, or views? Junior A. bq mk B. gcloud dataflow jobs run C. bq show D. bq load Reveal the answer + AI explanation — free account
30. Which statement is correct? Junior A. bq mk — publishes a message to a Pub/Sub topic B. bq mk — provisions a new Cloud SQL instance C. bq mk — creates BigQuery datasets, tables, or views D. bq mk — registers a model with Vertex AI Model Registry Reveal the answer + AI explanation — free accountShowing 30 of 72 GCP · Data & ML questions — the full set, with answers, explanations and an AI tutor on every question, is inside.