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: Mar 12, 2025

Add To Cart

Question 1

Which of these operations can you perform from the BigQuery Web UI?

A : load a file in SQL format.

B : ad data with nested and repeated fields.

C : load a 20 MB file.

D : load multiple files using a wildcard.

Answer: B

Question 2

You are developing a data pipeline that will run several data transformation programs on Compute Engine virtual machines. You do not want to use your credentials for authenticating and authorizing these programs. You want to follow Google Cloud recommended practices, how would you authenticate and authorize the data transformation programs?

A : Create a Gmail account and use that account to create an IAM group. Store the password for the group in Secret Manager.

B : Create a service account and assign roles to the service account that are needed to execute the data transformation programs. Use Google managed keys to store both public and private portion of the service account keys.

C : Create a Gmail account and use that account to create an IAM user. Store the password for the account in Secret Manager.

D : Create a service account and assign roles to the service account that are needed to execute the data transformation programs. Use Secret Manager to store service account keys.

Answer: B

Question 3

Your company maintains a hybrid deployment with GCP, where analytics are performed on your anonymized customer data. The data are imported to Cloud Storage from your data center through parallel uploads to a data transfer server running on GCP. Management informs you that the daily transfers take too long and have asked you to fix the problem. You want to maximize transfer speeds. Which action should you take?

A : crease the CPU size on your server.

B : crease the size of the Google Persistent Disk on your server.

C : crease your network bandwidth from your datacenter to GCP.

D : crease your network bandwidth from Compute Engine to Cloud Storage.

Answer: C

Question 4

By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?

A : ndows at every 100 MB of data

B : ngle, Global Window

C : ndows at every 1 minute

D : ndows at every 10 minutes

Answer: B

Question 5

You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub through Cloud Dataflow to BigQuery. While previewing the data, you notice that roughly 2% of the data appears to be corrupt. You need to modify the Cloud Dataflow pipeline to filter out this corrupt data. What should you do?

A : a SideInput that returns a Boolean if the element is corrupt.

B : a ParDo transform in Cloud Dataflow to discard corrupt elements

C : a Partition transform in Cloud Dataflow to separate valid data from corrupt data.

D : a GroupByKey transform in Cloud Dataflow to group all of the valid data together and discard the rest.

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Mar 12, 2025

Add To Cart