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: Jul 13, 2026

Add To Cart

Question 1

You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as

its data source. It is company policy to ensure employees can view only the data associated with their region,

so you create and populate a table for each region. You need to enforce the regional access policy to the data.

Which two actions should you take? (Choose two.)

A : ure all the tables are included in global dataset.

B : ure each table is included in a dataset for a region.

C : just the settings for each table to allow a related region-based security group view access.

D : just the settings for each view to allow a related region-based security group view access.

E : just the settings for each dataset to allow a related region-based security group view access.

Answer: A,D

Question 2

An aerospace company uses a proprietary data format to store its night dat

a. You need to connect this new data source to BigQuery and stream the data into BigQuery. You want to efficiency import the data into BigQuery where consuming as few resources as possible. What should you do?

A : a standard Dataflow pipeline to store the raw data in BigQuery and then transform the format later when the data is used.

B : ite a shell script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source

C : Apache Hive to write a Dataproc job that streams the data into BigQuery in CSV format

D : an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format

Answer: D

Question 3

You are developing a software application using Google's Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?

A : ollection

B : ansform

C : peline

D : nk API

Answer: B

Question 4

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 5

Your company produces 20,000 files every hour. Each data file is formatted as a comma separated values (CSV) file that is less than 4 KB. All files must be ingested on Google Cloud Platform before they can be processed. Your company site has a 200 ms latency to Google Cloud, and your Internet connection bandwidth is limited as 50 Mbps. You currently deploy a secure FTP (SFTP) server on a virtual machine in Google Compute Engine as the data ingestion point. A local SFTP client runs on a dedicated machine to transmit the CSV files as is. The goal is to make reports with data from the previous day available to the executives by 10:00 a.m. each day. This design is barely able to keep up with the current volume, even though the bandwidth utilization is rather low. You are told that due to seasonality, your company expects the number of files to double for the next three months. Which two actions should you take? (choose two.)

A : troduce data compression for each file to increase the rate file of file transfer.

B : ntact your internet service provider (ISP) to increase your maximum bandwidth to at least 100 Mbps.

C : design the data ingestion process to use gsutil tool to send the CSV files to a storage bucket in parallel.

D : emble 1,000 files into a tape archive (TAR) file. Transmit the TAR files instead, and disassemble the CSV files in the cloud upon receiving them.

E : eate an S3-compatible storage endpoint in your network, and use Google Cloud Storage Transfer Service to transfer on-premices data to the designated storage bucket.

Answer: A

Page: 1 / 95

Total 472 Questions | Updated On: Jul 13, 2026

Add To Cart