Google GCP-DE 試験概要:

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

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

問題 #1
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. Python using MapReduce
B. PigLatin using Pig
C. Java using MapReduce
D. HiveQL using Hive

問題 #2
What are two methods that can be used to denormalize tables in BigQuery?

A. 1) Use a partitioned table; 2) Join tables into one table
B. 1) Use nested repeated fields; 2) Use a partitioned table
C. 1) Join tables into one table; 2) Use nested repeated fields
D. 1) Split table into multiple tables; 2) Use a partitioned table

問題 #3
You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application's interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?

A. Create groups for your users and give those groups access to the dataset
B. Use the service account's private key to access the dataset
C. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset
D. Create a service account and grant dataset access to that accoun
E. Create a dummy user and grant dataset access to that use
F. Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request

問題 #4
What is the general recommendation when designing your row keys for a Cloud Bigtable schema?

A. Include multiple time series values within the row key
B. Keep the row keep as an 8 bit integer
C. Keep your row key reasonably short
D. Keep your row key as long as the field permits

問題 #5
Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

A. Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes
B. Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric
C. Create a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project
D. Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

解説：