[Sep 10, 2026] Google Professional-Data-Engineer Exam Dumps Files, Q68/173: You need to modernize your existing on-premises data strategy. Your organization currently uses:

Join the discussion

Question 68/173

You need to modernize your existing on-premises data strategy. Your organization currently uses:
- Apache Hadoop clusters for processing multiple large data sets,
including on-premises Hadoop Distributed File System (HDFS) for data
replication.
- Apache Airflow to orchestrate hundreds of ETL pipelines with
thousands of job steps.
You need to set up a new architecture in Google Cloud that can handle your Hadoop workloads and requires minimal changes to your existing orchestration processes. What should you do?

A. Use Dataproc to migrate Hadoop clusters to Google Cloud, and Cloud Storage to handle any HDFS use cases. Convert your ETL pipelines to Dataflow.

B. Use Bigtable for your large workloads, with connections to Cloud Storage to handle any HDFS use cases. Orchestrate your pipelines with Cloud Composer.

C. Use Dataproc to migrate your Hadoop clusters to Google Cloud, and Cloud Storage to handle any HDFS use cases. Use Cloud Data Fusion to visually design and deploy your ETL pipelines.

D. Use Dataproc to migrate Hadoop clusters to Google Cloud, and Cloud Storage to handle any HDFS use cases. Orchestrate your pipelines with Cloud Composer.

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...

Join the discussion

Question 68/173

Add Comments

Download PDF File