Free Google Professional-Data-Engineer Exam Questions

Become Google Certified with updated Professional-Data-Engineer exam questions and correct answers

Page: 1 / 95

Total 472 Questions | Updated On: Feb 19, 2026

Add To Cart

Question 1

Which of these are examples of a value in a sparse vector? (Select 2 answers.)

A : [0, 5, 0, 0, 0, 0]

B : [0, 0, 0, 1, 0, 0, 1]

C : [0, 1]

D : [1, 0, 0, 0, 0, 0, 0]

Answer: C,D

Question 2

You want to schedule a number of sequential load and transformation jobs Data files will be added to a Cloud

Storage bucket by an upstream process There is no fixed schedule for when the new data arrives Next, a

Dataproc job is triggered to perform some transformations and write the data to BigQuery. You then need to

run additional transformation jobs in BigQuery The transformation jobs are different for every table These

jobs might take hours to complete You need to determine the most efficient and maintainable workflow to

process hundreds of tables and provide the freshest data to your end users. What should you do?

A : 1Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Cloud Storage. Dataproc. and BigQuery operators2 Use a single shared DAG for all tables that need to go through the pipeline3 Schedule the DAG to run hourly

B : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Dataproc and BigQuery operators.2 Create a separate DAG for each table that needs to go through the pipeline3 Use a Cloud Storage object trigger to launch a Cloud Function that triggers the DAG

C : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Cloud Storage, Dataproc. and BigQuery operators2 Create a separate DAG for each table that needs to go through the pipeline3 Schedule the DAGs to run hourly

D : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Dataproc and BigQuery operators2 Use a single shared DAG for all tables that need to go through the pipeline.3 Use a Cloud Storage object trigger to launch a Cloud Function that triggers the DAG

Answer: B

Question 3

Your weather app queries a database every 15 minutes to get the current temperature. The frontend is powered by Google App Engine and server millions of users. How should you design the frontend to respond to a database failure?

A : ue a command to restart the database servers.

B : try the query with exponential backoff, up to a cap of 15 minutes.

C : try the query every second until it comes back online to minimize staleness of data.

D : duce the query frequency to once every hour until the database comes back online.

Answer: B

Question 4

You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants. What should you do?

A : crease the size of the dataset by collecting additional data.

B : ain a linear regression to predict a credit default risk score.

C : move the bias from the data and collect applications that have been declined loans.

D : tch loan applicants with their social profiles to enable feature engineering.

Answer: B

Question 5

An online brokerage company requires a high volume trade processing architecture. You need to create a secure queuing system that triggers jobs. The jobs will run in Google Cloud and cat the company's Python API to execute trades. You need to efficiently implement a solution. What should you do?

A : Cloud Composer to subscribe to a Pub/Sub tope and can the Python API.

B : a Pub/Sub push subscription to trigger a Cloud Function to pass the data to tie Python API.

C : ite an application that makes a queue in a NoSQL database

D : ite an application hosted on a Compute Engine instance that makes a push subscription to the Pub/Sub topic

Answer: C

Page: 1 / 95

Total 472 Questions | Updated On: Feb 19, 2026

Add To Cart