Free Access Google.Professional-Data-Engineer.v2022-02-11.q268 Practice Test (Page 18)

Question 81

Your weather app queries a database every 15 minutes to get the current temperature. The frontend is powered by Google App Engine and server millions of users. How should you design the frontend to respond to a database failure?

A.Issue a command to restart the database servers.

B.Retry the query with exponential backoff, up to a cap of 15 minutes.

C.Retry the query every second until it comes back online to minimize staleness of data.

D.Reduce the query frequency to once every hour until the database comes back online.

Question 82

You are designing a data processing pipeline. The pipeline must be able to scale automatically as load increases. Messages must be processed at least once, and must be ordered within windows of 1 hour. How should you design the solution?

A.Use Cloud Pub/Sub for message ingestion and Cloud Dataproc for streaming analysis.

B.Use Cloud Pub/Sub for message ingestion and Cloud Dataflow for streaming analysis.

C.Use Apache Kafka for message ingestion and use Cloud Dataproc for streaming analysis.

D.Use Apache Kafka for message ingestion and use Cloud Dataflow for streaming analysis.

Question 83

You architect a system to analyze seismic data. Your extract, transform, and load (ETL) process runs as a series of MapReduce jobs on an Apache Hadoop cluster. The ETL process takes days to process a data set because some steps are computationally expensive. Then you discover that a sensor calibration step has been omitted. How should you change your ETL process to carry out sensor calibration systematically in the future?

A.Add sensor calibration data to the output of the ETL process, and document that all users need to apply sensor calibration themselves.

B.Develop an algorithm through simulation to predict variance of data output from the last MapReduce job based on calibration factors, and apply the correction to all data.

C.Modify the transformMapReduce jobs to apply sensor calibration before they do anything else.

D.Introduce a new MapReduce job to apply sensor calibration to raw data, and ensure all other MapReduce jobs are chained after this.

Question 84

Which of these statements about exporting data from BigQuery is false?

A.To export more than 1 GB of data, you need to put a wildcard in the destination filename.

B.The only supported export destination is Google Cloud Storage.

C.Data can only be exported in JSON or Avro format.

D.The only compression option available is GZIP.

Question 85

Which of these rules apply when you add preemptible workers to a Dataproc cluster (select 2 answers)?

A.Preemptible workers cannot use persistent disk.

B.Preemptible workers cannot store data.

C.If a preemptible worker is reclaimed, then a replacement worker must be added manually.

D.A Dataproc cluster cannot have only preemptible workers.

Other Version: 154Google.Professional-Data-Engineer.v2025-09-04.q126; 813Google.Professional-Data-Engineer.v2025-03-18.q108; 948Google.Professional-Data-Engineer.v2024-12-09.q327; 1476Google.Professional-Data-Engineer.v2024-02-15.q202; 2261Google.Professional-Data-Engineer.v2023-09-14.q233; 3673Google.Professional-Data-Engineer.v2022-07-07.q155; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

Latest Upload: 102OCEG.GRCP.v2025-09-11.q211; 102HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 157PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 141Adobe.AD0-E605.v2025-09-05.q50

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File