Google Professional-Data-Engineer 問題集

質問 1：
You are designing a fault-tolerant architecture to store data in a regional BigOuery dataset. You need to ensure that your application is able to recover from a corruption event in your tables that occurred within the past seven days. You want to adopt managed services with the lowest RPO and most cost-effective solution. What should you do?
A. Export the data from BigQuery into a new table that excludes the corrupted data.
B. Migrate your data to multi-region BigQuery buckets.
C. Create a BigQuery table snapshot on a daily basis.
D. Access historical data by using time travel in BigQuery.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You have a table that contains millions of rows of sales data, partitioned by date Various applications and users query this data many times a minute. The query requires aggregating values by using avg. max. and sum, and does not require joining to other tables. The required aggregations are only computed over the past year of data, though you need to retain full historical data in the base tables You want to ensure that the query results always include the latest data from the tables, while also reducing computation cost, maintenance overhead, and duration. What should you do?
A. Create a materialized view to aggregate the base table data include a filter clause to specify the last one year of partitions.
B. Create a new table that aggregates the base table data include a filter clause to specify the last year of partitions. Set up a scheduled query to recreate the new table every hour.
C. Create a view to aggregate the base table data Include a filter clause to specify the last year of partitions.
D. Create a materialized view to aggregate the base table data Configure a partition expiration on the base table to retain only the last one year of partitions.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?
A. Dataproc Worker
B. Dataproc Runner
C. Dataproc Editor
D. Dataproc Viewer
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You work for an airline and you need to store weather data in a BigQuery table Weather data will be used as input to a machine learning model. The model only uses the last 30 days of weather dat a. You want to avoid storing unnecessary data and minimize costs. What should you do?
A. Create a BigQuery table where each record has an ingestion timestamp Run a scheduled query to delete all the rows with an ingestion timestamp older than 30 days.
B. Create a BigQuery table partitioned by datetime value of the weather date Set up partition expiration to 30 days.
C. Create a BigQuery table with a datetime column for the day the weather data refers to. Run a scheduled query to delete rows with a datetime value older than 30 days.
D. Create a BigQuery table partitioned by ingestion time Set up partition expiration to 30 days.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Your company maintains a hybrid deployment with GCP, where analytics are performed on your anonymized customer dat a. The data are imported to Cloud Storage from your data center through parallel uploads to a data transfer server running on GCP. Management informs you that the daily transfers take too long and have asked you to fix the problem. You want to maximize transfer speeds. Which action should you take?
A. Increase your network bandwidth from Compute Engine to Cloud Storage.
B. Increase the size of the Google Persistent Disk on your server.
C. Increase the CPU size on your server.
D. Increase your network bandwidth from your datacenter to GCP.
正解：D