Google Data Engineer 認定 GCP-DE 試験問題:
1. You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table?
A) Set the BigQuery dataset to be regiona
B) In the event of an emergency, use a point-in-time snapshot to recover the data.
C) In the event of an emergency, use a point-in-time snapshot to recover the data.
D) Set the BigQuery dataset to be multi-regional
E) Create a scheduled query to make copies of the data to tables suffixed with the time of the backu
F) In the event of an emergency, use the backup copy of the table.
G) In the event of an emergency, use the backup copy of the table.
H) Set the BigQuery dataset to be multi-regional
I) Create a scheduled query to make copies of the data to tables suffixed with the time of the backup
J) Set the BigQuery dataset to be regiona
2. Which of these rules apply when you add preemptible workers to a Dataproc cluster (select 2 answers)?
A) Preemptible workers cannot store data.
B) If a preemptible worker is reclaimed, then a replacement worker must be added manually.
C) A Dataproc cluster cannot have only preemptible workers.
D) Preemptible workers cannot use persistent disk.
3. What are the minimum permissions needed for a service account used with Google Dataproc?
A) Execute to Google Cloud Storage; write to Google Cloud Logging
B) Write to Google Cloud Storage; read to Google Cloud Logging
C) Read and write to Google Cloud Storage; write to Google Cloud Logging
D) Execute to Google Cloud Storage; execute to Google Cloud Logging
4. You are building a new application that you need to collect data from in a scalable way. Data arrives continuously from the application throughout the day, and you expect to generate approximately 150 GB of JSON data per day by the end of the year. Your requirements are: Decoupling producer from consumer Space and cost-efficient storage of the raw ingested data, which is to be stored indefinitely Near real-time SQL query Maintain at least 2 years of historical data, which will be queried with SQ Which pipeline should you use to meet these requirements?
A) Write a tool to poll the API and write data to Cloud Storage as gzipped JSON files.
B) Create an application that provides an AP
C) Create an application that writes to a Cloud SQL database to store the dat
D) Create an application that publishes events to Cloud Pub/Sub, and create a Cloud Dataflow pipeline that transforms the JSON event payloads to Avro, writing the data to Cloud Storage and BigQuery.
E) Create an application that publishes events to Cloud Pub/Sub, and create Spark jobs on Cloud Dataproc to convert the JSON data to Avro format, stored on HDFS on Persistent Disk.
F) Set up periodic exports of the database to write to Cloud Storage and load into BigQuery.
5. You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
The user profile: What the user likes and doesn't like to eat
The user account information: Name, address, preferred meal times
The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimize the data schem a. Which Google Cloud Platform product should you use?
A) Cloud Bigtable
B) BigQuery
C) Cloud Datastore
D) Cloud SQL
質問と回答：
| 質問 # 1 正解： C | 質問 # 2 正解： A、C | 質問 # 3 正解： C | 質問 # 4 正解： B | 質問 # 5 正解： B |
7 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
