Free Google Professional-Data-Engineer Exam Questions

Why do you need to split a machine learning dataset into training data and test data?

You are working on a sensitive project involving private user data. You have set up a project on Google Cloud Platform to house your work internally. An external consultant is going to assist with coding a complex transformation in a Google Cloud Dataflow pipeline for your project. How should you maintain users’ privacy?

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 are migrating a table to BigQuery and are deeding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID and the city and state in which the store is located You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state city and individual store. You want to model this table to minimize query time and cost. 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?