Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Google
  5. Professional Data Engineer

Free Google Professional Data Engineer Exam Questions (page: 8)

Page 8 of 95
PDF with 375 Questions

You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an instant notification to be sent to your monitoring tool when new data is appended to a certain table using an insert job, but you do not want to receive notifications for other tables.
What should you do?

  1. Make a call to the Stackdriver API to list all logs, and apply an advanced filter.
  2. In the Stackdriver logging admin interface, and enable a log sink export to BigQuery.
  3. In the Stackdriver logging admin interface, enable a log sink export to Google Cloud Pub/Sub, and subscribe to the topic from your monitoring tool.
  4. Using the Stackdriver API, create a project sink with advanced log filter to export to Pub/Sub, and subscribe to the topic from your monitoring tool.

Answer(s): B



You are working on a sensitive project involving private user dat

  1. 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?
  2. Grant the consultant the Viewer role on the project.
  3. Grant the consultant the Cloud Dataflow Developer role on the project.
  4. Create a service account and allow the consultant to log on with it.
  5. Create an anonymized sample of the data for the consultant to work with in a different project.

Answer(s): C



You are building a model to predict whether or not it will rain on a given day. You have thousands of input features and want to see if you can improve training speed by removing some features while having a minimum effect on model accuracy.
What can you do?

  1. Eliminate features that are highly correlated to the output labels.
  2. Combine highly co-dependent features into one representative feature.
  3. Instead of feeding in each feature individually, average their values in batches of 3.
  4. Remove the features that have null values for more than 50% of the training records.

Answer(s): B



Your company is performing data preprocessing for a learning algorithm in Google Cloud Dataflow. Numerous data logs are being are being generated during this step, and the team wants to analyze them. Due to the dynamic nature of the campaign, the data is growing exponentially every hour.

The data scientists have written the following code to read the data for a new key features in the logs.

BigQueryIO.Read

.named("ReadLogData")

.from("clouddataflow-readonly:samples.log_data")

You want to improve the performance of this data read.
What should you do?

  1. Specify the Table
    Reference: object in the code.
  2. Use .fromQuery operation to read specific fields from the table.
  3. Use of both the Google BigQuery TableSchema and TableFieldSchema classes.
  4. Call a transform that returns TableRow objects, where each element in the PCollexction represents a single row in the table.

Answer(s): D


Reference:

object in the code.
B. Use .fromQuery operation to read specific fields from the table.
C. Use of both the Google BigQuery TableSchema and TableFieldSchema classes.
D. Call a transform that returns TableRow objects, where each element in the PCollexction represents a single row in the table.

Answer(s): D



Viewing page 8 of 95



Post your Comments and Discuss Google Professional Data Engineer exam prep with other Community members:

Professional Data Engineer Exam Discussions & Posts