Associate-Data-Practitioner試験無料問題集（108題）「Google Cloud Associate Data Practitioner 認定」

出題：1

You want to process and load a daily sales CSV file stored in Cloud Storage into BigQuery for downstream reporting. You need to quickly build a scalable data pipeline that transforms the data while providing insights into data quality issues. What should you do?

A. Load the CSV file as a table in BigQuery, and use scheduled queries to run SQL transformation scripts.

B. Create a batch pipeline in Cloud Data Fusion by using a Cloud Storage source and a BigQuery sink.

C. Create a batch pipeline in Dataflow by using the Cloud Storage CSV file to BigQuery batch template.

D. Load the CSV file as a table in BigQuery. Create a batch pipeline in Cloud Data Fusion by using a BigQuery source and sink.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You have millions of customer feedback records stored in BigQuery. You want to summarize the data by using the large language model (LLM) Gemini. You need to plan and execute this analysis using the most efficient approach. What should you do?

A. Create a BigQuery Cloud resource connection to a remote model in Vertex Al, and use Gemini to summarize the data.

B. Use a BigQuery ML model to pre-process the text data, export the results to Cloud Storage, and use the Gemini API to summarize the pre- processed data.

C. Export the raw BigQuery data to a CSV file, upload it to Cloud Storage, and use the Gemini API to summarize the data.

D. Query the BigQuery table from within a Python notebook, use the Gemini API to summarize the data within the notebook, and store the summaries in BigQuery.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

You created a customer support application that sends several forms of data to Google Cloud. Your application is sending:
1. Audio files from phone interactions with support agents that will be accessed during trainings.
2. CSV files of users' personally identifiable information (Pll) that will be analyzed with SQL.
3. A large volume of small document files that will power other applications.
You need to select the appropriate tool for each data type given the required use case, while following Google- recommended practices. Which should you choose?

A. 1. Cloud Storage
2. CloudSQL for PostgreSQL
3. Bigtable

B. 1. Filestore
2. Bigtable
3. BigQuery

C. 1. Filestore
2. Cloud SQL for PostgreSQL
3. Datastore

D. 1. Cloud Storage
2. BigQuery
3. Firestore

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Your organization needs to implement near real-time analytics for thousands of events arriving each second in Pub/Sub. The incoming messages require transformations. You need to configure a pipelinethat processes, transforms, and loads the data into BigQuery while minimizing development time. What should you do?

A. Load the data from Pub/Sub into Cloud Storage using a Cloud Storage subscription. Create a Dataproc cluster, use PySpark to perform transformations in Cloud Storage, and write the results to BigQuery.

B. Create a Cloud Data Fusion instance and configure Pub/Sub as a source. Use Data Fusion to process the Pub/Sub messages, perform transformations, and write the results to BigQuery.

C. Use Cloud Run functions to process the Pub/Sub messages, perform transformations, and write the results to BigQuery.

D. Use a Google-provided Dataflow template to process the Pub/Sub messages, perform transformations, and write the results to BigQuery.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

You manage data at an ecommerce company. You have a Dataflow pipeline that processes order data from Pub/Sub, enriches the data with product information from Bigtable, and writes the processed data to BigQuery for analysis. The pipeline runs continuously and processes thousands of orders every minute. You need to monitor the pipeline's performance and be alerted if errors occur. What should you do?

A. Use Cloud Monitoring to track key metrics. Create alerting policies in Cloud Monitoring to trigger notifications when metrics exceed thresholds or when errors occur.

B. Use BigQuery to analyze the processed data in Cloud Storage and identify anomalies or inconsistencies.
Set up scheduled alerts based when anomalies or inconsistencies occur.

C. Use the Dataflow job monitoring interface to visually inspect the pipeline graph, check for errors, and configure notifications when critical errors occur.

D. Use Cloud Logging to view the pipeline logs and check for errors. Set up alerts based on specific keywords in the logs.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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 Composer pipeline to load new files from Cloud Storage to BigQuery and schedule it to run every 10 minutes.

B. Create a Cloud Run function to load the data into BigQuery that is triggered when data arrives in Cloud Storage.

C. Use the bq command-line tool within a Cloud Shell instance to load the data into BigQuery.

D. Create a Dataproc cluster to pull CSV files from Cloud Storage, process them using Spark, and write the results to BigQuery.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Your company stores historical data in Cloud Storage. You need to ensure that all data is saved in a bucket for at least three years. What should you do?

A. Change the bucket storage class to Archive.

B. Set temporary object holds.

C. Set a bucket retention policy.

D. Enable Object Versioning.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company's products in your Looker Explores and dashboards. You need to implement a solution quickly and efficiently. What should you do?

A. Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.

B. Define a new measure that calculates the profit margin by using the existing revenue and cost fields.

C. Apply a filter to only show products with a positive profit margin.

D. Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Your company has several retail locations. Your company tracks the total number of sales made at each location each day. You want to use SQL to calculate the weekly moving average of sales by location to identify trends for each store. Which query should you use?

A.

B.

C.

D.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

Your organization has several datasets in BigQuery. The datasets need to be shared with your external partners so that they can run SQL queries without needing to copy the data to their own projects. You have organized each partner's data in its own BigQuery dataset. Each partner should be able to access only their data. You want to share the data while following Google-recommended practices. What should you do?

A. Use Analytics Hub to create a listing on a private data exchange for each partner dataset. Allow each partner to subscribe to their respective listings.

B. Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.

C. Create a Dataflow job that reads from each BigQuery dataset and pushes the data into a dedicated Pub
/Sub topic for each partner. Grant each partner the pubsub. subscriber IAM role.

D. Grant the partners the bigquery.user IAM role on the BigQuery project.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

Associate-Data-Practitioner試験無料問題集「Google Cloud Associate Data Practitioner 認定」