Free Professional Data Engineer Exam Braindumps
Google Cloud Data Engineer Professional Questions 156–160 (page: 33)

Updated On: 10-Feb-2026

Government regulations in your industry mandate that you have to maintain an auditable record of access to certain types of dat

  1. Assuming that all expiring logs will be archived correctly, where should you store data that is subject to that mandate?
  2. Encrypted on Cloud Storage with user-supplied encryption keys. A separate decryption key will be given to each authorized user.
  3. In a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability.
  4. In Cloud SQL, with separate database user names to each user. The Cloud SQL Admin activity logs will be used to provide the auditability.
  5. In a bucket on Cloud Storage that is accessible only by an AppEngine service that collects user information and logs the access before providing a link to the bucket.

Answer(s): B



Your neural network model is taking days to train. You want to increase the training speed.
What can you do?

  1. Subsample your test dataset.
  2. Subsample your training dataset.
  3. Increase the number of input features to your model.
  4. Increase the number of layers in your neural network.

Answer(s): D


Reference:

https://towardsdatascience.com/how-to-increase-the-accuracy-of-a-neural-network- 9f5d1c6f407d



You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cluster.
The pipeline will require some checkpointing and splitting pipelines.
Which method should you use to write the pipelines?

  1. PigLatin using Pig
  2. HiveQL using Hive
  3. Java using MapReduce
  4. Python using MapReduce

Answer(s): D



Your company maintains a hybrid deployment with GCP, where analytics are performed on your anonymized customer dat

  1. The data are imported to Cloud Storage from your data center through parallel uploads to a data transfer server running on GCP. Management informs you that the daily transfers take too long and have asked you to fix the problem. You want to maximize transfer speeds.
    Which action should you take?
  2. Increase the CPU size on your server.
  3. Increase the size of the Google Persistent Disk on your server.
  4. Increase your network bandwidth from your datacenter to GCP.
  5. Increase your network bandwidth from Compute Engine to Cloud Storage.

Answer(s): C



After migrating ETL jobs to run on BigQuery, you need to verify that the output of the migrated jobs is the same as the output of the original. You've loaded a table containing the output of the original job and want to compare the contents with output from the migrated job to show that they are identical. The tables do not contain a primary key column that would enable you to join them together for comparison.

What should you do?

  1. Select random samples from the tables using the RAND() function and compare the samples.
  2. Select random samples from the tables using the HASH() function and compare the samples.
  3. Use a Dataproc cluster and the BigQuery Hadoop connector to read the data from each table and calculate a hash from non-timestamp columns of the table after sorting. Compare the hashes of each table.
  4. Create stratified random samples using the OVER() function and compare equivalent samples from each table.

Answer(s): B



Viewing page 33 of 78
Viewing questions 161 - 165 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!