最新のGCP-DE問題集で試験を準備する

Google GCP-DE 試験概要:

Google GCP-DE 試験シラバストピック:

Google Data Engineer 認定 GCP-DE 試験問題：

1. Your company is loading comma-separated values (CSV) files into Google BigQuery. The data is fully imported successfully; however, the imported data is not matching byte-to-byte to the source file. What is the most likely cause of this problem?

A) The CSV data has not gone through an ETL phase before loading into BigQuery.
B) The CSV data has invalid rows that were skipped on import.
C) The CSV data loaded in BigQuery is not using BigQuery's default encoding.
D) The CSV data loaded in BigQuery is not flagged as CSV.

2. You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on nonkey columns. What should you do?

A) Use Cloud Spanner for storag
B) Use Cloud SQL for storag
C) Use Cloud Dataflow to transform data to support query patterns.
D) Use Cloud SQL for storag
E) Add secondary indexes to support query patterns.
F) Use Cloud Dataflow to transform data to support query patterns.
G) Add secondary indexes to support query patterns.
H) Use Cloud Spanner for storag

3. You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cluster. The pipeline will require some checkpointing and splitting pipelines. Which method should you use to write the pipelines?

A) PigLatin using Pig
B) HiveQL using Hive
C) Java using MapReduce
D) Python using MapReduce

4. You work for an economic consulting firm that helps companies identify economic trends as they happen. As part of your analysis, you use Google BigQuery to correlate customer data with the average prices of the 100 most common goods sold, including bread, gasoline, milk, and others. The average prices of these goods are updated every 30 minutes. You want to make sure this data stays up to date so you can combine it with other data in BigQuery as cheaply as possible. What should you do?

A) Store and update the data in a regional Google Cloud Storage bucket and create a federated data source in BigQuery
B) Store the data in Google Cloud Datastor
C) Store the data in a file in a regional Google Cloud Storage bucke
D) Use Cloud Dataflow to query BigQuery and combine the data programmatically with the data stored in Google Cloud Storage.
E) Use Google Cloud Dataflow to query BigQuery and combine the data programmatically with the data stored in Cloud Datastore
F) Load the data every 30 minutes into a new partitioned table in BigQuery.

5. What are all of the BigQuery operations that Google charges for?

A) Queries and streaming inserts
B) Storage, queries, and loading data from a file
C) Storage, queries, and exporting data
D) Storage, queries, and streaming inserts

質問と回答：