Google Professional Cloud Data Engineer PR000111 Practice Exam Part 2

To give a user read permission for only the first three columns of a table, which access control method would you use?

What are two methods that can be used to denormalize tables in BigQuery?

Which of these is not a supported method of putting data into a partitioned table?

Which of these operations can you perform from the BigQuery Web UI?

Which methods can be used to reduce the number of rows processed by BigQuery?

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

Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?

The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of which types of cluster nodes?

Which software libraries are supported by Cloud Machine Learning Engine?

Which TensorFlow function can you use to configure a categorical column if you don’t know all of the possible values for that column?

Which of the following statements about the Wide & Deep Learning model are true? (Select 2 answers.)

To run a TensorFlow training job on your own computer using Cloud Machine Learning Engine, what would your command start with?

If you want to create a machine learning model that predicts the price of a particular stock based on its recent price history, what type of estimator should you use?

Suppose you have a dataset of images that are each labeled as to whether or not they contain a human face. To create a neural network that recognizes human faces in images using this labeled dataset, what approach would likely be the most effective?

What are two of the characteristics of using online prediction rather than batch prediction?

Which of these are examples of a value in a sparse vector? (Select 2 answers.)

How can you get a neural network to learn about relationships between categories in a categorical feature?

If a dataset contains rows with individual people and columns for year of birth, country, and income, how many of the columns are continuous and how many are categorical?

Which of the following are examples of hyperparameters? (Select 2 answers.)

Which of the following are feature engineering techniques? (Select 2 answers)

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

You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure that any data that is in-flight is processed and written to the output. Which of the following commands can you use on the Dataflow monitoring console to stop the pipeline job?

When running a pipeline that has a BigQuery source, on your local machine, you continue to get permission denied errors. What could be the reason for that?

What Dataflow concept determines when a Window’s contents should be output based on certain criteria being met?

Which of the following is NOT one of the three main types of triggers that Dataflow supports?

Which Java SDK class can you use to run your Dataflow programs locally?

The Dataflow SDKs have been recently transitioned into which Apache service?

The _________ for Cloud Bigtable makes it possible to use Cloud Bigtable in a Cloud Dataflow pipeline.

Does Dataflow process batch data pipelines or streaming data pipelines?

You are planning to use Google’s Dataflow SDK to analyze customer data such as displayed below. Your project requirement is to extract only the customer name from the data source and then write to an output PCollection.
Tom,555 X street –
Tim,553 Y street –
Sam, 111 Z street –
Which operation is best suited for the above data processing requirement?

Which Cloud Dataflow / Beam feature should you use to aggregate data in an unbounded data source every hour based on the time when the data entered the pipeline?

Which of the following is NOT true about Dataflow pipelines?

You are developing a software application using Google’s Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?

Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?

Which of the following is not true about Dataflow pipelines?

By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?

Which of the following job types are supported by Cloud Dataproc (select 3 answers)?

What are the minimum permissions needed for a service account used with Google Dataproc?

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

When creating a new Cloud Dataproc cluster with the projects.regions.clusters.create operation, these four values are required: project, region, name, and ____.