Google Professional-Data-Engineer Exam Real Questions

Prepare and pass your Cloud Certified Professional Data Engineer with free Professional-Data-Engineer exam questions.

Page: 1 / 95

Total 472 Questions | Updated On: Oct 25, 2024

Add To Cart

Question 1

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third

month the schema of the files changes. Your requirements for implementing these transformations include:

Executing the transformations on a schedule

Enabling non-developer analysts to modify transformations

Providing a graphical tool for designing transformations

What should you do?

A : Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis

B : ad each month’s CSV data into BigQuery, and write a SQL query to transform the data to a standard schema. Merge the transformed tables together with a SQL query

C : lp the analysts write a Cloud Dataflow pipeline in Python to perform the transformation. The Python code should be stored in a revision control system and modified as the incoming data’s schema changes

D : Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe. Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

Answer: D

Question 2

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

Question 3

Your company is currently setting up data pipelines for their campaign. For all the Google Cloud Pub/Sub streaming data, one of the important business requirements is to be able to periodically identify the inputs and their timings during their campaign. Engineers have decided to use windowing and transformation in Google Cloud Dataflow for this purpose. However, when testing this feature, they find that the Cloud Dataflow job fails for the all streaming insert. What is the most likely cause of this problem?

A : ey have not assigned the timestamp, which causes the job to fail

B : ey have not set the triggers to accommodate the data coming in late, which causes the job to fail

C : ey have not applied a global windowing function, which causes the job to fail when the pipeline is created

D : ey have not applied a non-global windowing function, which causes the job to fail when the pipeline is created

Answer: C

Question 4

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

A : eate an authorized view on the BigQuery table to control data access, and provide third-party companies with access to that view.

B : Cloud Scheduler to export the data on a regular basis to Cloud Storage, and provide third-party companies with access to the bucket.

C : eate a separate dataset in BigQuery that contains the relevant data to share, and provide third-party companies with access to the new dataset.

D : eate a Cloud Dataflow job that reads the data in frequent time intervals, and writes it to the relevant BigQuery dataset or Cloud Storage bucket for third-party companies to use.

Answer: B

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Oct 25, 2024

Add To Cart