Free Practice Google Professional-Data-Engineer Exam Questions 2025

You are developing an Apache Beam pipeline to extract data from a Cloud SQL instance by using JdbclO.

You have two projects running in Google Cloud. The pipeline will be deployed and executed on Dataflow in

Project A. The Cloud SQL instance is running jn Project B and does not have a public IP address. After

deploying the pipeline, you noticed that the pipeline failed to extract data from the Cloud SQL instance due to

connection failure. You verified that VPC Service Controls and shared VPC are not in use in these projects.

You want to resolve this error while ensuring that the data does not go through the public internet. What

should you do?

Which of these statements about exporting data from BigQuery is false?

A team of data scientists has been using an on-premises cluster running Hadoop and HBase. They want to migrate to a managed service in Google Cloud. They also want to minimize changes to programs that make extensive use of the HBase API. What GCP service would you recommend?

A data analyst currently has the bigquery.dataViewer role and can successfully query a materialized view. They also want to be able to refresh the materialized view. You want to use a predefined role but not grant them any more permissions than needed to refresh the materialized view. What predefined role would you grant to the user?

You work for a manufacturing plant that batches application log files together into a single log file once a day at 2:00 AM. You have written a Google Cloud Dataflow job to process that log file. You need to make sure the log file in processed once per day as inexpensively as possible. What should you do?