Your organization has a petabyte of application logs stored as Parquet files in Cloud Storage. You need to quickly perform a one- time SQL-based analysis of the files and join them to data that already resides in BigQuery. What should you do?
A. Create a Dataproc cluster, and write a PySpark job to join the data from BigQuery to the files in Cloud Storage.
B. Use the bq load command to load the Parquet files into BigQuery, and perform SQL joins to analyze the data.
C. Launch a Cloud Data Fusion environment, use plugins to connect to BigQuery and Cloud Storage, and use the SQL join operation to analyze the data.
D. Create external tables over the files in Cloud Storage, and perform SQL joins to tables in BigQuery to analyze the data.
正解:D
質問 2:
You used BigQuery ML to build a customer purchase propensity model six months ago. You want to compare the current serving data with the historical serving data to determine whether you need to retrain the model.
What should you do?
A. Compare the two different models.
B. Evaluate the data skewness.
C. Compare the confusion matrix.
D. Evaluate data drift.
正解:D
質問 3:
Your organization's ecommerce website collects user activity logs using a Pub/Sub topic. Your organization's leadership team wants a dashboard that contains aggregated user engagement metrics. You need to create a solution that transforms the user activity logs into aggregated metrics, while ensuring that the raw data can be easily queried. What should you do?
A. Create a BigQuery subscription to the Pub/Sub topic, and load the activity logs into the table. Create a materialized view in BigQuery using SQL to transform the data for reporting
B. Create an event-driven Cloud Run function to trigger a data transformation pipeline to run. Load the transformed activity logs into a BigQuery table for reporting.
C. Create a Cloud Storage subscription to the Pub/Sub topic. Load the activity logs into a bucket using the Avro file format. Use Dataflow to transform the data, and load it into a BigQuery table for reporting.
D. Create a Dataflow subscription to the Pub/Sub topic, and transform the activity logs. Load the transformed data into a BigQuery table for reporting.
正解:D
質問 4:
You are developing a data ingestion pipeline to load small CSV files into BigQuery from Cloud Storage. You want to load these files upon arrival to minimize data latency. You want to accomplish this with minimal cost and maintenance. What should you do?
A. Create a Cloud Run function to load the data into BigQuery that is triggered when data arrives in Cloud Storage.
B. Create a Cloud Composer pipeline to load new files from Cloud Storage to BigQuery and schedule it to run every 10 minutes.
C. Create a Dataproc cluster to pull CSV files from Cloud Storage, process them using Spark, and write the results to BigQuery.
D. Use the bq command-line tool within a Cloud Shell instance to load the data into BigQuery.
正解:A
質問 5:
Your company currently uses an on-premises network file system (NFS) and is migrating data to Google Cloud. You want to be able to control how much bandwidth is used by the data migration while capturing detailed reporting on the migration status. What should you do?
A. Use a Transfer Appliance.
B. Use Cloud Storage FUSE.
C. Use Storage Transfer Service.
D. Use gcloud storage commands.
正解:C
質問 6:
Your organization has decided to move their on-premises Apache Spark-based workload to Google Cloud.
You want to be able to manage the code without needing to provision and manage your own cluster. What should you do?
A. Migrate the Spark jobs to Dataproc Serverless.
B. Migrate the Spark jobs to Dataproc on Google Kubernetes Engine.
C. Migrate the Spark jobs to Dataproc on Compute Engine.
D. Configure a Google Kubernetes Engine cluster with Spark operators, and deploy the Spark jobs.
正解:A
1102 お客様のコメント





Hatsune -
ADP初心者ですが、この問題集を読んで基礎を理解することができました。試験には受かりそうです。