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

Question 36

Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only to the minimum amount of information required to do their jobs. You want to enforce this requirement with Google BigQuery. Which three approaches can you take? (Choose three.)

A.Disable writes to certain tables.

B.Restrict access to tables by role.

C.Ensure that the data is encrypted at all times.

D.Restrict BigQuery API access to approved users.

E.Segregate data across multiple tables or databases.

F.Use Google Stackdriver Audit Logging to determine policy violations.

Question 37

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

A.Both batch and streaming

B.BigQuery cannot be used as a sink

C.Only batch

D.Only streaming

Question 38

Which TensorFlow function can you use to configure a categorical column if you don't know all of the possible values for that column?

A.categorical_column_with_vocabulary_list

B.categorical_column_with_hash_bucket

C.categorical_column_with_unknown_values

D.sparse_column_with_keys

Question 39

You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?

A.Transform text files to compressed Avro using Cloud Dataflow. Use BigQuery for storage and query.

B.Transform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query.

C.Compress text files to gzip using the Grid Computing Tools. Use BigQuery for storage and query.

D.Compress text files to gzip using the Grid Computing Tools. Use Cloud Storage, and then import into Cloud Bigtable for query.

Question 40

You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively querying data. Which query type should you use?

A.Include ORDER BY DESK on timestamp column and LIMIT to 1.

B.Use GROUP BY on the unique ID column and timestamp column and SUM on the values.

C.Use the LAG window function with PARTITION by unique ID along with WHERE LAG IS NOT NULL.

D.Use the ROW_NUMBER window function with PARTITION by unique ID along with WHERE row equals 1.

Other Version: 1634Google.Professional-Data-Engineer.v2025-09-04.q126; 1634Google.Professional-Data-Engineer.v2025-03-18.q108; 2978Google.Professional-Data-Engineer.v2024-12-09.q327; 3087Google.Professional-Data-Engineer.v2024-02-15.q202; 3490Google.Professional-Data-Engineer.v2023-09-14.q233; 4872Google.Professional-Data-Engineer.v2022-07-07.q155; 6950Google.Professional-Data-Engineer.v2022-02-11.q268; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

Latest Upload: 391PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 514Nokia.4A0-113.v2026-05-01.q69; 572EC-COUNCIL.312-49v11.v2026-04-30.q214; 515Microsoft.MB-820.v2026-04-30.q101; 388Salesforce.MC-202.v2026-04-30.q57; 455BICSI.INSTC_V8.v2026-04-29.q53; 563NMLS.MLO.v2026-04-28.q82; 389NCARB.Project-Management.v2026-04-28.q27; 709EMC.D-AV-DY-23.v2026-04-27.q184; 1899ServiceNow.CSA.v2026-04-27.q483

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File