ADP試験無料問題集（66題）「Google Associate Data Practitioner 認定」

出題：1

Your organization's website uses an on-premises MySQL as a backend database. You need to migrate the on-premises MySQL database to Google Cloud while maintaining MySQL features. You want to minimize administrative overhead and downtime. What should you do?

A. Install MySQL on a Compute Engine virtual machine. Export the database files using the mysqldump command. Upload the files to Cloud Storage, and import them into the MySQL instance on Compute Engine.

B. Use a Google-provided Dataflow template to replicate the MySQL database in BigQuery.

C. Use Database Migration Service to transfer the data to Cloud SQL for MySQL, and configure the on premises MySQL database as the source.

D. Export the database tables to CSV files, and upload the files to Cloud Storage. Convert the MySQL schema to a Spanner schema, create a JSON manifest file, and run a Google-provided Dataflow template to load the data into Spanner.

正解：C 解答を投票する

出題：2

Your company uses Looker to generate and share reports with various stakeholders. You have a complex dashboard with several visualizations that needs to be delivered to specific stakeholders on a recurring basis, with customized filters applied for each recipient. You need an efficient and scalable solution to automate the delivery of this customized dashboard. You want to follow the Google- recommended approach. What should you do?

A. Embed the Looker dashboard in a custom web application, and use the application's scheduling features to send the report with personalized filters.

B. Create a script using the Looker Python SDK, and configure user attribute filter values. Generate a new scheduled plan for each stakeholder.

C. Create a separate LookML model for each stakeholder with predefined filters, and schedule the dashboards using the Looker Scheduler.

D. Use the Looker Scheduler with a user attribute filter on the dashboard, and send the dashboard with personalized filters to each stakeholder based on their attributes.

正解：D 解答を投票する

出題：3

Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove data that is older than one year to reduce your organization's storage costs. You want to use the most efficient approach while minimizing cost. What should you do?

A. Require users to specify a partition filter using the alter table statement in SQL.

B. Create a scheduled query that periodically runs an update statement in SQL that sets the "deleted" column to "yes" for data that is more than one year old. Create a view that filters out rows that have been marked deleted.

C. Create a view that filters out rows that are older than one year.

D. Set the table partition expiration period to one year using the ALTER TABLE statement in SQL.

正解：D 解答を投票する

出題：4

Your data science team needs to collaboratively analyze a 25 TB BigQuery dataset to support the development of a machine learning model. You want to use Colab Enterprise notebooks while ensuring efficient data access and minimizing cost. What should you do?

A. Use BigQuery magic commands within a Colab Enterprise notebook to query and analyze the data.

B. Copy the BigQuery dataset to the local storage of the Colab Enterprise runtime, and analyze the data using Pandas.

C. Export the BigQuery dataset to Google Drive. Load the dataset into the Colab Enterprise notebook using Pandas.

D. Create a Dataproc cluster connected to a Colab Enterprise notebook, and use Spark to process the data in BigQuery.

正解：A 解答を投票する

出題：5

Your retail company wants to analyze customer reviews to understand sentiment and identify areas for improvement. Your company has a large dataset of customer feedback text stored in BigQuery that includes diverse language patterns, emojis, and slang. You want to build a solution to classify customer sentiment from the feedback text. What should you do?

A. Preprocess the text data in BigQuery using SQL functions. Export the processed data to AutoML Natural Language for model training and deployment.

B. Develop a custom sentiment analysis model using TensorFlow. Deploy it on a Compute Engine instance.

C. Export the raw data from BigQuery. Use AutoML Natural Language to train a custom sentiment analysis model.

D. Use Dataproc to create a Spark cluster, perform text preprocessing using Spark NLP, and build a sentiment analysis model with Spark MLlib.

正解：C 解答を投票する

出題：6

You have a Dataflow pipeline that processes website traffic logs stored in Cloud Storage and writes the processed data to BigQuery. You noticed that the pipeline is failing intermittently. You need to troubleshoot the issue. What should you do?

A. Use the Dataflow job monitoring interface to check the pipeline's status every hour. Use Cloud Profiler to analyze the pipeline's metrics, such as CPU utilization and memory usage.

B. Use Cloud Logging to create a chart displaying the pipeline's error logs. Use Metrics Explorer to validate the findings from the chart.

C. Use Cloud Logging to view error messages in the pipeline's logs. Use Cloud Monitoring to analyze the pipeline's metrics, such as CPU utilization and memory usage.

D. Use Cloud Logging to identify error groups in the pipeline's logs. Use Cloud Monitoring to create a dashboard that tracks the number of errors in each group.

正解：C 解答を投票する

出題：7

You need to create a data pipeline that streams event information from applications in multiple Google Cloud regions into BigQuery for near real-time analysis. The data requires transformation before loading. You want to create the pipeline using a visual interface. What should you do?

A. Push event information to a Pub/Sub topic. Create a Cloud Run function to subscribe to the Pub/Sub topic, apply transformations, and insert the data into BigQuery.

B. Push event information to a Pub/Sub topic. Create a Dataflow job using the Dataflow job builder.

C. Push event information to Cloud Storage, and create an external table in BigQuery. Create a BigQuery scheduled job that executes once each day to apply transformations.

D. Push event information to a Pub/Sub topic. Create a BigQuery subscription in Pub/Sub.

正解：B 解答を投票する

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