
Discover practical exam strategy and overview for the Google Cloud Certified Professional Data Engineer, including question format, timing, and top topics like BigQuery, Dataflow, and Bigtable.
Design, build, and maintain data pipelines and storage to collect and transport data. Ensure data quality, security, performance, and collaboration with data scientists, data analysts, and business intelligence teams.
Explore the landscape of data storage systems, from relational databases like MySQL and Oracle to NoSQL, data warehouses, data lakes, columnar, key-value, object, time series, and graph databases.
Compare ACID and BASE properties to understand how transactions guarantee data integrity, consistency, and availability in distributed databases.
Explore OLTP and OLAP. OLTP optimizes for many short transactions with normalized relational data and strict integrity, while OLAP enables multidimensional analysis on large datasets for business intelligence.
Explore the 4 v's of big data—volume, velocity, variety, and veracity—and learn to manage terabytes to exabytes, real-time processing, structured, unstructured, and semi-structured data, and data quality and governance.
Compare vertical and horizontal scaling to optimize data engineering systems, detailing single-server resource limits and the benefits of adding machines with load balancing and data sharing.
Compare batch and streaming data, where batch handles historical data for reports, analytics, and machine learning training, while streaming enables real-time monitoring and fraud detection through lambda architecture.
Explore the data processing pipeline from collection to governance, covering ingestion, storage, processing, modeling, analysis, and visualization, with notes on data quality, parallel execution, and diverse tools and frameworks.
Explore data engineering concepts, including etl vs elt, data serialization formats, caching, privacy and anonymization, visualization techniques, data lake, Delta Lake, data lake house, and warehousing fundamentals.
Explore Google's data processing pipeline from ingest to store, process and analyze, and visualize insights, with key products like Transfer Appliance, App Engine, Cloud Storage, BigQuery, and Dataflow.
Apply a practical decision tree to select the right Google Cloud data product based on structured vs unstructured data, analytics needs, latency, and relational vs non relational workloads.
Master Google Cloud Storage fundamentals—buckets and objects, location types, namespace options, access controls, storage classes, lifecycle transitions, data protection, and security—optimized for cost, durability, and performance.
Create a Google Cloud Storage bucket, upload files, share publicly, manage permissions, organize with folders, and delete items or buckets.
Learn how to migrate to Google Cloud and transfer large datasets using Storage Transfer Service, or use Transfer Appliance for on-prem data when bandwidth is limited.
Explore Cloud SQL, Google Cloud's fully managed relational database service for MySQL, PostgreSQL, and SQL Server, with automated backups, high availability, read replicas, and secure connectivity.
Demonstrates setting up and using Google Cloud SQL, enabling the SQL admin API, creating a MySQL 8.0 instance with development configuration, connecting via Cloud Shell, and running queries.
Cloud Spanner delivers globally strong consistent transactions across rows, tables, and indexes, while supporting SQL and multi-region replication in a fully managed, horizontally scalable database for high availability.
This hands-on demo guides you through setting up Google Cloud Spanner, creating a regional test instance and an example database with Google SQL, and performing basic table operations.
Leverage Dataflow, a serverless, auto-scaling data processing service, to build portable Apache Beam pipelines that ingest from streaming and batch sources, apply transformations, and write to sinks in real time.
Explore Google Cloud Dataflow, a fully managed serverless service for Apache Beam pipelines, using PCollection and PTransform to process batch and streaming data with windowing and side inputs.
Walk through a hands-on dataflow lab, building a Python dataflow pipeline, running a local word count, and deploying the pipeline on Google Cloud Dataflow.
Launch scalable Cloud Dataproc clusters in 90 seconds to run open source big data workloads from ETL to machine learning, with auto scaling, governance, and pay-per-second pricing.
Explore Google Cloud Dataproc, a fully managed, scalable data processing service for Hadoop and Spark, integrating with BigQuery, Cloud Storage, and the broader Google Cloud analytics ecosystem for data engineering.
Enable the Google Cloud Dataproc API, create a single-node Compute Engine cluster, and run a Spark job to compute pi. Monitor logs and delete cluster and bucket when finished.
Google cloud pub/sub is an asynchronous, serverless messaging service for producers and consumers, with topics and subscriptions enabling durable, scalable, one-to-many data streams globally and integration with BigQuery and Dataflow.
Google Cloud Pub/Sub lets publishers create topics, publish messages with attributes, and subscribers pull or push via subscriptions, with filtering and acknowledgments for reliable delivery.
Set up a separate Google Cloud project, enable the Cloud Pub/Sub API, create a topic and a subscription, publish and pull a message, and clean up.
Explore BigQuery as Google's fully managed, petabyte-scale enterprise data warehouse that ingests, stores, analyzes, and visualizes data via batch or streaming, with standard SQL and flexible pricing.
BigQuery views are virtual tables defined by a SQL query, exposing only the specified fields and tables. They are read-only and accessible via console, bq, REST, or client libraries.
discover how BigQuery serves as a serverless data warehouse and data lake, with datasets, schemas, streaming and batch data, and integrated BI and ML tools.
Complete a hands-on BigQuery demo by enabling the API, creating a dataset, and uploading a 2014 USA baby names CSV from public data. Run queries to surface names by gender.
BigQuery ML democratizes machine learning by letting SQL practitioners build, evaluate, and deploy models inside BigQuery using standard SQL, with diverse algorithms like linear and logistic regression.
Engage in a hands-on BigQuery ML demo: enable the BigQuery API, create the BCM tutorial dataset, train a logistic regression model on the Google Analytics sample data, and evaluate results.
Designing data processing systems
Selecting the appropriate storage technologies. Considerations include:
● Mapping storage systems to business requirements
● Data modeling
● Trade-offs involving latency, throughput, transactions
● Distributed systems
● Schema design
Designing data pipelines. Considerations include:
● Data publishing and visualization (e.g., BigQuery)
● Batch and streaming data (e.g., Dataflow, Dataproc, Apache Beam, Apache Spark and Hadoop ecosystem, Pub/Sub, Apache Kafka)
● Online (interactive) vs. batch predictions
● Job automation and orchestration (e.g., Cloud Composer)
Designing a data processing solution. Considerations include:
● Choice of infrastructure
● System availability and fault tolerance
● Use of distributed systems
● Capacity planning
● Hybrid cloud and edge computing
● Architecture options (e.g., message brokers, message queues, middleware, service-oriented architecture, serverless functions)
● At least once, in-order, and exactly once, etc., event processing
Migrating data warehousing and data processing. Considerations include:
● Awareness of current state and how to migrate a design to a future state
● Migrating from on-premises to cloud (Data Transfer Service, Transfer Appliance, Cloud Networking)
● Validating a migration
Building and operationalizing data processing systems
Building and operationalizing storage systems. Considerations include:
● Effective use of managed services (Cloud Bigtable, Cloud Spanner, Cloud SQL, BigQuery, Cloud Storage, Datastore, Memorystore)
● Storage costs and performance
● Life cycle management of data
Building and operationalizing pipelines. Considerations include:
● Data cleansing
● Batch and streaming
● Transformation
● Data acquisition and import
● Integrating with new data sources
Building and operationalizing processing infrastructure. Considerations include:
● Provisioning resources
● Monitoring pipelines
● Adjusting pipelines
● Testing and quality control
Operationalizing machine learning models
Leveraging pre-built ML models as a service. Considerations include:
● ML APIs (e.g., Vision API, Speech API)
● Customizing ML APIs (e.g., AutoML Vision, Auto ML text)
● Conversational experiences (e.g., Dialogflow)
Deploying an ML pipeline. Considerations include:
● Ingesting appropriate data
● Retraining of machine learning models (AI Platform Prediction and Training, BigQuery ML, Kubeflow, Spark ML)
● Continuous evaluation
Choosing the appropriate training and serving infrastructure. Considerations include:
● Distributed vs. single machine
● Use of edge compute
● Hardware accelerators (e.g., GPU, TPU)
Measuring, monitoring, and troubleshooting machine learning models. Considerations include:
● Machine learning terminology (e.g., features, labels, models, regression, classification, recommendation, supervised and unsupervised learning, evaluation metrics)
● Impact of dependencies of machine learning models
● Common sources of error (e.g., assumptions about data)
Ensuring solution quality
Designing for security and compliance. Considerations include:
● Identity and access management (e.g., Cloud IAM)
● Data security (encryption, key management)
● Ensuring privacy (e.g., Data Loss Prevention API)
● Legal compliance (e.g., Health Insurance Portability and Accountability Act (HIPAA), Children's Online Privacy Protection Act (COPPA), FedRAMP, General Data Protection Regulation (GDPR))
Ensuring scalability and efficiency. Considerations include:
● Building and running test suites
● Pipeline monitoring (e.g., Cloud Monitoring)
● Assessing, troubleshooting, and improving data representations and data processing infrastructure
● Resizing and autoscaling resources
Ensuring reliability and fidelity. Considerations include:
● Performing data preparation and quality control (e.g., Dataprep)
● Verification and monitoring
● Planning, executing, and stress testing data recovery (fault tolerance, rerunning failed jobs, performing retrospective re-analysis)
● Choosing between ACID, idempotent, eventually consistent requirements
Ensuring flexibility and portability. Considerations include:
● Mapping to current and future business requirements
● Designing for data and application portability (e.g., multicloud, data residency requirements)
● Data staging, cataloging, and discovery