Google Cloud Professional Data Engineer Free Practice Exam Questions

316 real Google Cloud Professional Data Engineer exam questions with answers and AI explanations. Google Cloud certification prep — page 14 of 32.

Question 141: You are administering a BigQuery dataset that uses a customer-managed encryption key (CMEK). You need to share the dataset with a partner organization that doe…
Question 142: You are developing an Apache Beam pipeline to extract data from a Cloud SQL instance by using JdbcIO. You have two projects running in Google Cloud. The pipeli…
Question 143: You have a BigQuery table that contains customer data, including sensitive information such as names and addresses. You need to share the customer data with yo…
Question 144: You have a Cloud SQL for PostgreSQL instance in Region’ with one read replica in Region2 and another read replica in Region3. An unexpected event in Region’ re…
Question 145: You orchestrate ETL pipelines by using Cloud Composer. One of the tasks in the Apache Airflow directed acyclic graph (DAG) relies on a third-party service. You…
Question 146: You are migrating your on-premises data warehouse to BigQuery. One of the upstream data sources resides on a MySQL. database that runs in your on-premises data…
Question 147: You store and analyze your relational data in BigQuery on Google Cloud with all data that resides in US regions. You also have a variety of object stores acros…
Question 148: You have a variety of files in Cloud Storage that your data science team wants to use in their models. Currently, users do not have a method to explore, cleans…
Question 149: You are building an ELT solution in BigQuery by using Dataform. You need to perform uniqueness and null value checks on your final tables. What should you do t…
Question 150: A web server sends click events to a Pub/Sub topic as messages. The web server includes an eventTimestamp attribute in the messages, which is the time when the…