Google Cloud Data Engineer Professional Exam

Certification Provider: Google

Exam Name: Google Cloud Data Engineer Professional

Duration: 120 Minutes

Number of questions in our database: 269

Exam Version: Jun. 29, 2022

Exam Official Topics:

Topic 1: Designing Data Processing Systems/ Flexible Data Representation
Topic 2: Building and Maintaining Data Structures and Databases
Topic 3: Analyzing Data and Enabling Machine Learning
Topic 4: Modeling Business Processes for Analysis and Optimization
Topic 5: Visualizing Data and Advocating Policy/ Automation/ Decision Support/ Data Summarization
Topic 6: Designing and Security Compliance/ Secure Data Infrastructure and Processes

Free Google Google Cloud Data Engineer Professional Exam Actual Questions

The questions for Google Cloud Data Engineer Professional were last updated On Jun. 29, 2022

Question #1

You are building a data pipeline on Google Cloud. You need to prepare data using a casual method for a

machine-learning process. You want to support a logistic regression model. You also need to monitor and

adjust for null values, which must remain real-valued and cannot be removed. What should you do?

AUse Cloud Dataprep to find null values in sample source data. Convert all nulls to 'none' using a Cloud
Dataproc job.

BUse Cloud Dataprep to find null values in sample source data. Convert all nulls to 0 using a Cloud
Dataprep job.

CUse Cloud Dataflow to find null values in sample source data. Convert all nulls to 'none' using a Cloud
Dataprep job.

DUse Cloud Dataflow to find null values in sample source data. Convert all nulls to using a custom script.

Reveal Solution

Correct Answer: C

Question #2

You are managing a Cloud Dataproc cluster. You need to make a job run faster while minimizing costs, without losing work in progress on your clusters. What should you do?

AIncrease the cluster size with more non-preemptible workers.

BIncrease the cluster size with preemptible worker nodes, and configure them to forcefully decommission.

CIncrease the cluster size with preemptible worker nodes, and use Cloud Stackdriver to trigger a script to preserve work.

DIncrease the cluster size with preemptible worker nodes, and configure them to use graceful decommissioning.

Reveal Solution

Correct Answer: D

Question #3

You work for a shipping company that uses handheld scanners to read shipping labels. Your company has strict data privacy standards that require scanners to only transmit recipients' personally identifiable information (PII) to analytics systems, which violates user privacy rules. You want to quickly build a scalable solution using cloud-native managed services to prevent exposure of PII to the analytics systems. What should you do?

ACreate an authorized view in BigQuery to restrict access to tables with sensitive data.

BInstall a third-party data validation tool on Compute Engine virtual machines to check the incoming data for sensitive information.

CUse Stackdriver logging to analyze the data passed through the total pipeline to identify transactions that may contain sensitive information.

DBuild a Cloud Function that reads the topics and makes a call to the Cloud Data Loss Prevention API. Use the tagging and confidence levels to either pass or quarantine the data in a bucket for review.

Reveal Solution

Correct Answer: D

Question #4

You have developed three data processing jobs. One executes a Cloud Dataflow pipeline that transforms data uploaded to Cloud Storage and writes results to BigQuery. The second ingests data from on-premises servers and uploads it to Cloud Storage. The third is a Cloud Dataflow pipeline that gets information from third-party data providers and uploads the information to Cloud Storage. You need to be able to schedule and monitor the execution of these three workflows and manually execute them when needed. What should you do?

ACreate a Direct Acyclic Graph in Cloud Composer to schedule and monitor the jobs.

BUse Stackdriver Monitoring and set up an alert with a Webhook notification to trigger the jobs.

CDevelop an App Engine application to schedule and request the status of the jobs using GCP API calls.

DSet up cron jobs in a Compute Engine instance to schedule and monitor the pipelines using GCP API calls.

Reveal Solution

Correct Answer: D

Question #5

You have Cloud Functions written in Node.js that pull messages from Cloud Pub/Sub and send the data to BigQuery. You observe that the message processing rate on the Pub/Sub topic is orders of magnitude higher than anticipated, but there is no error logged in Stackdriver Log Viewer. What are the two most likely causes of this problem? Choose 2 answers.

APublisher throughput quota is too small.

BTotal outstanding messages exceed the 10-MB maximum.

CError handling in the subscriber code is not handling run-time errors properly.

DThe subscriber code cannot keep up with the messages.

EThe subscriber code does not acknowledge the messages that it pulls.

Reveal Solution

Correct Answer: C, D

Unlock all Google Cloud Data Engineer Professional Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Disscuss Google Google Cloud Data Engineer Professional Topics, Questions or Ask Anything Related

Submit Cancel