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: Jun 17, 2026

Add To Cart

Question 1

Which of these statements about exporting data from BigQuery is false?

A : export more than 1 GB of data, you need to put a wildcard in the destination filename.

B : only supported export destination is Google Cloud Storage.

C : ta can only be exported in JSON or Avro format.

D : only compression option available is GZIP.

Answer: C

Question 2

How would you query specific partitions in a BigQuery table?

A : the DAY column in the WHERE clause

B : the EXTRACT(DAY) clause

C : the __PARTITIONTIME pseudo-column in the WHERE clause

D : DATE BETWEEN in the WHERE clause

Answer: C

Question 3

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 4

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

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Jun 17, 2026

Add To Cart