40%off
Professional-Data-Engineer Premium Bundle
Latest Professional-Data-Engineer Exam Premium Dumps provide by TrainingDump.com to help you Passing Professional-Data-Engineer Exam! TrainingDump.com offers the updated Professional-Data-Engineer exam dumps, the TrainingDump.com Professional-Data-Engineer exam questions has been updated to correct Answer. Get the latest TrainingDump.com Professional-Data-Engineer pdf dumps with Exam Engine here:
(433 Q&As Dumps, 40%OFF Special Discount: DumpsFiles)
Join the discussion
Question 53/173
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 measure noise level every ten seconds, and send that data to the pipeline when levels reach above 70 dBA. You need to detect the average noise level from a sensor when data is received for a duration of more than 30 minutes, but the window ends when no data has been received for 15 minutes What should you do?
Correct Answer: C
The key requirements for the windowing strategy are:
A window groups data for a specific sensor.
A window should contain data spanningat least30 minutes ("duration of more than 30 minutes" implies activity for this period).
A window for a sensorendswhen no data has been received from that sensor for 15 minutes (this is a gap).
This scenario perfectly describessession windows.
Session Windows:Session windows group elements (per key, e.g., per sensor ID) that arrive within a certain
"gap duration" of each other. A new session starts if data for a key arrives after the gap duration has passed since the last data point for that key.
In this case, if data stops arriving for a sensor for 15 minutes, the current session for that sensor closes. This matches "the window ends when no data has been received for 15 minutes." The "duration of more than 30 minutes" requirement is a condition you would applyafterthe session window closes. You'd calculate the duration of the data within the closed session window and only compute the average if that session's duration (span of event times within it) exceeds 30 minutes. Session windows themselves don't have a fixed duration; their duration is determined by data activity and the gap.
Let's analyze why other options are less suitable:
A (Hopping windows with a 15-minute window, and a thirty-minute period):Hopping windows have a fixed size and a fixed period. They create overlapping windows. This doesn't align with the dynamic nature of sessions ending based on inactivity. A 30-minute period with a 15-minute window means windows like [0:00-
0:15], [0:15-0:30], [0:30-0:45]. If activity is continuous, a 30-minute activity span would be covered, but the window closing is not based on a 15-minute gap of inactivity.
B (Tumbling windows with a 15-minute window and a fifteen-minute .withAllowedLateness operator):
Tumbling windows are fixed-size, non-overlapping windows. .withAllowedLateness deals with late data arriving for a window that has already passed its end time, not with defining the window based on activity gaps.
C (Session windows with a 30-minute gap duration):This would mean a session ends only if there's a 30- minute gap of inactivity. The requirement is a 15-minute gap.
Therefore, session windows with a 15-minute gap duration (Option D) correctly model the requirement for windows to close after 15 minutes of inactivity from a sensor. The subsequent filtering for sessions lasting more than 30 minutes is a downstream operation.
Reference:
Apache Beam Programming Guide > Windowing > Windowing functions > Session windows. "Session windowing assigns elements to windows that represent sessions of activity. A session window starts when the first element arrives for a key. If another element arrives for that key within the specified gap duration, that element is included in the existing session window. If an element arrives after the gap duration, a new session window starts for that element... Session windows are useful for data that is irregularly distributed with respect to time, such as user activity data." This directly matches the sensor data behavior: data arrives when noise is high, and a period of no data for 15 minutes should close the analysis window for that sensor.
A window groups data for a specific sensor.
A window should contain data spanningat least30 minutes ("duration of more than 30 minutes" implies activity for this period).
A window for a sensorendswhen no data has been received from that sensor for 15 minutes (this is a gap).
This scenario perfectly describessession windows.
Session Windows:Session windows group elements (per key, e.g., per sensor ID) that arrive within a certain
"gap duration" of each other. A new session starts if data for a key arrives after the gap duration has passed since the last data point for that key.
In this case, if data stops arriving for a sensor for 15 minutes, the current session for that sensor closes. This matches "the window ends when no data has been received for 15 minutes." The "duration of more than 30 minutes" requirement is a condition you would applyafterthe session window closes. You'd calculate the duration of the data within the closed session window and only compute the average if that session's duration (span of event times within it) exceeds 30 minutes. Session windows themselves don't have a fixed duration; their duration is determined by data activity and the gap.
Let's analyze why other options are less suitable:
A (Hopping windows with a 15-minute window, and a thirty-minute period):Hopping windows have a fixed size and a fixed period. They create overlapping windows. This doesn't align with the dynamic nature of sessions ending based on inactivity. A 30-minute period with a 15-minute window means windows like [0:00-
0:15], [0:15-0:30], [0:30-0:45]. If activity is continuous, a 30-minute activity span would be covered, but the window closing is not based on a 15-minute gap of inactivity.
B (Tumbling windows with a 15-minute window and a fifteen-minute .withAllowedLateness operator):
Tumbling windows are fixed-size, non-overlapping windows. .withAllowedLateness deals with late data arriving for a window that has already passed its end time, not with defining the window based on activity gaps.
C (Session windows with a 30-minute gap duration):This would mean a session ends only if there's a 30- minute gap of inactivity. The requirement is a 15-minute gap.
Therefore, session windows with a 15-minute gap duration (Option D) correctly model the requirement for windows to close after 15 minutes of inactivity from a sensor. The subsequent filtering for sessions lasting more than 30 minutes is a downstream operation.
Reference:
Apache Beam Programming Guide > Windowing > Windowing functions > Session windows. "Session windowing assigns elements to windows that represent sessions of activity. A session window starts when the first element arrives for a key. If another element arrives for that key within the specified gap duration, that element is included in the existing session window. If an element arrives after the gap duration, a new session window starts for that element... Session windows are useful for data that is irregularly distributed with respect to time, such as user activity data." This directly matches the sensor data behavior: data arrives when noise is high, and a period of no data for 15 minutes should close the analysis window for that sensor.
Add Comments
- Other Question (173q)
- Q1. Case Study 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and suppl...
- Q2. Google Cloud Bigtable indexes a single value in each row. This value is called the _______...
- Q3. You work for a manufacturing company that sources up to 750 different components, each fro...
- Q4. You need to modernize your existing on-premises data strategy. Your organization currently...
- Q5. You are analyzing the price of a company's stock. Every 5 seconds, you need to compute a m...
- Q6. You have an Oracle database deployed in a VM as part of a Virtual Private Cloud (VPC) netw...
- Q7. Your company has data assets across multiple Cloud Storage buckets and BigQuery datasets c...
- Q8. You need to create a near real-time inventory dashboard that reads the main inventory tabl...
- Q9. You have spent a few days loading data from comma-separated values (CSV) files into the Go...
- Q10. You have a table that contains millions of rows of sales data, partitioned by date Various...
- Q11. All Google Cloud Bigtable client requests go through a front-end server ______ they are se...
- Q12. You have a data stored in BigQuery. The data in the BigQuery dataset must be highly availa...
- Q13. You are designing the database schema for a machine learning-based food ordering service t...
- Q14. Your company is performing data preprocessing for a learning algorithm in Google Cloud Dat...
- Q15. You are designing storage for very large text files for a data pipeline on Google Cloud. Y...
- Q16. You have data located in BigQuery that is used to generate reports for your company. You h...
- Q17. You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQ...
- Q18. You are loading CSV files from Cloud Storage to BigQuery. The files have known data qualit...
- Q19. You are designing a real-time system for a ride hailing app that identifies areas with hig...
- Q20. You have designed an Apache Beam processing pipeline that reads from a Pub/Sub topic. The ...
- Q21. You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cl...
- Q22. Case Study: 3, MJTelco Case Study Company Overview MJTelco is a startup that plans to buil...
- Q23. Which of the following is NOT a valid use case to select HDD (hard disk drives) as the sto...
- Q24. If you want to create a machine learning model that predicts the price of a particular sto...
- Q25. Your company produces 20,000 files every hour. Each data file is formatted as a comma sepa...
- Q26. To give a user read permission for only the first three columns of a table, which access c...
- Q27. You operate a logistics company, and you want to improve event delivery reliability for ve...
- Q28. You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure...
- Q29. If a dataset contains rows with individual people and columns for year of birth, country, ...
- Q30. You want to archive data in Cloud Storage. Because some data is very sensitive, you want t...
- Q31. Which of these statements about BigQuery caching is true?...
- Q32. You are choosing a NoSQL database to handle telemetry data submitted from millions of Inte...
- Q33. You create an important report for your large team in Google Data Studio 360. The report u...
- Q34. Which of these is NOT a way to customize the software on Dataproc cluster instances?...
- Q35. The YARN ResourceManager and the HDFS NameNode interfaces are available on a Cloud Datapro...
- Q36. Case Study 2 - MJTelco Company Overview MJTelco is a startup that plans to build networks ...
- Q37. Which of the following are feature engineering techniques? (Select 2 answers)...
- Q38. You operate a database that stores stock trades and an application that retrieves average ...
- Q39. Your company is running their first dynamic campaign, serving different offers by analyzin...
- Q40. Cloud Bigtable is Google's ______ Big Data database service....
- Q41. Your company is currently setting up data pipelines for their campaign. For all the Google...
- Q42. The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of whic...
- Q43. The Development and External teams nave the project viewer Identity and Access Management ...
- Q44. Your company has data assets across multiple Cloud Storage buckets and BigQuery datasets c...
- Q45. You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuer...
- Q46. Your team has created several BigQuery curated datasets containing anonymized industry ben...
- Q47. Which of the following is NOT true about Dataflow pipelines?...
- Q48. You work for a financial institution that lets customers register online. As new customers...
- Q49. You are deploying a new storage system for your mobile application, which is a media strea...
- Q50. Case Study: 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and supp...
- Q51. You are using Cloud Bigtable to persist and serve stock market data for each of the major ...
- Q52. What are all of the BigQuery operations that Google charges for?...
- Q53. You are building a streaming Dataflow pipeline that ingests noise level data from hundreds...
- Q54. You need to store and analyze social media postings in Google BigQuery at a rate of 10,000...
- Q55. You want to analyze hundreds of thousands of social media posts daily at the lowest cost a...
- Q56. Given the record streams MJTelco is interested in ingesting per day, they are concerned ab...
- Q57. You create an important report for your large team in Google Data Studio 360. The report u...
- Q58. You are migrating your data warehouse to BigQuery. You have migrated all of your data into...
- Q59. You are administering shared BigQuery datasets that contain views used by multiple teams i...
- Q60. Your company is performing data preprocessing for a learning algorithm in Google Cloud Dat...
- Q61. Your company's customer_order table in BigOuery stores the order history for 10 million cu...
- Q62. Which of these rules apply when you add preemptible workers to a Dataproc cluster (select ...
- Q63. You are working on a sensitive project involving private user data. You have set up a proj...
- Q64. Google Cloud Bigtable indexes a single value in each row. This value is called the _______...
- Q65. When creating a new Cloud Dataproc cluster with the projects.regions.clusters.create opera...
- Q66. You need to create a new transaction table in Cloud Spanner that stores product sales data...
- Q67. You've migrated a Hadoop job from an on-prem cluster to dataproc and GCS. Your Spark job i...
- Q68. You need to modernize your existing on-premises data strategy. Your organization currently...
- Q69. Your company built a TensorFlow neural-network model with a large number of neurons and la...
- Q70. You are migrating a table to BigQuery and are deeding on the data model. Your table stores...
- Q71. Your organization has two Google Cloud projects, project A and project B. In project A, yo...
- Q72. Which of the following statements about Legacy SQL and Standard SQL is not true?...
- Q73. You have several Spark jobs that run on a Cloud Dataproc cluster on a schedule. Some of th...
- Q74. Your company has hired a new data scientist who wants to perform complicated analyses acro...
- Q75. You have a data analyst team member who needs to analyze data by using BigQuery. The data ...
- Q76. You are operating a streaming Cloud Dataflow pipeline. Your engineers have a new version o...
- Q77. You're training a model to predict housing prices based on an available dataset with real ...
- Q78. You need to look at BigQuery data from a specific table multiple times a day. The underlyi...
- Q79. The Development and External teams nave the project viewer Identity and Access Management ...
- Q80. You need to deploy additional dependencies to all of a Cloud Dataproc cluster at startup u...
- Q81. An external customer provides you with a daily dump of data from their database. The data ...
- Q82. You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters...
- Q83. You are building a model to make clothing recommendations. You know a user's fashion pis l...
- Q84. You decided to use Cloud Datastore to ingest vehicle telemetry data in real time. You want...
- Q85. Your team is building a data lake platform on Google Cloud. As a part of the data foundati...
- Q86. You are migrating your data warehouse to Google Cloud and decommissioning your on-premises...
- Q87. You created an analytics environment on Google Cloud so that your data scientist team can ...
- Q88. A live TV show asks viewers to cast votes using their mobile phones. The event generates a...
- Q89. You are collecting loT sensor data from millions of devices across the world and storing t...
- Q90. Your financial services company is moving to cloud technology and wants to store 50 TB of ...
- Q91. You are planning to use Google's Dataflow SDK to analyze customer data such as displayed b...
- Q92. Does Dataflow process batch data pipelines or streaming data pipelines?...
- Q93. You are defining the data governance strategy for a new BigQuery table with medical and fi...
- Q94. You need to store and analyze social media postings in Google BigQuery at a rate of 10,000...
- Q95. You recently deployed several data processing jobs into your Cloud Composer 2 environment....
- Q96. You are migrating a table to BigQuery and are deciding on the data model. Your table store...
- Q97. Which of the following is NOT one of the three main types of triggers that Dataflow suppor...
- Q98. You are creating a data model in BigQuery that will hold retail transaction dat a. Your tw...
- Q99. You are using Google BigQuery as your data warehouse. Your users report that the following...
- Q100. You are creating the CI'CD cycle for the code of the directed acyclic graphs (DAGs) runnin...
- Q101. You need to move 2 PB of historical data from an on-premises storage appliance to Cloud St...
- Q102. You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subs...
- Q103. You are building a data pipeline on Google Cloud. You need to prepare data using a casual ...
- Q104. Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to r...
- Q105. The Dataflow SDKs have been recently transitioned into which Apache service?...
- Q106. You are designing a stateful data processing pipeline that reads data from a Cloud Storage...
- Q107. A live TV show asks viewers to cast votes using their mobile phones. The event generates a...
- Q108. Your organization is modernizing their IT services and migrating to Google Cloud. You need...
- Q109. As your organization expands its usage of GCP, many teams have started to create their own...
- Q110. You are building a model to make clothing recommendations. You know a user's fashion prefe...
- Q111. You need to create a SQL pipeline. The pipeline runs an aggregate SQL transformation on a ...
- Q112. How can you get a neural network to learn about relationships between categories in a cate...
- Q113. Your Cloud Storage data lake has raw, processed, and historical data in different buckets....
- Q114. You are choosing a NoSQL database to handle telemetry data submitted from millions of Inte...
- Q115. You are preparing data to serve a sales demand prediction model. The training data undergo...
- Q116. If you're running a performance test that depends upon Cloud Bigtable, all the choices exc...
- Q117. You want to store your team's shared tables in a single dataset to make data easily access...
- Q118. A live TV show asks viewers to cast votes using their mobile phones. The event generates a...
- Q119. What is the general recommendation when designing your row keys for a Cloud Bigtable schem...
- Q120. You are designing a basket abandonment system for an ecommerce company. The system will se...
- Q121. You are building an ELT solution in BigQuery by using Dataform. You need to perform unique...
- Q122. When a Cloud Bigtable node fails, ____ is lost....
- Q123. An aerospace company uses a proprietary data format to store its night data. You need to c...
- Q124. Your company's data platform ingests CSV file dumps of booking and user profile data from ...
- Q125. You need to move 2 PB of historical data from an on-premises storage appliance to Cloud St...
- Q126. Case Study: 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and supp...
- Q127. You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters...
- Q128. You have several Spark jobs that run on a Cloud Dataproc cluster on a schedule. Some of th...
- Q129. You need to migrate a Redis database from an on-premises data center to a Memorystore for ...
- Q130. You have a Standard Tier Memorystore for Redis instance deployed in a production environme...
- Q131. An online brokerage company requires a high volume trade processing architecture. You need...
- Q132. You need to store and analyze social media postings in Google BigQuery at a rate of 10,000...
- Q133. You want to rebuild your batch pipeline for structured data on Google Cloud. You are using...
- Q134. Case Study: 2 - MJTelco Company Overview MJTelco is a startup that plans to build networks...
- Q135. You need to create a near real-time inventory dashboard that reads the main inventory tabl...
- Q136. Your company maintains a hybrid deployment with GCP, where analytics are performed on your...
- Q137. You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cl...
- Q138. Your neural network model is taking days to train. You want to increase the training speed...
- Q139. You want to encrypt the customer data stored in BigQuery. You need to implement for-user c...
- Q140. Government regulations in the banking industry mandate the protection of client's personal...
- Q141. Government regulations in your industry mandate that you have to maintain an auditable rec...
- Q142. You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters...
- Q143. Your analytics team wants to build a simple statistical model to determine which customers...
- Q144. You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subs...
- Q145. Which Google Cloud Platform service is an alternative to Hadoop with Hive?...
- Q146. You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure...
- Q147. When you store data in Cloud Bigtable, what is the recommended minimum amount of stored da...
- Q148. You are deploying MariaDB SQL databases on GCE VM Instances and need to configure monitori...
- Q149. You decided to use Cloud Datastore to ingest vehicle telemetry data in real time. You want...
- Q150. You are developing an Apache Beam pipeline to extract data from a Cloud SQL instance by us...
- Q151. You're using Bigtable for a real-time application, and you have a heavy load that is a mix...
- Q152. Which of these are examples of a value in a sparse vector? (Select 2 answers.)...
- Q153. You are designing the database schema for a machine learning-based food ordering service t...
- Q154. Your company receives both batch- and stream-based event dat a. You want to process the da...
- Q155. Your company's customer_order table in BigQuery stores the order history for 10 million cu...
- Q156. Case Study 2 - MJTelco Company Overview MJTelco is a startup that plans to build networks ...
- Q157. You are administering a BigQuery on-demand environment. Your business intelligence tool is...
- Q158. You operate an IoT pipeline built around Apache Kafka that normally receives around 5000 m...
- Q159. You need to look at BigQuery data from a specific table multiple times a day. The underlyi...
- Q160. You work for a large ecommerce company. You store your customer's order data in Bigtable. ...
- Q161. You have an upstream process that writes data to Cloud Storage. This data is then read by ...
- Q162. Your company is planning to migrate a large on-premises data warehouse to BigQuery. The da...
- Q163. Which of the following statements about the Wide & Deep Learning model are true? (Sele...
- Q164. Suppose you have a dataset of images that are each labeled as to whether or not they conta...
- Q165. Which Java SDK class can you use to run your Dataflow programs locally?...
- Q166. Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to r...
- Q167. You are planning to use Google's Dataflow SDK to analyze customer data such as displayed b...
- Q168. You are designing the architecture to process your data from Cloud Storage to BigQuery by ...
- Q169. You are building a report-only data warehouse where the data is streamed into BigQuery via...
- Q170. You are building a data pipeline on Google Cloud. You need to prepare data using a casual ...
- Q171. You need to move 2 PB of historical data from an on-premises storage appliance to Cloud St...
- Q172. You are creating a data model in BigQuery that will hold retail transaction data. Your two...
- Q173. You want to process payment transactions in a point-of-sale application that will run on G...
[×]
Download PDF File
Enter your email address to download Google.Professional-Data-Engineer.v2026-09-10.q173.pdf
