Free Practice Google Professional-Data-Engineer Exam Questions 2026

Stay ahead with 100% Free Cloud Certified Professional Data Engineer Professional-Data-Engineer Dumps Practice Questions

Page: 1 / 95

Total 472 Questions | Updated On: Feb 19, 2026

Add To Cart

Question 1

Your company's customer_order table in BigOuery stores the order history for 10 million customers, with a

table size of 10 PB. You need to create a dashboard for the support team to view the order history. The

dashboard has two filters, countryname and username. Both are string data types in the BigQuery table. When

a filter is applied, the dashboard fetches the order history from the table and displays the query results.

However, the dashboard is slow to show the results when applying the filters to the following query:

How should you redesign the BigQuery table to support faster access?

A : Cluster the table by country field, and partition by username field.

B : Partition the table by country and username fields.

C : Cluster the table by country and username fields

D : Partition the table by _PARTITIONTIME.

Answer: C

Question 2

Messages are unexpectedly accumulating in service using Cloud Pub/Sub. A developer unfamiliar with Cloud Pub/Sub has asked for our help in diagnosing the problem. What would you point out with respect to how messages are removed from Cloud Pub/Sub topics?

A : Once at least one subscriber for each topic has acknowledged the message it will be deleted from storage.

B : Once at least one subscriber for each bucket has acknowledged the message it will be deleted from storage.

C : Once at least one subscriber for any subscription has acknowledged the message it will be deleted from storage.

D : Once at least one subscriber for each subscription has acknowledged the message it will be deleted from storage.

Answer: D

Question 3

A European health care company uses Cloud Pub/Sub as part of a data processing pipeline. The CTO of the company is concerned that data might accidentally be written to a region outside the European Union, which would violate the GDPR regulation. What would you recommend the company does to ensure data stays within Google Cloud regions in the European Union?

A : Set a Resource Location Restriction organization policy to ensure all topics are stored only in acceptable regions.

B : Set a Resource Location Restriction organization policy to ensure all buckets are stored only in acceptable regions.

C : Only define Cloud Pub/Sub endpoints in acceptable regions when creating topics.

D : Only define Cloud Pub/Sub endpoints in acceptable regions when creating subscriptions.

Answer: A

Question 4

Your startup has a web application that currently serves customers out of a single region in Asia. You are

targeting funding that will allow your startup lo serve customers globally. Your current goal is to optimize for

cost, and your post-funding goat is to optimize for global presence and performance. You must use a native

JDBC driver. What should you do?

A : Use Cloud Spanner to configure a single region instance initially. and then configure multi-region C oudSpanner instances after securing funding.

B : Use a Cloud SQL for PostgreSQL highly available instance first, and 8»gtable with US. Europe, andAsia replication alter securing funding

C : Use a Cloud SQL for PostgreSQL zonal instance first and Bigtable with US. Europe, and Asia aftersecuring funding.

D : Use a Cloud SOL for PostgreSQL zonal instance first, and Cloud SOL for PostgreSQL with highlyavailable configuration after securing funding.

Answer: A

Question 5

A team of data scientists has been using an on-premises cluster running Hadoop and HBase. They want to migrate to a managed service in Google Cloud. They also want to minimize changes to programs that make extensive use of the HBase API. What GCP service would you recommend?

A : Bigtable

B : BigQuery

C : Cloud Spanner

D : Cloud Dataflow

Answer: A

Page: 1 / 95

Total 472 Questions | Updated On: Feb 19, 2026

Add To Cart