Free Google Professional-Data-Engineer Exam Questions

Question 1

A shipping company has live package-tracking data that is sent to an Apache Kafka stream in real time. This is then loaded into BigQuery. Analysts in your company want to query the tracking data in BigQuery to analyze geospatial trends in the lifecycle of a package. The table was originally created with ingest-date partitioning. Over time, the query processing time has increased. You need to implement a change that would improve query performance in BigQuery. What should you do?

A : plement clustering in BigQuery on the ingest date column.

B : plement clustering in BigQuery on the package-tracking ID column.

C : er older data onto Cloud Storage files, and leverage extended tables.

D : -create the table using data partitioning on the package delivery date.

Answer: A

Question 2

You have a BigQuery dataset named "customers". All tables will be tagged by using a Data Catalog tag

template named "gdpr". The template contains one mandatory field, "has sensitive data~. with a boolean value.

All employees must be able to do a simple search and find tables in the dataset that have either true or false in

the "has sensitive data" field. However, only the Human Resources (HR) group should be able to see the data

inside the tables for which "hass-ensitive-data" is true. You give the all employees group the

bigquery.metadataViewer and bigquery.connectionUser roles on the dataset. You want to minimize

configuration overhead. What should you do next?

A : Create the "gdpr" tag template with private visibility. Assign the bigquery -dataViewer role to the HRgroup on the tables that contain sensitive data.

B : Create the ~gdpr" tag template with private visibility. Assign the datacatalog. tagTemplateViewer roleon this tag to the all employeesgroup, and assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.

C : Create the "gdpr" tag template with public visibility. Assign the bigquery. dataViewer role to the HRgroup on the tables that containsensitive data.

D : Create the "gdpr" tag template with public visibility. Assign the datacatalog. tagTemplateViewer role onthis tag to the all employees.group, and assign the bijquery.dataViewer role to the HR group on the tables that contain sensitive data.

Answer: D

Question 3

You are developing an Apache Beam pipeline to extract data from a Cloud SQL instance by using JdbclO.

You have two projects running in Google Cloud. The pipeline will be deployed and executed on Dataflow in

Project A. The Cloud SQL instance is running jn Project B and does not have a public IP address. After

deploying the pipeline, you noticed that the pipeline failed to extract data from the Cloud SQL instance due to

connection failure. You verified that VPC Service Controls and shared VPC are not in use in these projects.

You want to resolve this error while ensuring that the data does not go through the public internet. What

should you do?

A : Set up VPC Network Peering between Project A and Project B. Add a firewall rule to allow the peeredsubnet range to access all instances on the network.

B : Turn off the external IP addresses on the Dataflow worker. Enable Cloud NAT in Project A.

C : Set up VPC Network Peering between Project A and Project B. Create a Compute Engine instance without external IP address in Project B on the peered subnet to serve as a proxy server to the Cloud SQL database.

D : Add the external IP addresses of the Dataflow worker as authorized networks in the Cloud SOL instance.

Answer: C

Question 4

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 : Cloud Deployment Manager to automate access provision.

B : troduce resource hierarchy to leverage access control policy inheritance.

C : eate distinct groups for various teams, and specify groups in Cloud IAM policies.

D : ly use service accounts when sharing data for Cloud Storage buckets and BigQuery datasets.

E : r each Cloud Storage bucket or BigQuery dataset, decide which projects need access. Find all the active members who have access to these projects, and create a Cloud IAM policy to grant access to all these users.

Answer: A,C

Question 5

You stream order data by using a Dataflow pipeline, and write the aggregated result to Memorystore. You

provisioned a Memorystore for Redis instance with Basic Tier. 4 GB capacity, which is used by 40 clients for

read-only access. You are expecting the number of read-only clients to increase significantly to a few hundred

and you need to be able to support the demand. You want to ensure that read and write access availability is

not impacted, and any changes you make can be deployed quickly. What should you do?

A : Create multiple new Memorystore for Redis instances with Basic Tier (4 GB capacity) Modify theDataflow pipeline and new clients to use all instances

B : Create a new Memorystore for Redis instance with Standard Tier Set capacity to 4 GB and read replicato No read replicas (high availability only). Delete the old instance.

C : Create a new Memorystore for Memcached instance Set a minimum of three nodes, and memory pernode to 4 GB. Modify the Dataflow pipeline and all clients to use the Memcached instance Delete theold instance.

D : Create a new Memorystore for Redis instance with Standard Tier Set capacity to 5 GB and createmultiple read replicas Delete the old instance.

Answer: D