1|Page
GCP Professional Data Engineer 2025–2026
Cloud Data Engineering & Analytics
Complete Certification Study Guide & Exam Review
You are experimenting with the GCP Translation API. You have created a Jupyter Notebook
and plan to use Python 3 to build a proof-of-concept system. What are the first two
operations that you would execute in your notebook to start using the Translation API?
A. Import Translation libraries and create a translation client
B. Create a translation client and encode text in UTF-8
C. Create a translation client, and set a variable to TRANSLATE to pass in as a parameter to the
API function call
D. Import Translation libraries, and set a variable to TRANSLATE to pass in as a parameter to
the API function call - ANSWER=A. The correct answer is A. The first two steps are to import
libraries and to create a translation client data structure. Option B is incorrect because the
translation client can't be created when importing the libraries first. Options C and D are
incorrect because there is no need to pass a parameter into the API with the operation when
there is a specific function call for translating.
You have been hired by a law firm to help analyze a large volume of documents related to a
legal case. There are approximately 10,000 documents ranging from 1 to 15 pages in length.
They are all written in English. The lawyers hiring you want to understand who is mentioned
in each document so that they can understand how those individuals worked together. What
functionality of the Natural Language API would you use?
,2|Page
A. Identifying entities
B. Analyzing sentiment associated with each entity
C. Analyzing sentiment of the overall text
D. Generating syntactic analysis - ANSWER=A. The correct answer is A. The goal is to identify
people, which are one kind of entity, so entity extraction is the correct functionality. Options
B and C are incorrect because there is no requirement to understand the sentiment of the
communications. Option D is incorrect because syntactic analysis does not help with
identifying individuals.
As a founder of an e-commerce startup, you are particularly interested in engaging with your
customers. You decide to use the GCP Recommendations AI API using the "others you may
like" recommendation type. You want to maximize the likelihood that users will engage with
your recommendations. What optimization objective would you choose?
A. Click-through rate (CTR)
B. Revenue per order
C. Conversation rate
D. Total revenue - ANSWER=A. The correct answer is A. Click-through rate (CTR) is the default
optimization, and it maximizes the likelihood that the user engages the recommendation.
Option B is incorrect; revenue per order is only available with the "frequently bought
together" recommendation
type. Option C is incorrect; conversation rate optimizes for the likelihood that the user
purchases the recommended product. Option D is incorrect; total revenue is a metric for
measuring performance, not an optimization objective.
,3|Page
Auditors have informed your company CFO that to comply with a new regulation, your
company will need to ensure that financial reporting data is kept for at least three years. The
CFO asks for your advice on how to comply with the regulation with the least administrative
overhead. What would you recommend?
A. Store the data on Coldline storage
B. Store the data on multi-regional storage
C. Define a data retention policy
D. Define a lifecycle policy - ANSWER=C. The correct answer is C. A data retention policy will
ensure that files are not deleted from a storage bucket until they reach a specified age.
Options A and B are incorrect because files can be deleted from Coldline or multi-regional
data unless a data retention policy is in place. Option D is incorrect because a lifecycle policy
will change the storage type on an object but not prevent it from being deleted.
As a database administrator tasked with migrating a MongoDB instance to Google Cloud, you
are concerned about your ability to configure the database optimally. You want to collect
metrics at both the instance level and the database server level. What would you do in
addition to creating an instance and installing and configuring MongoDB to ensure that you
can monitor key instances and database metrics?
A. Install Stackdriver Logging agent.
B. Install Stackdriver Monitoring agent.
C. Install Stackdriver Debug agent.
D. Nothing. By default, the database instance will send metrics to Stackdriver. - ANSWER=B.
The correct answer is B, installing the Stackdriver Monitoring agent. This will collect
, 4|Page
application-level metrics and send them to Stackdriver for alerting and charting. Option
A is incorrect because Stackdriver Logging does not collect metrics, but you would install
the Stackdriver Logging agent if you also wanted to collect database logs. Option C is
incorrect; Stackdriver Debug is for analyzing a running program. Option D is incorrect; by
default, you will get only instance metrics and audit logs.
A group of data scientists have uploaded multiple time-series datasets to BigQuery over the
last year. They have noticed that their queries—which select up to six columns, apply four SQL
functions, and group by the day of a timestamp—are taking longer to run and are incurring
higher BigQuery costs as they add data. They do not understand why this is thecase since they
typically work only with the most recent set of data loaded. What would you recommend
they consider in order to reduce query latency and query costs?
A. Sort the data by time order before loading
B. Stop using Legacy SQL and use Standard SQL dialect
C. Partition the table and use clustering
D. Add more columns to the SELECT statement to use data fetched by BigQuery more
efficiently - ANSWER=C. The correct answer is C. The queries are likely scanning more data
than needed. Partitioning the table will enable BigQuery to scan only data within a partition,
and clustering will improve the way column data is stored. Option A is incorrect because
BigQuery organizes data according to table configuration parameters, and there is no
indication that queries need to order results. Option B is incorrect; Standard SQL dialect has
more SQL features but none of those are used. Also, it is unlikely that the query
GCP Professional Data Engineer 2025–2026
Cloud Data Engineering & Analytics
Complete Certification Study Guide & Exam Review
You are experimenting with the GCP Translation API. You have created a Jupyter Notebook
and plan to use Python 3 to build a proof-of-concept system. What are the first two
operations that you would execute in your notebook to start using the Translation API?
A. Import Translation libraries and create a translation client
B. Create a translation client and encode text in UTF-8
C. Create a translation client, and set a variable to TRANSLATE to pass in as a parameter to the
API function call
D. Import Translation libraries, and set a variable to TRANSLATE to pass in as a parameter to
the API function call - ANSWER=A. The correct answer is A. The first two steps are to import
libraries and to create a translation client data structure. Option B is incorrect because the
translation client can't be created when importing the libraries first. Options C and D are
incorrect because there is no need to pass a parameter into the API with the operation when
there is a specific function call for translating.
You have been hired by a law firm to help analyze a large volume of documents related to a
legal case. There are approximately 10,000 documents ranging from 1 to 15 pages in length.
They are all written in English. The lawyers hiring you want to understand who is mentioned
in each document so that they can understand how those individuals worked together. What
functionality of the Natural Language API would you use?
,2|Page
A. Identifying entities
B. Analyzing sentiment associated with each entity
C. Analyzing sentiment of the overall text
D. Generating syntactic analysis - ANSWER=A. The correct answer is A. The goal is to identify
people, which are one kind of entity, so entity extraction is the correct functionality. Options
B and C are incorrect because there is no requirement to understand the sentiment of the
communications. Option D is incorrect because syntactic analysis does not help with
identifying individuals.
As a founder of an e-commerce startup, you are particularly interested in engaging with your
customers. You decide to use the GCP Recommendations AI API using the "others you may
like" recommendation type. You want to maximize the likelihood that users will engage with
your recommendations. What optimization objective would you choose?
A. Click-through rate (CTR)
B. Revenue per order
C. Conversation rate
D. Total revenue - ANSWER=A. The correct answer is A. Click-through rate (CTR) is the default
optimization, and it maximizes the likelihood that the user engages the recommendation.
Option B is incorrect; revenue per order is only available with the "frequently bought
together" recommendation
type. Option C is incorrect; conversation rate optimizes for the likelihood that the user
purchases the recommended product. Option D is incorrect; total revenue is a metric for
measuring performance, not an optimization objective.
,3|Page
Auditors have informed your company CFO that to comply with a new regulation, your
company will need to ensure that financial reporting data is kept for at least three years. The
CFO asks for your advice on how to comply with the regulation with the least administrative
overhead. What would you recommend?
A. Store the data on Coldline storage
B. Store the data on multi-regional storage
C. Define a data retention policy
D. Define a lifecycle policy - ANSWER=C. The correct answer is C. A data retention policy will
ensure that files are not deleted from a storage bucket until they reach a specified age.
Options A and B are incorrect because files can be deleted from Coldline or multi-regional
data unless a data retention policy is in place. Option D is incorrect because a lifecycle policy
will change the storage type on an object but not prevent it from being deleted.
As a database administrator tasked with migrating a MongoDB instance to Google Cloud, you
are concerned about your ability to configure the database optimally. You want to collect
metrics at both the instance level and the database server level. What would you do in
addition to creating an instance and installing and configuring MongoDB to ensure that you
can monitor key instances and database metrics?
A. Install Stackdriver Logging agent.
B. Install Stackdriver Monitoring agent.
C. Install Stackdriver Debug agent.
D. Nothing. By default, the database instance will send metrics to Stackdriver. - ANSWER=B.
The correct answer is B, installing the Stackdriver Monitoring agent. This will collect
, 4|Page
application-level metrics and send them to Stackdriver for alerting and charting. Option
A is incorrect because Stackdriver Logging does not collect metrics, but you would install
the Stackdriver Logging agent if you also wanted to collect database logs. Option C is
incorrect; Stackdriver Debug is for analyzing a running program. Option D is incorrect; by
default, you will get only instance metrics and audit logs.
A group of data scientists have uploaded multiple time-series datasets to BigQuery over the
last year. They have noticed that their queries—which select up to six columns, apply four SQL
functions, and group by the day of a timestamp—are taking longer to run and are incurring
higher BigQuery costs as they add data. They do not understand why this is thecase since they
typically work only with the most recent set of data loaded. What would you recommend
they consider in order to reduce query latency and query costs?
A. Sort the data by time order before loading
B. Stop using Legacy SQL and use Standard SQL dialect
C. Partition the table and use clustering
D. Add more columns to the SELECT statement to use data fetched by BigQuery more
efficiently - ANSWER=C. The correct answer is C. The queries are likely scanning more data
than needed. Partitioning the table will enable BigQuery to scan only data within a partition,
and clustering will improve the way column data is stored. Option A is incorrect because
BigQuery organizes data according to table configuration parameters, and there is no
indication that queries need to order results. Option B is incorrect; Standard SQL dialect has
more SQL features but none of those are used. Also, it is unlikely that the query
