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: Nov 13, 2024

Add To Cart

Question 1

An online brokerage company requires a high volume trade processing architecture. You need to create a secure queuing system that triggers jobs. The jobs will run in Google Cloud and cat the company's Python API to execute trades. You need to efficiently implement a solution. What should you do?

A : Cloud Composer to subscribe to a Pub/Sub tope and can the Python API.

B : a Pub/Sub push subscription to trigger a Cloud Function to pass the data to tie Python API.

C : ite an application that makes a queue in a NoSQL database

D : ite an application hosted on a Compute Engine instance that makes a push subscription to the Pub/Sub topic

Answer: C

Question 2

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 3

If you're running a performance test that depends upon Cloud Bigtable, all the choices except one below are recommended steps. Which is NOT a recommended step to follow?

A : not use a production instance.

B : n your test for at least 10 minutes.

C : fore you test, run a heavy pre-test for several minutes.

D : at least 300 GB of data.

Answer: A

Question 4

A shipping company has live package-tracking data that is sent to an Apache Kafka stream in real time. This is then loaded into BigQuery. Analysts in your company want to query the tracking data in BigQuery to analyze geospatial trends in the lifecycle of a package. The table was originally created with ingest-date partitioning. Over time, the query processing time has increased. You need to implement a change that would improve query performance in BigQuery. What should you do?

A : plement clustering in BigQuery on the ingest date column.

B : plement clustering in BigQuery on the package-tracking ID column.

C : er older data onto Cloud Storage files, and leverage extended tables.

D : -create the table using data partitioning on the package delivery date.

Answer: A

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Nov 13, 2024

Add To Cart