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

出題：1

You need to design a data pipeline that ingests data from CSV, Avro, and Parquet files into Cloud Storage.
The data includes raw user input. You need to remove all malicious SQL injections before storing the data in BigQuery. Which data manipulation methodology should you choose?

A. EL

B. ELT

C. ETL

D. ETLT

正解：C 解答を投票する

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

出題：2

You work for an online retail company. Your company collects customer purchase data in CSV files and pushes them to Cloud Storage every 10 minutes. The data needs to be transformed and loaded intoBigQuery for analysis. The transformation involves cleaning the data, removing duplicates, and enriching it with product information from a separate table in BigQuery. You need to implement a low-overhead solution that initiates data processing as soon as the files are loaded into Cloud Storage. What should you do?

A. Use Dataflow to implement a streaming pipeline using anOBJECT_FINALIZEnotification from Pub
/Sub to read the data from Cloud Storage, perform the transformations, and write the data to BigQuery.

B. Schedule a direct acyclic graph (DAG) in Cloud Composer to run hourly to batch load the data from Cloud Storage to BigQuery, and process the data in BigQuery using SQL.

C. Create a Cloud Data Fusion job to process and load the data from Cloud Storage into BigQuery. Create anOBJECT_FINALIZE notification in Pub/Sub, and trigger a Cloud Run function to start the Cloud Data Fusion job as soon as new files are loaded.

D. Use Cloud Composer sensors to detect files loading in Cloud Storage. Create a Dataproc cluster, and use a Composer task to execute a job on the cluster to process and load the data into BigQuery.

正解：A 解答を投票する

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

出題：3

Your company has an on-premises file server with 5 TB of data that needs to be migrated to Google Cloud.
The network operations team has mandated that you can only use up to 250 Mbps of the total available bandwidth for the migration. You need to perform an online migration to Cloud Storage. What should you do?

A. Use the gcloud storage cp command to copy all files from on-premises to Cloud Storage using the --no- clobber option.

B. Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google Cloud.

C. Use Storage Transfer Service to configure an agent-based transfer. Set the appropriate bandwidth limit for the agent pool.

D. Use the gcloud storage cp command to copy all files from on-premises to Cloud Storage using the -- daisy-chain option.

正解：C 解答を投票する

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

出題：4

Your organization consists of two hundred employees on five different teams. The leadership team is concerned that any employee can move or delete all Looker dashboards saved in the Shared folder. You need to create an easy-to-manage solution that allows the five different teams in your organization to view content in the Shared folder, but only be able to move or delete their team-specific dashboard. What should you do?

A. 1. Change the access level of the Shared folder to View for the All Users group. 2. Create five subfolders inside the Shared folder. Grant each team member the Manage Access, Edit access level to their corresponding subfolder.

B. 1. Move all team-specific content into the dashboard owner s personal folder. 2. Change the access level of the Shared folder to View for the All Users group. 3. Instruct each user to create content for their team in the user's personal folder.

C. 1. Change the access level of the Shared folder to View for the All Users group. 2. Create Looker groups representing each of the five different teams, and add users to their corresponding group. 3.
Create five subfolders inside the Shared folder. Grant each group the Manage Access, Edit access level to their corresponding subfolder.

D. 1. Create Looker groups representing each of the five different teams, and add users to their corresponding group. 2. Create five subfolders inside the Shared folder. Grant each group the View access level to their corresponding subfolder.

正解：C 解答を投票する

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

出題：5

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 メンバーにのみ表示されます)

出題：6

You manage a Cloud Storage bucket that stores temporary files created during data processing. These temporary files are only needed for seven days, after which they are no longer needed. To reduce storage costs and keep your bucket organized, you want to automatically delete these files once they are older than seven days. What should you do?

A. Develop a batch process using Dataflow that runs weekly and deletes files based on their age.

B. Create a Cloud Run function that runs daily and deletes files older than seven days.

C. Set up a Cloud Scheduler job that invokes a weekly Cloud Run function to delete files older than seven days.

D. Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days.

正解：D 解答を投票する

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

出題：7

You are storing data in Cloud Storage for a machine learning project. The data is frequently accessed during the model training phase, minimally accessed after 30 days, and unlikely to be accessed after 90 days. You need to choose the appropriate storage class for the different stages of the project to minimize cost. What should you do?

A. Store the data in Nearline storage during the model training phase. Transition the data to Archive storage 30 days after model deployment, and to Coldline storage 90 days after model deployment.

B. Store the data in Standard storage during the model training phase. Transition the data to Durable Reduced Availability (DRA) storage 30 days after model deployment, and to Coldline storage 90 days after model deployment.

C. Store the data in Standard storage during the model training phase. Transition the data to Nearline storage 30 days after model deployment, and to Coldline storage 90 days after model deployment.

D. Store the data in Nearline storage during the model training phase. Transition the data to Coldline storage 30 days after model deployment, and to Archive storage 90 days after model deployment.

正解：C 解答を投票する

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

出題：8

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. Configure a Google Kubernetes Engine cluster with Spark operators, and deploy the Spark jobs.

B. Migrate the Spark jobs to Dataproc on Google Kubernetes Engine.

C. Migrate the Spark jobs to Dataproc Serverless.

D. Migrate the Spark jobs to Dataproc on Compute Engine.

正解：C 解答を投票する

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

出題：9

Your organization uses Dataflow pipelines to process real-time financial transactions. You discover that one of your Dataflow jobs has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

A. Use the gcloud CLI tool to retrieve job metrics and logs, and analyze them for errors and performance bottlenecks.

B. Navigate to the Dataflow Jobs page in the Google Cloud console. Use the job logs and worker logs to identify the error.

C. Set up a Cloud Monitoring dashboard to track key Dataflow metrics, such as data throughput, error rates, and resource utilization.

D. Create a custom script to periodically poll the Dataflow API for job status updates, and send email alerts if any errors are identified.

正解：B 解答を投票する

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

出題：10

You are designing a pipeline to process data files that arrive in Cloud Storage by 3:00 am each day. Data processing is performed in stages, where the output of one stage becomes the input of the next. Each stage takes a long time to run. Occasionally a stage fails, and you have to address the problem. You need to ensure that the final output is generated as quickly as possible. What should you do?

A. Design a Spark program that runs under Dataproc. Code the program to wait for user input when an error is detected. Rerun the last action after correcting any stage output data errors.

B. Design the processing as a directed acyclic graph (DAG) in Cloud Composer. Clear the state of the failed task after correcting any stage output data errors.

C. Design the pipeline as a set of PTransforms in Dataflow. Restart the pipeline after correcting any stage output data errors.

D. Design the workflow as a Cloud Workflow instance. Code the workflow to jump to a given stage based on an input parameter. Rerun the workflow after correcting any stage output data errors.

正解：B 解答を投票する

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

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