GCP Data Engineer Practice

Q: How many questions are in this practice set?

This practice set contains 60 questions with detailed explanations.

Q: What topics does this practice cover?

It covers the key topics and question types for Google Cloud Professional Data Engineer, including vocabulary, grammar, reading, and practical test skills.

Q: Are there explanations for every question?

Yes, every question includes a clear explanation so you can understand the correct answer and learn from mistakes.

Q: Can I save my progress and mistakes?

Your wrong answers, favorites, scores, and study streak are saved in your browser, so you can review them on the same device.

Q: What practice modes are available?

You can practice randomly, take a timed mock exam, filter by difficulty, type, and topic, search questions, and review wrong answers.

Practice 60 original Google Cloud Professional Data Engineer questions covering storage, pipelines, ML analytics, security, reliability and architecture, with detailed explanations.

Level: Google Cloud Professional Data Engineer Difficulty: advanced 60 questions 60 min

Choose a practice mode, answer each GCP Data Engineer question, then review the explanation. Wrong answers are saved locally for review.

Practice mode Difficulty Topic Question type Search questions

Day streak: 0 days Saved only on this device

Question 1

What is BigQuery?

Select an answer A DNS serviceA serverless analytics data warehouseAn object storage serviceA messaging service

Question 2

What is Cloud Storage?

Select an answer Object storage for unstructured dataA relational databaseA messaging queueA load balancer

Question 3

What is Pub/Sub?

Select an answer A virtual machineA DNS serviceA scalable messaging serviceA data warehouse

Question 4

What is Dataflow?

Select an answer A relational databaseAn object storeA CDNA unified stream and batch data processing service

Question 5

What is Dataproc?

Select an answer A data warehouseA messaging serviceA DNS zoneA managed Spark and Hadoop service

Question 6

What is Cloud Bigtable?

Select an answer A low-latency NoSQL databaseA relational databaseAn object storeA CDN

Question 7

What is Cloud SQL?

Select an answer A messaging serviceA managed relational database serviceA NoSQL databaseAn object store

Question 8

What is Firestore?

Select an answer A data warehouseA CDNA flexible document databaseA relational database

Question 9

What is Cloud Spanner?

Select an answer An object storeA messaging queueA globally distributed relational databaseA document database

Question 10

Match each storage concept to its purpose.

BigQueryCloud StoragePub/SubBigtable

Question 11

Which service is commonly used to build ETL pipelines in Google Cloud?

Select an answer Cloud DNSCloud CDNCloud IAMDataflow

Question 12

What is Cloud Composer?

Select an answer A load balancerA workflow orchestration service based on AirflowA data warehouseA messaging queue

Question 13

What are ephemeral Dataproc clusters?

Select an answer Clusters created for a job and deleted afterwardAlways-running clustersData warehousesDNS zones

Question 14

What is Cloud Scheduler?

Select an answer A storage serviceA firewallA cron service for scheduled jobsA database

Question 15

What are Cloud Functions?

Select an answer DNS recordsEvent-driven serverless functionsVirtual machinesDatabases

Question 16

What is a Pub/Sub push subscription?

Select an answer A pull subscriptionA databaseA DNS recordA subscription that delivers messages to an endpoint

Question 17

What can trigger a Cloud Function in Cloud Storage?

Select an answer A DNS queryA VM rebootA firewall changeObject creation or deletion events

Question 18

What are Dataflow templates?

Select an answer DNS recordsReusable pipeline configurationsVirtual machinesStorage buckets

Question 19

What is a BigQuery load job?

Select an answer A job that imports data into BigQueryA job that deletes tablesA DNS queryA backup

Question 20

Match each pipeline concept to its purpose.

DataflowComposerSchedulerPub/Sub

Question 21

What is BigQuery ML?

Select an answer A data warehouseA DNS serviceSQL-based machine learning in BigQueryA notebook service

Question 22

What is Vertex AI?

Select an answer A messaging serviceA relational databaseA CDNA unified ML platform

Question 23

What is Looker Studio?

Select an answer A dashboard and visualization toolA data warehouseA messaging queueA load balancer

Question 24

What are Vertex AI notebooks?

Select an answer A DNS recordCode notebooks for data scienceA databaseA storage bucket

Question 25

Why split data into training and evaluation sets?

Select an answer To create reportsTo measure model generalizationTo increase storage costTo avoid encryption

