最新のGCP-DE問題集で試験を準備する

Google GCP-DE 試験概要:

Google GCP-DE 試験シラバストピック:

Google Data Engineer 認定 GCP-DE 試験問題：

1. You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
The user profile: What the user likes and doesn't like to eat
The user account information: Name, address, preferred meal times
The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimize the data schem a. Which Google Cloud Platform product should you use?

A) Cloud Datastore
B) BigQuery
C) Cloud SQL
D) Cloud Bigtable

2. As your organization expands its usage of GCP, many teams have started to create their own projects. Projects are further multiplied to accommodate different stages of deployments and target audiences. Each project requires unique access control configurations. The central IT team needs to have access to all projects. Furthermore, data from Cloud Storage buckets and BigQuery datasets must be shared for use in other projects in an ad hoc way. You want to simplify access control management by minimizing the number of policies. Which two steps should you take? Choose 2 answers.

A) Only use service accounts when sharing data for Cloud Storage buckets and BigQuery datasets.
B) For each Cloud Storage bucket or BigQuery dataset, decide which projects need acces
C) Find all the active members who have access to these projects, and create a Cloud IAM policy to grant access to all these users.
D) Use Cloud Deployment Manager to automate access provision.
E) Introduce resource hierarchy to leverage access control policy inheritance.
F) Create distinct groups for various teams, and specify groups in Cloud IAM policies.

3. Flowlogistic's CEO wants to gain rapid insight into their customer base so his sales team can be better informed in the field. This team is not very technical, so they've purchased a visualization tool to simplify the creation of BigQuery reports. However, they've been overwhelmed by all the data in the table, and are spending a lot of money on queries trying to find the data they need. You want to solve their problem in the most cost-effective way. What should you do?

A) Create identity and access management (IAM) roles on the appropriate columns, so only they appear in a query.
B) Create an additional table with only the necessary columns.
C) Export the data into a Google Sheet for virtualization.
D) Create a view on the table to present to the virtualization tool.

4. You are operating a Cloud Dataflow streaming pipeline. The pipeline aggregates events from a Cloud Pub/Sub subscription source, within a window, and sinks the resulting aggregation to a Cloud Storage bucket. The source has consistent throughput. You want to monitor an alert on behavior of the pipeline with Cloud Stackdriver to ensure that it is processing dat a. Which Stackdriver alerts should you create?

A) An alert based on an increase of instance/storage/used_bytes for the source and a rate of change decrease of subscription/num_undelivered_messages for the destination
B) An alert based on an increase of subscription/num_undelivered_messages for the source and a rate of change decrease of instance/storage/used_bytes for the destination
C) An alert based on a decrease of subscription/num_undelivered_messages for the source and a rate of change increase of instance/storage/used_bytes for the destination
D) An alert based on a decrease of instance/storage/used_bytes for the source and a rate of change increase of subscription/num_undelivered_messages for the destination

5. Which Cloud Dataflow / Beam feature should you use to aggregate data in an unbounded data source every hour based on the time when the data entered the pipeline?

A) An hourly watermark
B) A processing time trigger
C) The with Allowed Lateness method
D) An event time trigger

質問と回答：