Free Access Google.Professional-Data-Engineer.v2024-02-15.q202 Practice Test (Page 27)

Question 126

You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuery table. You expect significant growth in data volume and need the data to be available within 1 minute of ingestion for real-time analysis of aggregated trends. What should you do?

A.Use a Cloud Dataflow pipeline to stream data into the BigQuery table.

B.Use the INSERT statement to insert a batch of data every 60 seconds.

C.Use bq load to load a batch of sensor data every 60 seconds.

D.Use the MERGE statement to apply updates in batch every 60 seconds.

Question 127

You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

A.Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.

B.Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.

C.Create a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.

D.Create a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.

Question 128

You are implementing security best practices on your data pipeline. Currently, you are manually executing jobs as the Project Owner. You want to automate these jobs by taking nightly batch files containing non- public information from Google Cloud Storage, processing them with a Spark Scala job on a Google Cloud Dataproc cluster, and depositing the results into Google BigQuery.
How should you securely run this workload?

A.Use a user account with the Project Viewer role on the Cloud Dataproc cluster to read the batch files and write to BigQuery

B.Restrict the Google Cloud Storage bucket so only you can see the files

C.Grant the Project Owner role to a service account, and run the job with it

D.Use a service account with the ability to read the batch files and to write to BigQuery

Question 129

Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?

A.Weights

B.Biases

C.Continuous features

D.Input values

Question 130

Which of the following is NOT a valid use case to select HDD (hard disk drives) as the storage for Google Cloud Bigtable?

A.You expect to store at least 10 TB of data.

B.You will mostly run batch workloads with scans and writes, rather than frequently executing random reads of a small number of rows.

C.You need to integrate with Google BigQuery.

D.You will not use the data to back a user-facing or latency-sensitive application.

Other Version: 1172Google.Professional-Data-Engineer.v2026-02-05.q279; 1457Google.Professional-Data-Engineer.v2025-09-04.q126; 1464Google.Professional-Data-Engineer.v2025-03-18.q108; 2660Google.Professional-Data-Engineer.v2024-12-09.q327; 3259Google.Professional-Data-Engineer.v2023-09-14.q233; 4657Google.Professional-Data-Engineer.v2022-07-07.q155; 6650Google.Professional-Data-Engineer.v2022-02-11.q268; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 299Nokia.4A0-113.v2026-05-01.q69; 258EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 211Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 335NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 465EMC.D-AV-DY-23.v2026-04-27.q184; 1120ServiceNow.CSA.v2026-04-27.q483

Question 126

Question 127

Question 128

Question 129

Question 130

Download PDF File