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: Aug 21, 2019

Add To Cart

Question 1

In order to securely transfer web traffic data from your computer's web browser to the Cloud Dataproc cluster you should use a(n) _____.

A : N connection

B : ecial browser

C : H tunnel

D : P connection

Answer: C

Question 2

You are designing a basket abandonment system for an ecommerce company. The system will send a message

to a user based on these rules:

No interaction by the user on the site for 1 hour

Has added more than $30 worth of products to the basket

Has not completed a transaction

You use Google Cloud Dataflow to process the data and decide if a message should be sent. How should you

design the pipeline?

A : a fixed-time window with a duration of 60 minutes.

B : a sliding time window with a duration of 60 minutes.

C : a session window with a gap time duration of 60 minutes.

D : a global window with a time based trigger with a delay of 60 minutes.

Answer: C

Question 3

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 4

Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?

A : taproc Worker

B : taproc Viewer

C : taproc Runner

D : taproc Editor

Answer: A

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Aug 21, 2019

Add To Cart