Google Cloud Professional Data Engineer Free Practice Exam Questions

316 real Google Cloud Professional Data Engineer exam questions with answers and AI explanations. Google Cloud certification prep — page 19 of 32.

Question 192: You are building a streaming Dataflow pipeline that ingests noise level data from hundreds of sensors placed near construction sites across a city. The sensors…
Question 193: You are creating a data model in BigQuery that will hold retail transaction data. Your two largest tables, sales_transaction_header and sales_transaction_line,…
Question 194: You created a new version of a Dataflow streaming data ingestion pipeline that reads from Pub/Sub and writes to BigQuery. The previous version of the pipeline…
Question 195: You need to create a SQL pipeline. The pipeline runs an aggregate SQL transformation on a BigQuery table every two hours and appends the result to another exis…
Question 196: You have a BigQuery dataset named “customers”. All tables will be tagged by using a Data Catalog tag template named “gdpr”. The template contains one mandatory…
Question 197: You are designing a Dataflow pipeline for a batch processing job. You want to mitigate multiple zonal failures at job submission time. What should you do?
Question 198: You are designing a real-time system for a ride hailing app that identifies areas with high demand for rides to effectively reroute available drivers to meet t…
Question 199: Your car factory is pushing machine measurements as messages into a Pub/Sub topic in your Google Cloud project. A Dataflow streaming job, that you wrote with t…
Question 200: You want to store your team’s shared tables in a single dataset to make data easily accessible to various analysts. You want to make this data readable but unm…
Question 201: You are running a streaming pipeline with Dataflow and are using hopping windows to group the data as the data arrives. You noticed that some data is arriving…