最新的Google Cloud Platform認證 Associate-Data-Practitioner考試題庫

問題1

You are designing an application that will interact with several BigQuery datasets. You need to grant the application's service account permissions that allow it to query and update tables within the datasets, and list all datasets in a project within your application. You want to follow the principle of least privilege. Which pre- defined IAM role(s) should you apply to the service account?

A. roles/bigquery.user and roles/bigquery.filteredDataViewer

B. roles/bigquery.connectionUser and roles/bigquery.dataViewer

C. roles/bigquery.admin

D. roles/bigquery.jobUser and roles/bigquery.dataOwner

正確答案: D

說明：（僅 VCESoft 成員可見）

問題2

Your organization has decided to migrate their existing enterprise data warehouse to BigQuery. The existing data pipeline tools already support connectors to BigQuery. You need to identify a data migration approach that optimizes migration speed. What should you do?

A. Create a temporary file system to facilitate data transfer from the existing environment to Cloud Storage. Use Storage Transfer Service to migrate the data into BigQuery.

B. Use the BigQuery Data Transfer Service to recreate the data pipeline and migrate the data into BigQuery.

C. Use the existing data pipeline tool's BigQuery connector to reconfigure the data mapping.

D. Use the Cloud Data Fusion web interface to build data pipelines. Create a directed acyclic graph (DAG) that facilitates pipeline orchestration.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題3

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. Create a custom script to periodically poll the Dataflow API for job status updates, and send email alerts if any errors are identified.

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

正確答案: B

說明：（僅 VCESoft 成員可見）

問題4

Your company is migrating their batch transformation pipelines to Google Cloud. You need to choose a solution that supports programmatic transformations using only SQL. You also want the technology to support Git integration for version control of your pipelines. What should you do?

A. Use Dataform workflows.

B. Use Dataflow pipelines.

C. Use Cloud Data Fusion pipelines.

D. Use Cloud Composer operators.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題5

You work for a home insurance company. You are frequently asked to create and save risk reports with charts for specific areas using a publicly available storm event dataset. You want to be able to quickly create and re- run risk reports when new data becomes available. What should you do?

A. Reference and query the storm event dataset using SQL in a Colab Enterprise notebook. Display the table results and document with Markdown, and use Matplotlib to create charts.

B. Reference and query the storm event dataset using SQL in BigQuery Studio. Export the results to Google Sheets, and use cell data in the worksheets to create charts.

C. Export the storm event dataset as a CSV file. Import the file to Google Sheets, and use cell data in the worksheets to create charts.

D. Copy the storm event dataset into your BigQuery project. Use BigQuery Studio to query and visualize the data in Looker Studio.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題6

You have an existing weekly Storage Transfer Service transfer job from Amazon S3 to a Nearline Cloud Storage bucket in Google Cloud. Each week, the job moves a large number of relatively small files. As the number of files to be transferred each week has grown over time, you are at risk of no longer completing the transfer in the allocated time frame. You need to decrease the total transfer time by replacing the process.
Your solution should minimize costs where possible. What should you do?

A. Create an agent-based transfer job that utilizes multiple transfer agents on Compute Engine instances.

B. Create a batch Dataflow job that is scheduled weekly to migrate the data from Amazon S3 to Cloud Storage.

C. Create parallel transfer jobs using include and exclude prefixes.

D. Create a transfer job using the Google Cloud CLI, and specify the Standard storage class with the - custom-storage-class flag.

正確答案: C

說明：（僅 VCESoft 成員可見）

最新的Google Cloud Associate Data Practitioner - Associate-Data-Practitioner免費考試真題

最新更新

站內鏈接

聯系我們