Associate-Data-Practitioner無料問題集「Google Cloud Associate Data Practitioner」

質問 1

Your retail company wants to predict customer churn using historical purchase data stored in BigQuery. The dataset includes customer demographics, purchase history, and a label indicating whether the customer churned or not. You want to build a machine learning model to identify customers at risk of churning. You need to create and train a logistic regression model for predicting customer churn, using the customer_data table with the churned column as the target label. Which BigQuery ML query should you use?

（A）

（B）

（C）

（D）

正解：C 解答を投票する

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

質問 2

You have created a LookML model and dashboard that shows daily sales metrics for five regional managers to use. You want to ensure that the regional managers can only see sales metrics specific to their region. You need an easy-to-implement solution. What should you do?

（A）Create separate Looker instances for each regional manager. Copy the LookML model and dashboard to each instance. Provision viewer access to the corresponding manager.

（B）Create five different Explores with thesql_always_filterExplore filter applied on theregion_namedimension. Set eachregion_namevalue to the corresponding region for each manager.

（C）Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager.

（D）Create asales_regionuser attribute, and assign each manager's region as the value of their user attribute.
Add anaccess_filterExplore filter on theregion_namedimension by using thesales_regionuser attribute.

正解：D 解答を投票する

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

質問 3

Your organization uses scheduled queries to perform transformations on data stored in BigQuery. You discover that one of your scheduled queries has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

（A）Navigate to the Logs Explorer page in Cloud Logging. Use filters to find the failed job, and analyze the error details.

（B）Set up a log sink using the gcloud CLI to export BigQuery audit logs to BigQuery. Query those logs to identify the error associated with the failed job ID.

（C）Request access from your admin to the BigQuery information_schema. Query the jobs view with the failed job ID, and analyze error details.

（D）Navigate to the Scheduled queries page in the Google Cloud console. Select the failed job, and analyze the error details.

正解：D 解答を投票する

質問 4

You have a Dataproc cluster that performs batch processing on data stored in Cloud Storage. You need to schedule a daily Spark job to generate a report that will be emailed to stakeholders. You need a fully-managed solution that is easy to implement and minimizes complexity. What should you do?

（A）Use Cloud Scheduler to trigger the Spark job. and use Cloud Run functions to email the report.

（B）Use Cloud Composer to orchestrate the Spark job and email the report.

（C）Use Dataproc workflow templates to define and schedule the Spark job, and to email the report.

（D）Use Cloud Run functions to trigger the Spark job and email the report.

正解：C 解答を投票する

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

質問 5

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 Dataproc cluster to pull CSV files from Cloud Storage, process them using Spark, and write the results to BigQuery.

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

（C）Create a Cloud Composer pipeline to load new files from Cloud Storage to BigQuery and schedule it to run every 10 minutes.

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

正解：B 解答を投票する

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

質問 6

You recently inherited a task for managing Dataflow streaming pipelines in your organization and noticed that proper access had not been provisioned to you. You need to request a Google-provided IAM role so you can restart the pipelines. You need to follow the principle of least privilege. What should you do?

（A）Request the Dataflow Viewer role.

（B）Request the Dataflow Worker role.

（C）Request the Dataflow Developer role.

（D）Request the Dataflow Admin role.

正解：C 解答を投票する

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

質問 7

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）Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google Cloud.

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

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

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

正解：D 解答を投票する

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

質問 8

Your team needs to analyze large datasets stored in BigQuery to identify trends in user behavior. The analysis will involve complex statistical calculations, Python packages, and visualizations. You need to recommend a managed collaborative environment to develop and share the analysis. What should you recommend?

（A）Connect Google Sheets to BigQuery by using Connected Sheets. Share the Google Sheet with your team. Analyze the data and generate visualizations in Gooqle Sheets.

（B）Create a Colab Enterprise notebook and connect the notebook to BigQuery. Share the notebook with your team. Analyze the data and generate visualizations in Colab Enterprise.

（C）Create a Looker Studio dashboard and connect the dashboard to BigQuery. Share the dashboard with your team. Analyze the data and generate visualizations in Looker Studio.

（D）Create a statistical model by using BigQuery ML. Share the query with your team. Analyze the data and generate visualizations in Looker Studio.

正解：B 解答を投票する

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

質問 9

You manage a BigQuery table that is used for critical end-of-month reports. The table is updated weekly with new sales data. You want to prevent data loss and reporting issues if the table is accidentally deleted. What should you do?

（A）Schedule the creation of a new snapshot of the table once a week. On deletion, re-create the deleted table using the snapshot and time travel data.

（B）Configure the time travel duration on the table to be exactly seven days. On deletion, re-create the deleted table solely from the time travel data.

（C）Create a view of the table. On deletion, re-create the deleted table from the view and time travel data.

（D）Create a clone of the table. On deletion, re-create the deleted table by copying the content of the clone.

正解：A 解答を投票する

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

質問 10

You are designing a BigQuery data warehouse with a team of experienced SQL developers. You need to recommend a cost-effective, fully-managed, serverless solution to build ELT processes with SQL pipelines.
Your solution must include source code control, environment parameterization, and data quality checks. What should you do?

（A）Use Dataproc to run MapReduce jobs for distributed data processing.

（B）Use Dataform to build, orchestrate, and monitor the pipelines.

（C）Use Cloud Data Fusion to visually design and manage the pipelines.

（D）Use Cloud Composer to orchestrate and run data workflows.

正解：B 解答を投票する

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

Associate-Data-Practitioner 無料問題集「Google Cloud Associate Data Practitioner」

弊社を連絡する

関連リンク

トップ試験