PROFESSIONAL-DATA-ENGINEER Exam Questions

Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an er...

What are two of the benefits of using denormalized data structures in BigQuery?

What are all of the BigQuery operations that Google charges for?

Which of the following is not possible using primitive roles?

Which of these statements about BigQuery caching is true?

Which of these sources can you not load data into BigQuery from?

Which of the following statements about Legacy SQL and Standard SQL is not true?

How would you query specific partitions in a BigQuery table?

Which SQL keyword can be used to reduce the number of columns processed by BigQuery?

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 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)?

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?

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 th...

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.)

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?

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 _________ 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 a...

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?

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 pipelin...

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 ____.

Which Google Cloud Platform service is an alternative to Hadoop with Hive?

Which of these rules apply when you add preemptible workers to a Dataproc cluster (select 2 answers)?

When using Cloud Dataproc clusters, you can access the YARN web interface by configuring a browser to connect through a ____ proxy.

Cloud Dataproc is a managed Apache Hadoop and Apache _____ service.

Which action can a Cloud Dataproc Viewer perform?

Dataproc clusters contain many configuration files. To update these files, you will need to use the --properties option. The format for the option is: file_prefix:property=_____.

Scaling a Cloud Dataproc cluster typically involves ____.

Cloud Dataproc charges you only for what you really use with _____ billing.