Professional Data Engineer Certification Exam

Your company built a TensorFlow neutral-network model with a large number of neurons and layers. ...

You are building a model to make clothing recommendations. You know a user's fashion preference i...

You designed a database for patient records as a pilot project to cover a few hundred patients in...

You create an important report for your large team in Google Data Studio 360. The report uses Goo...

An external customer provides you with a daily dump of data from their database. The data flows i...

Your weather app queries a database every 15 minutes to get the current temperature. The frontend...

You are creating a model to predict housing prices. Due to budget constraints, you must run it on...

You are building new real-time data warehouse for your company and will use Google BigQuery strea...

Your company is using WILDCARD tables to query data across multiple tables with similar names. Th...

Your company is in a highly regulated industry. One of your requirements is to ensure individual ...

You are designing a basket abandonment system for an ecommerce company. The system will send a me...

Your company handles data processing for a number of different clients. Each client prefers to us...

You want to process payment transactions in a point-of-sale application that will run on Google C...

You want to use a database of information about tissue samples to classify future tissue samples ...

You need to store and analyze social media postings in Google BigQuery at a rate of 10,000 messag...

Your startup has never implemented a formal security policy. Currently, everyone in the company h...

Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to re-use H...

Business owners at your company have given you a database of bank transactions. Each row contains...

Your company's on-premises Apache Hadoop servers are approaching end-of-life, and IT has decided ...

You work for a car manufacturer and have set up a data pipeline using Google Cloud Pub/Sub to cap...

Your company uses a proprietary system to send inventory data every 6 hours to a data ingestion s...

Your company has hired a new data scientist who wants to perform complicated analyses across very...

You are deploying 10,000 new Internet of Things devices to collect temperature data in your wareh...

You have spent a few days loading data from comma-separated values (CSV) files into the Google Bi...

You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an instant ...

You are working on a sensitive project involving private user data. You have set up a project on ...

You are building a model to predict whether or not it will rain on a given day. You have thousand...

Your company is performing data preprocessing for a learning algorithm in Google Cloud Dataflow. ...

Your company is streaming real-time sensor data from their factory floor into Bigtable and they h...

Your company's customer and order databases are often under heavy load. This makes performing ana...

You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subscriptio...

Your company is running their first dynamic campaign, serving different offers by analyzing real-...

Your software uses a simple JSON format for all messages. These messages are published to Google ...

Flowlogistic Case Study -Company Overview -Flowlogistic is a leading logistics and supply chain p...

Flowlogistic Case Study -Company Overview -Flowlogistic is a leading logistics and supply chain p...

Flowlogistic Case Study -Company Overview -Flowlogistic is a leading logistics and supply chain p...

Flowlogistic Case Study -Company Overview -Flowlogistic is a leading logistics and supply chain p...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...

Your company has recently grown rapidly and now ingesting data at a significantly higher rate tha...

You work for a large fast food restaurant chain with over 400,000 employees. You store employee i...

You are deploying a new storage system for your mobile application, which is a media streaming se...

You work for a manufacturing plant that batches application log files together into a single log ...

You work for an economic consulting firm that helps companies identify economic trends as they ha...

You are designing the database schema for a machine learning-based food ordering service that wil...

Your company is loading comma-separated values (CSV) files into Google BigQuery. The data is full...

Your company produces 20,000 files every hour. Each data file is formatted as a comma separated v...

You are choosing a NoSQL database to handle telemetry data submitted from millions of Internet-of...

You are training a spam classifier. You notice that you are overfitting the training data. Which ...

You are implementing security best practices on your data pipeline. Currently, you are manually e...

You are using Google BigQuery as your data warehouse. Your users report that the following simple...

Your globally distributed auction application allows users to bid on items. Occasionally, users p...

Your organization has been collecting and analyzing data in Google BigQuery for 6 months. The maj...

You have enabled the free integration between Firebase Analytics and Google BigQuery. Firebase no...

Your company is currently setting up data pipelines for their campaign. For all the Google Cloud ...

You architect a system to analyze seismic data. Your extract, transform, and load (ETL) process r...

An online retailer has built their current application on Google App Engine. A new initiative at ...

You launched a new gaming app almost three years ago. You have been uploading log files from the ...

Your analytics team wants to build a simple statistical model to determine which customers are mo...

Your company receives both batch- and stream-based event data. You want to process the data using...

You have some data, which is shown in the graphic below. The two dimensions are X and Y, and the ...

You are integrating one of your internal IT applications and Google BigQuery, so users can query ...

You are building a data pipeline on Google Cloud. You need to prepare data using a casual method ...

You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters are ru...

You are developing an application that uses a recommendation engine on Google Cloud. Your solutio...

You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQuery fo...

Your infrastructure includes a set of YouTube channels. You have been tasked with creating a proc...

You are designing storage for very large text files for a data pipeline on Google Cloud. You want...

You are developing an application on Google Cloud that will automatically generate subject labels...

You are designing storage for 20 TB of text files as part of deploying a data pipeline on Google ...

You are designing storage for two relational tables that are part of a 10-TB database on Google C...

Your financial services company is moving to cloud technology and wants to store 50 TB of financi...

An organization maintains a Google BigQuery dataset that contains tables with user-level data. Th...

Government regulations in your industry mandate that you have to maintain an auditable record of ...

Your neural network model is taking days to train. You want to increase the training speed. What ...

You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cluster. ...

Your company maintains a hybrid deployment with GCP, where analytics are performed on your anonym...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...

MJTelco Case Study -Company Overview -MJTelco is a startup that plans to build networks in rapidl...