Question 26

What is batch prediction?

Select an answer Making predictions for many records at onceReal-time prediction onlyA storage jobA DNS query

Question 27

What is a feature store?

Select an answer A database for transactionsA DNS serviceA load balancerA central repository for ML features

Question 28

What is a model registry?

Select an answer A firewallA DNS zoneA catalog of model versionsA storage bucket

Question 29

What is hyperparameter tuning?

Select an answer Searching for the best model settingsDeleting modelsEncrypting dataCreating reports

Question 30

Match each ML concept to its purpose.

BigQuery MLVertex AILookerNotebooks

Question 31

Which service controls permissions in Google Cloud?

Select an answer Cloud StorageCloud CDNCloud DNSCloud IAM

Question 32

What is Cloud KMS?

Select an answer A firewallA load balancerA key management service for encryptionA database

Question 33

What is Cloud DLP?

Select an answer A DNS serviceData loss prevention for sensitive dataA data warehouseA messaging queue

Question 34

What is VPC Service Controls?

Select an answer A security perimeter around Google Cloud servicesA firewallA DNS zoneA load balancer

Question 35

What is a customer-managed encryption key?

Select an answer A DNS recordA firewall ruleA key the customer controls in Cloud KMSA Google-managed key

Question 36

What is a retention policy?

Select an answer A firewall ruleA DNS recordA load balancerRules that control how long data is kept

Question 37

What are Cloud Audit Logs?

Select an answer Storage bucketsLogs of admin and data access activityApplication logs onlyDNS records

Question 38

What is an organization policy?

Select an answer A policy that constrains resources across the orgA firewallA DNS zoneA load balancer

Question 39

Why use private connectivity for data services?

Select an answer To expose services publiclyTo increase latencyTo disable encryptionTo keep traffic inside a private network

Question 40

Match each security concept to its purpose.

IAMKMSDLPVPC-SC

Question 41

What is Cloud Monitoring?

Select an answer Collects metrics and alerts for Google CloudA data warehouseA DNS serviceA load balancer

Question 42

What is Cloud Logging?

Select an answer A firewallA CDNStores and queries logsA database

Question 43

What is a quota?

Select an answer A datasetA DNS recordA limit on resource usageA model

Question 44

What is object lifecycle management?

Select an answer A load balancerRules for moving or deleting objects over timeA firewall ruleA DNS record

Question 45

What is a budget alert?

Select an answer A firewall ruleA DNS recordA load balancerAn alert when spending exceeds a threshold

Question 46

What is a region?

Select an answer A geographic location for resourcesA storage bucketA modelA DNS record

Question 47

Why use retry policies?

Select an answer To increase latencyTo handle transient failuresTo delete dataTo disable encryption

Question 48

What is idempotency?

Select an answer Deleting all dataEncrypting filesCreating DNS recordsRepeating an operation produces the same result

Question 49

Why back up data?

Select an answer To disable securityTo slow queriesTo recover from loss or corruptionTo increase cost

Question 50

Match each reliability concept to its purpose.

MonitoringLoggingQuotaLifecycle

Question 51

What is batch processing?

Select an answer A storage bucketProcessing data on a scheduleReal-time processing onlyA DNS query

Question 52

What is streaming processing?

Select an answer Processing data nightlyA database backupA DNS queryProcessing data as it arrives

Question 53

What is table partitioning?

Select an answer Splitting a table by a column or date for efficiencyDeleting a tableEncrypting dataCreating reports

Question 54

What is table clustering?

Select an answer A DNS recordA firewallStoring related rows togetherSplitting tables randomly

Question 55

What is schema evolution?

Select an answer Disabling securityCreating reportsChanging table schemas as requirements changeDeleting all data

Question 56

What is a data lake?

Select an answer A load balancerA repository for raw data in many formatsA highly structured warehouseA DNS service

Question 57

What is a star schema?

Select an answer A database backupA firewall ruleA DNS recordA dimensional model with fact and dimension tables

Question 58

What is data governance?

Select an answer Policies for data quality, access, and complianceA storage bucketA firewallA load balancer

Question 59

What is Data Catalog?

Select an answer A DNS zoneA metadata service for discovering data assetsA databaseA messaging queue

Question 60

Match each architecture concept to its purpose.

BatchStreamingPartitioningData Catalog