最新なGoogle Associate-Data-Practitioner問題集（108題）、真実試験の問題を全部にカバー！

質問 1：
Your organization has several datasets in their data warehouse in BigQuery. Several analyst teams in different departments use the datasets to run queries. Your organization is concerned about the variability of their monthly BigQuery costs. You need to identify a solution that creates a fixed budget for costs associated with the queries run by each department. What should you do?
A. Assign each analyst to a separate project associated with their department. Create a single reservation by using BigQuery editions. Assign all projects to the reservation.
B. Create a single reservation by using BigQuery editions. Assign all analysts to the reservation.
C. Assign each analyst to a separate project associated with their department. Create a single reservation for each department by using BigQuery editions. Create assignments for each project in the appropriate reservation.
D. Create a custom quota for each analyst in BigQuery.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
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.admin
B. roles/bigquery.connectionUser and roles/bigquery.dataViewer
C. roles/bigquery.jobUser and roles/bigquery.dataOwner
D. roles/bigquery.user and roles/bigquery.filteredDataViewer
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
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. 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.
B. Use Database Migration Service to transfer the data to Cloud SQL for MySQL, and configure the on premises MySQL database as the source.
C. Use a Google-provided Dataflow template to replicate the MySQL database in BigQuery.
D. 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
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
You are a Looker analyst. You need to add a new field to your Looker report that generates SQL that will run against your company's database. You do not have the Develop permission. What should you do?
A. Create a calculated field using the Add a field option in Looker Studio, and add it to your report.
B. Create a custom field from the field picker in Looker, and add it to your report.
C. Create a table calculation from the field picker in Looker, and add it to your report.
D. Create a new field in the LookML layer, refresh your report, and select your new field from the field picker.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
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 Storage Transfer Service to configure an agent-based transfer. Set the appropriate bandwidth limit for the agent pool.
B. Use the gcloud storage cp command to copy all files from on-premises to Cloud Storage using the -- daisy-chain option.
C. Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google Cloud.
D. Use the gcloud storage cp command to copy all files from on-premises to Cloud Storage using the --no- clobber option.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
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 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.
C. 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.
D. Design the pipeline as a set of PTransforms in Dataflow. Restart the pipeline after correcting any stage output data errors.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 7：
You are a database administrator managing sales transaction data by region stored in a BigQuery table. You need to ensure that each sales representative can only see the transactions in their region. What should you do?
A. Create a data masking rule.
B. Grant the appropriate 1AM permissions on the dataset.
C. Add a policy tag in BigQuery.
D. Create a row-level access policy.
正解：D

質問 8：
You are working on a project that requires analyzing daily social media data. You have 100 GB of JSON formatted data stored in Cloud Storage that keeps growing.
You need to transform and load this data into BigQuery for analysis. You want to follow the Google- recommended approach. What should you do?
A. Use Cloud Run functions to transform and load the data into BigQuery.
B. Use Dataflow to transform the data and write the transformed data to BigQuery.
C. Manually download the data from Cloud Storage. Use a Python script to transform and upload the data into BigQuery.
D. Use Cloud Data Fusion to transfer the data into BigQuery raw tables, and use SQL to transform it.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)