Free Access Google.Professional-Data-Engineer.v2026-02-05.q279 Practice Test (Page 23)

Question 106

You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query - -dry_run you learn that the query triggers a full scan of the table, even though the filter on timestamp and ID select a tiny fraction of the overall data. You want to reduce the amount of data scanned by BigQuery with minimal changes to existing SQL queries. What should you do?

A.Create a separate table for each ID.

B.Use the LIMIT keyword to reduce the number of rows returned.

C.Recreate the table with a partitioning column and clustering column.

D.Use the bq query - -maximum_bytes_billedflag to restrict the number of bytes billed.

Question 107

You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?

A.Change the row key syntax in your Cloud Bigtable table to begin with the stock symbol.

B.Change the row key syntax in your Cloud Bigtable table to begin with a random number per second.

C.Change the data pipeline to use BigQuery for storing stock trades, and update your application.

D.Use Cloud Dataflow to write summary of each day's stock trades to an Avro file on Cloud Storage.
Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.

Question 108

How can you get a neural network to learn about relationships between categories in a categorical feature?

A.Create a multi-hot column

B.Create a one-hot column

C.Create a hash bucket

D.Create an embedding column

Question 109

You are working on a sensitive project involving private user data. 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?

A.Grant the consultant the Viewer role on the project.

B.Create a service account and allow the consultant to log on with it.

C.Create an anonymized sample of the data for the consultant to work with in a different project.

D.Grant the consultant the Cloud Dataflow Developer role on the project.

Question 110

The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of which types of cluster nodes?

A.Workers

B.Masters, workers, and parameter servers

C.Workers and parameter servers

D.Parameter servers

Other Version: 1862Google.Professional-Data-Engineer.v2025-09-04.q126; 1835Google.Professional-Data-Engineer.v2025-03-18.q108; 3293Google.Professional-Data-Engineer.v2024-12-09.q327; 3353Google.Professional-Data-Engineer.v2024-02-15.q202; 3834Google.Professional-Data-Engineer.v2023-09-14.q233; 5026Google.Professional-Data-Engineer.v2022-07-07.q155; 7167Google.Professional-Data-Engineer.v2022-02-11.q268; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

Latest Upload: 176NAHQ.CPHQ.v2026-09-03.q481; 114SAP.C-S4CPB-2602.v2026-09-02.q7; 110Cisco.700-805.v2026-09-02.q86; 161MSSC.CLT-4.0.v2026-09-02.q43; 126Fitness.NCSF-CPT.v2026-09-02.q18; 174Google.Generative-AI-Leader.v2026-09-02.q77; 139PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 126Google.GCP-DE.v2026-09-01.q27; 161Cisco.300-820.v2026-09-01.q105; 154Cisco.500-220.v2026-09-01.q72

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File