Free Professional Data Engineer Exam Braindumps
Google Cloud Data Engineer Professional Questions 166–170 (page: 35)

Updated On: 10-Feb-2026

You are deploying MariaDB SQL databases on GCE VM Instances and need to configure monitoring and alerting. You want to collect metrics including network connections, disk IO and replication status from MariaDB with minimal development effort and use StackDriver for dashboards and alerts.

What should you do?

  1. Install the OpenCensus Agent and create a custom metric collection application with a StackDriver exporter.
  2. Place the MariaDB instances in an Instance Group with a Health Check.
  3. Install the StackDriver Logging Agent and configure fluentd in_tail plugin to read MariaDB logs.
  4. Install the StackDriver Agent and configure the MySQL plugin.

Answer(s): C



You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants.

What should you do?

  1. Increase the size of the dataset by collecting additional data.
  2. Train a linear regression to predict a credit default risk score.
  3. Remove the bias from the data and collect applications that have been declined loans.
  4. Match loan applicants with their social profiles to enable feature engineering.

Answer(s): B



You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to significantly refactor the application that uses this database and cost to operate is of primary concern.

Which service do you select for storing and serving your data?

  1. Cloud Spanner
  2. Cloud Bigtable
  3. Cloud Firestore
  4. Cloud SQL

Answer(s): D



You're using Bigtable for a real-time application, and you have a heavy load that is a mix of read and writes. You've recently identified an additional use case and need to perform hourly an analytical job to calculate certain statistics across the whole database. You need to ensure both the reliability of your production application as well as the analytical workload.

What should you do?

  1. Export Bigtable dump to GCS and run your analytical job on top of the exported files.
  2. Add a second cluster to an existing instance with a multi-cluster routing, use live-traffic app profile for your regular workload and batch-analytics profile for the analytics workload.
  3. Add a second cluster to an existing instance with a single-cluster routing, use live-traffic app profile for your regular workload and batch-analytics profile for the analytics workload.
  4. Increase the size of your existing cluster twice and execute your analytics workload on your new resized cluster.

Answer(s): B



You are designing an Apache Beam pipeline to enrich data from Cloud Pub/Sub with static reference data from BigQuery. The reference data is small enough to fit in memory on a single worker. The pipeline should write enriched results to BigQuery for analysis.
Which job type and transforms should this pipeline use?

  1. Batch job, PubSubIO, side-inputs
  2. Streaming job, PubSubIO, JdbcIO, side-outputs
  3. Streaming job, PubSubIO, BigQueryIO, side-inputs
  4. Streaming job, PubSubIO, BigQueryIO, side-outputs

Answer(s): C



Viewing page 35 of 78
Viewing questions 171 - 175 out of 401 questions


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

AI Tutor AI Tutor 👋 I’m here to help!