Free Google Professional-Data-Engineer Exam Questions

You are using BigQuery with a regional dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?

You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants. What should you do?

You are running a Dataflow streaming pipeline, with Streaming Engine and Horizontal Autoscaling enabled.

You have set the maximum number of workers to 1000. The input of your pipeline is Pub/Sub messages with

notifications from Cloud Storage One of the pipeline transforms reads CSV files and emits an element for

every CSV line. The Job performance is low. the pipeline is using only 10 workers, and you notice that the

autoscaler is not spinning up additional workers. What should you do to improve performance?

Your startup has a web application that currently serves customers out of a single region in Asia. You are

targeting funding that will allow your startup lo serve customers globally. Your current goal is to optimize for

cost, and your post-funding goat is to optimize for global presence and performance. You must use a native

JDBC driver. What should you do?

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?