[Aug 11, 2022] Google Professional-Data-Engineer Exam Dumps Files, Q201/226: You are designing a basket abandonment system for an ecommerce company. The system will send a message

Join the discussion

Question 201/226

You are designing a basket abandonment system for an ecommerce company. The system will send a
message to a user based on these rules:
No interaction by the user on the site for 1 hour

Has added more than $30 worth of products to the basket

Has not completed a transaction

You use Google Cloud Dataflow to process the data and decide if a message should be sent. How should
you design the pipeline?

A. Use a session window with a gap time duration of 60 minutes.

B. Use a global window with a time based trigger with a delay of 60 minutes.

C. Use a fixed-time window with a duration of 60 minutes.

D. Use a sliding time window with a duration of 60 minutes.

Add Comments

Other Question (226q): Q1. You work for a global shipping company. You want to train a model on 40 TB of data to pred...; Q2. Which TensorFlow function can you use to configure a categorical column if you don't know ...; Q3. You have a petabyte of analytics data and need to design a storage and processing platform...; Q4. How can you get a neural network to learn about relationships between categories in a cate...; Q5. Google Cloud Bigtable indexes a single value in each row. This value is called the _______...; Q6. What are two of the characteristics of using online prediction rather than batch predictio...; Q7. Your infrastructure includes a set of YouTube channels. You have been tasked with creating...; Q8. As your organization expands its usage of GCP, many teams have started to create their own...; Q9. Which of these are examples of a value in a sparse vector? (Select 2 answers.)...; Q10. You work for a large financial institution that is planning to use Dialogflow to create a ...; Q11. You work for a manufacturing plant that batches application log files together into a sing...; Q12. Your company is using WILDCARD tables to query data across multiple tables with similar na...; Q13. You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQ...; Q14. You're using Bigtable for a real-time application, and you have a heavy load that is a mix...; Q15. You are working on a niche product in the image recognition domain. Your team has develope...; Q16. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q17. You need to choose a database for a new project that has the following requirements: * Ful...; Q18. You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub thro...; Q19. Which of these statements about BigQuery caching is true?...; Q20. You receive data files in CSV format monthly from a third party. You need to cleanse this ...; Q21. An organization maintains a Google BigQuery dataset that contains tables with user-level d...; Q22. Which of these is NOT a way to customize the software on Dataproc cluster instances?...; Q23. Your team is working on a binary classification problem. You have trained a support vector...; Q24. What are the minimum permissions needed for a service account used with Google Dataproc?...; Q25. You are a head of BI at a large enterprise company with multiple business units that each ...; Q26. You are developing an application that uses a recommendation engine on Google Cloud. Your ...; Q27. Your company is streaming real-time sensor data from their factory floor into Bigtable and...; Q28. Your company has recently grown rapidly and now ingesting data at a significantly higher r...; Q29. Your financial services company is moving to cloud technology and wants to store 50 TB of ...; Q30. Cloud Bigtable is Google's ______ Big Data database service....; Q31. You are deploying a new storage system for your mobile application, which is a media strea...; Q32. How would you query specific partitions in a BigQuery table?...; Q33. Flowlogistic Case Study Company Overview Flowlogistic is a leading logistics and supply ch...; Q34. You are deploying a new storage system for your mobile application, which is a media strea...; Q35. You have some data, which is shown in the graphic below. The two dimensions are X and Y, a...; Q36. Which of the following are feature engineering techniques? (Select 2 answers)...; Q37. Which of the following statements about the Wide & Deep Learning model are true? (Sele...; Q38. If you want to create a machine learning model that predicts the price of a particular sto...; Q39. If a dataset contains rows with individual people and columns for year of birth, country, ...; Q40. Case Study 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and suppl...; Q41. You are designing a cloud-native historical data processing system to meet the following c...; Q42. Your company is currently setting up data pipelines for their campaign. For all the Google...; Q43. As your organization expands its usage of GCP, many teams have started to create their own...; Q44. An external customer provides you with a daily dump of data from their database. The data ...; Q45. You are analyzing the price of a company's stock. Every 5 seconds, you need to compute a m...; Q46. Case Study 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and suppl...; Q47. Flowlogistic is rolling out their real-time inventory tracking system. The tracking device...; Q48. You have Cloud Functions written in Node.js that pull messages from Cloud Pub/Sub and send...; Q49. Cloud Bigtable is Google's ______ Big Data database service....; Q50. Which of these sources can you not load data into BigQuery from?...; Q51. Your team is working on a binary classification problem. You have trained a support vector...; Q52. You decided to use Cloud Datastore to ingest vehicle telemetry data in real time. You want...; Q53. Your company produces 20,000 files every hour. Each data file is formatted as a comma sepa...; Q54. You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subs...; Q55. Which action can a Cloud Dataproc Viewer perform?...; Q56. Does Dataflow process batch data pipelines or streaming data pipelines?...; Q57. You want to process payment transactions in a point-of-sale application that will run on G...; Q58. Your company is loading comma-separated values (CSV) files into Google BigQuery. The data ...; Q59. You are deploying MariaDB SQL databases on GCE VM Instances and need to configure monitori...; Q60. You are migrating your data warehouse to BigQuery. You have migrated all of your data into...; Q61. Suppose you have a dataset of images that are each labeled as to whether or not they conta...; Q62. Your team is responsible for developing and maintaining ETLs in your company. One of your ...; Q63. Suppose you have a dataset of images that are each labeled as to whether or not they conta...; Q64. Suppose you have a table that includes a nested column called "city" inside a column calle...; Q65. Your company uses a proprietary system to send inventory data every 6 hours to a data inge...; Q66. You are developing an application that uses a recommendation engine on Google Cloud. Your ...; Q67. Cloud Bigtable is Google's ______ Big Data database service....; Q68. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q69. Your globally distributed auction application allows users to bid on items. Occasionally, ...; Q70. The YARN ResourceManager and the HDFS NameNode interfaces are available on a Cloud Datapro...; Q71. Case Study 2 - MJTelco Company Overview MJTelco is a startup that plans to build networks ...; Q72. Business owners at your company have given you a database of bank transactions. Each row c...; Q73. Which software libraries are supported by Cloud Machine Learning Engine?...; Q74. Suppose you have a dataset of images that are each labeled as to whether or not they conta...; Q75. You receive data files in CSV format monthly from a third party. You need to cleanse this ...; Q76. All Google Cloud Bigtable client requests go through a front-end server ______ they are se...; Q77. You need to move 2 PB of historical data from an on-premises storage appliance to Cloud St...; Q78. You need to choose a database to store time series CPU and memory usage for millions of co...; Q79. You designed a database for patient records as a pilot project to cover a few hundred pati...; Q80. Your startup has never implemented a formal security policy. Currently, everyone in the co...; Q81. A data scientist has created a BigQuery ML model and asks you to create an ML pipeline to ...; Q82. You need to compose visualizations for operations teams with the following requirements: W...; Q83. You used Cloud Dataprep to create a recipe on a sample of data in a BigQuery table. You wa...; Q84. You use a dataset in BigQuery for analysis. You want to provide third-party companies with...; Q85. You need to choose a database to store time series CPU and memory usage for millions of co...; Q86. Case Study 2 - MJTelco Company Overview MJTelco is a startup that plans to build networks ...; Q87. You want to archive data in Cloud Storage. Because some data is very sensitive, you want t...; Q88. You currently have a single on-premises Kafka cluster in a data center in the us-east regi...; Q89. Given the record streams MJTelco is interested in ingesting per day, they are concerned ab...; Q90. You are planning to use Google's Dataflow SDK to analyze customer data such as displayed b...; Q91. You work for a shipping company that uses handheld scanners to read shipping labels. Your ...; Q92. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q93. You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQ...; Q94. You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQ...; Q95. Which of the following is NOT one of the three main types of triggers that Dataflow suppor...; Q96. You have some data, which is shown in the graphic below. The two dimensions are X and Y, a...; Q97. How can you get a neural network to learn about relationships between categories in a cate...; Q98. Which of the following is NOT one of the three main types of triggers that Dataflow suppor...; Q99. By default, which of the following windowing behavior does Dataflow apply to unbounded dat...; Q100. Your company is currently setting up data pipelines for their campaign. For all the Google...; Q101. You work for a financial institution that lets customers register online. As new customers...; Q102. You are building a new application that you need to collect data from in a scalable way. D...; Q103. Your software uses a simple JSON format for all messages. These messages are published to ...; Q104. Which Google Cloud Platform service is an alternative to Hadoop with Hive?...; Q105. If you're running a performance test that depends upon Cloud Bigtable, all the choices exc...; Q106. Your company's on-premises Apache Hadoop servers are approaching end-of-life, and IT has d...; Q107. You are working on a sensitive project involving private user data. You have set up a proj...; Q108. Your team is responsible for developing and maintaining ETLs in your company. One of your ...; Q109. You are designing the database schema for a machine learning-based food ordering service t...; Q110. You have several Spark jobs that run on a Cloud Dataproc cluster on a schedule. Some of th...; Q111. You have enabled the free integration between Firebase Analytics and Google BigQuery. Fire...; Q112. You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub thro...; Q113. MJTelco needs you to create a schema in Google Bigtable that will allow for the historical...; Q114. You designed a database for patient records as a pilot project to cover a few hundred pati...; Q115. You have several Spark jobs that run on a Cloud Dataproc cluster on a schedule. Some of th...; Q116. Flowlogistic's CEO wants to gain rapid insight into their customer base so his sales team ...; Q117. Which of the following is NOT a valid use case to select HDD (hard disk drives) as the sto...; Q118. Which of the following statements about Legacy SQL and Standard SQL is not true?...; Q119. You are designing storage for two relational tables that are part of a 10-TB database on G...; Q120. Your financial services company is moving to cloud technology and wants to store 50 TB of ...; Q121. You are creating a model to predict housing prices. Due to budget constraints, you must ru...; Q122. You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an i...; Q123. You want to analyze hundreds of thousands of social media posts daily at the lowest cost a...; Q124. Case Study 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and suppl...; Q125. A shipping company has live package-tracking data that is sent to an Apache Kafka stream i...; Q126. You have a data pipeline that writes data to Cloud Bigtable using well-designed row keys. ...; Q127. Your company is performing data preprocessing for a learning algorithm in Google Cloud Dat...; Q128. You have an Apache Kafka cluster on-prem with topics containing web application logs. You ...; Q129. You need to create a data pipeline that copies time-series transaction data so that it can...; Q130. Which of the following statements about the Wide & Deep Learning model are true? (Sele...; Q131. Flowlogistic's management has determined that the current Apache Kafka servers cannot hand...; Q132. To give a user read permission for only the first three columns of a table, which access c...; Q133. Your company maintains a hybrid deployment with GCP, where analytics are performed on your...; Q134. You work on a regression problem in a natural language processing domain, and you have 100...; Q135. You need to choose a database to store time series CPU and memory usage for millions of co...; Q136. You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQ...; Q137. You create a new report for your large team in Google Data Studio 360. The report uses Goo...; Q138. Which of these are examples of a value in a sparse vector? (Select 2 answers.)...; Q139. Cloud Dataproc is a managed Apache Hadoop and Apache _____ service....; Q140. Data Analysts in your company have the Cloud IAM Owner role assigned to them in their proj...; Q141. In order to securely transfer web traffic data from your computer's web browser to the Clo...; Q142. Business owners at your company have given you a database of bank transactions. Each row c...; Q143. You are designing storage for two relational tables that are part of a 10-TB database on G...; Q144. You need to create a data pipeline that copies time-series transaction data so that it can...; Q145. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q146. Flowlogistic wants to use Google BigQuery as their primary analysis system, but they still...; Q147. You are deploying a new storage system for your mobile application, which is a media strea...; Q148. You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuer...; Q149. Which of the following are feature engineering techniques? (Select 2 answers)...; Q150. Case Study: 1 - Flowlogistic Company Overview Flowlogistic is a leading logistics and supp...; Q151. You are integrating one of your internal IT applications and Google BigQuery, so users can...; Q152. You want to analyze hundreds of thousands of social media posts daily at the lowest cost a...; Q153. You work for a shipping company that uses handheld scanners to read shipping labels. Your ...; Q154. Your company produces 20,000 files every hour. Each data file is formatted as a comma sepa...; Q155. You are managing a Cloud Dataproc cluster. You need to make a job run faster while minimiz...; Q156. Your company is performing data preprocessing for a learning algorithm in Google Cloud Dat...; Q157. Business owners at your company have given you a database of bank transactions. Each row c...; Q158. You have some data, which is shown in the graphic below. The two dimensions are X and Y, a...; Q159. Which of these operations can you perform from the BigQuery Web UI?...; Q160. You are designing storage for 20 TB of text files as part of deploying a data pipeline on ...; Q161. When a Cloud Bigtable node fails, ____ is lost....; Q162. Your company is running their first dynamic campaign, serving different offers by analyzin...; Q163. How would you query specific partitions in a BigQuery table?...; Q164. What are two methods that can be used to denormalize tables in BigQuery?...; Q165. You are using Google BigQuery as your data warehouse. Your users report that the following...; Q166. Your company is performing data preprocessing for a learning algorithm in Google Cloud Dat...; Q167. Your company maintains a hybrid deployment with GCP, where analytics are performed on your...; Q168. What are two of the benefits of using denormalized data structures in BigQuery?...; Q169. You are deploying a new storage system for your mobile application, which is a media strea...; Q170. Which of the following is NOT true about Dataflow pipelines?...; Q171. You operate a database that stores stock trades and an application that retrieves average ...; Q172. You are developing a software application using Google's Dataflow SDK, and want to use con...; Q173. Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to r...; Q174. What are all of the BigQuery operations that Google charges for?...; Q175. You have enabled the free integration between Firebase Analytics and Google BigQuery. Fire...; Q176. Your neural network model is taking days to train. You want to increase the training speed...; Q177. Your analytics team wants to build a simple statistical model to determine which customers...; Q178. Case Study: 3, MJTelco Case Study Company Overview MJTelco is a startup that plans to buil...; Q179. You are deploying 10,000 new Internet of Things devices to collect temperature data in you...; Q180. You work for a car manufacturer and have set up a data pipeline using Google Cloud Pub/Sub...; Q181. You need to move 2 PB of historical data from an on-premises storage appliance to Cloud St...; Q182. The Dataflow SDKs have been recently transitioned into which Apache service?...; Q183. You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQ...; Q184. You are deploying a new storage system for your mobile application, which is a media strea...; Q185. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q186. You are operating a Cloud Dataflow streaming pipeline. The pipeline aggregates events from...; Q187. Your company currently runs a large on-premises cluster using Spark, Hive, and HDFS in a c...; Q188. Your company has recently grown rapidly and now ingesting data at a significantly higher r...; Q189. Which of these are examples of a value in a sparse vector? (Select 2 answers.)...; Q190. You use BigQuery as your centralized analytics platform. New data is loaded every day, and...; Q191. Your company is performing data preprocessing for a learning algorithm in Google Cloud Dat...; Q192. You are designing a cloud-native historical data processing system to meet the following c...; Q193. Why do you need to split a machine learning dataset into training data and test data?...; Q194. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q195. You are a retailer that wants to integrate your online sales capabilities with different i...; Q196. Which of the following is not true about Dataflow pipelines?...; Q197. You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID co...; Q198. If you're running a performance test that depends upon Cloud Bigtable, all the choices exc...; Q199. You work on a regression problem in a natural language processing domain, and you have 100...; Q200. You are operating a streaming Cloud Dataflow pipeline. Your engineers have a new version o...; Q201. You are designing a basket abandonment system for an ecommerce company. The system will se...; Q202. You launched a new gaming app almost three years ago. You have been uploading log files fr...; Q203. You have spent a few days loading data from comma-separated values (CSV) files into the Go...; Q204. MJTelco's Google Cloud Dataflow pipeline is now ready to start receiving data from the 50,...; Q205. For the best possible performance, what is the recommended zone for your Compute Engine in...; Q206. What Dataflow concept determines when a Window's contents should be output based on certai...; Q207. What is the HBase Shell for Cloud Bigtable?; Q208. Which SQL keyword can be used to reduce the number of columns processed by BigQuery?...; Q209. Your company is loading comma-separated values (CSV) files into Google BigQuery. The data ...; Q210. Your company receives both batch- and stream-based event data. You want to process the dat...; Q211. You are deploying a new storage system for your mobile application, which is a media strea...; Q212. Flowlogistic's management has determined that the current Apache Kafka servers cannot hand...; Q213. Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to r...; Q214. MJTelco Case Study Company Overview MJTelco is a startup that plans to build networks in r...; Q215. Which Google Cloud Platform service is an alternative to Hadoop with Hive?...; Q216. You have enabled the free integration between Firebase Analytics and Google BigQuery. Fire...; Q217. You operate an IoT pipeline built around Apache Kafka that normally receives around 5000 m...; Q218. You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure...; Q219. Cloud Dataproc charges you only for what you really use with _____ billing....; Q220. Your organization has been collecting and analyzing data in Google BigQuery for 6 months. ...; Q221. The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of whic...; Q222. A shipping company has live package-tracking data that is sent to an Apache Kafka stream i...; Q223. An online retailer has built their current application on Google App Engine. A new initiat...; Q224. You are building a model to make clothing recommendations. You know a user's fashion prefe...; Q225. You are building a teal-lime prediction engine that streams files, which may contain Pll (...; Q226. You are migrating your data warehouse to Google Cloud and decommissioning your on-premises...

Join the discussion

Question 201/226

Add Comments

Download PDF File