Free Access Google.Professional-Data-Engineer.v2026-02-05.q279 Practice Test (Page 37)

Question 176

They want to expose aggregates of this data to other Google Cloud projects, while still controlling access to the user-level data.
Additionally, they need to minimize their overall storage cost and ensure the analysis cost for other projects is assigned to those projects.
What should they do?

A.Create dataViewer Identity and Access Management (IAM) roles on the dataset to enable sharing.

B.Create and share a new dataset and view that provides the aggregate results.

C.Create and share a new dataset and table that contains the aggregate results.

D.Create and share an authorized view that provides the aggregate results.

Question 177

You are part of a healthcare organization where data is organized and managed by respective data owners in various storage services. As a result of this decentralized ecosystem, discovering and managing data has become difficult You need to quickly identify and implement a cost-optimized solution to assist your organization with the following
* Data management and discovery
* Data lineage tracking
* Data quality validation
How should you build the solution?

A.Use BigLake to convert the current solution into a data lake architecture.

B.Build a new data discovery tool on Google Kubernetes Engine that helps with new source onboarding and data lineage tracking.

C.Use BigOuery to track data lineage, and use Dataprep to manage data and perform data quality validation.

D.Use Dataplex to manage data, track data lineage, and perform data quality validation.

Question 178

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

A.Create an authorized view on the BigQuery table to control data access, and provide third-party companies with access to that view.

B.Use Cloud Scheduler to export the data on a regular basis to Cloud Storage, and provide third-party companies with access to the bucket.

C.Create a separate dataset in BigQuery that contains the relevant data to share, and provide third-party companies with access to the new dataset.

D.Create a Cloud Dataflow job that reads the data in frequent time intervals, and writes it to the relevant BigQuery dataset or Cloud Storage bucket for third-party companies to use.

Question 179

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

B.Introduce resource hierarchy to leverage access control policy inheritance.

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

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

E.For 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.

Question 180

An aerospace company uses a proprietary data format to store its night dat
a. You need to connect this new data source to BigQuery and stream the data into BigQuery. You want to efficiency import the data into BigQuery where consuming as few resources as possible. What should you do?

A.Use a standard Dataflow pipeline to store the raw data m BigQuery and then transform the format later when the data is used

B.Use an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format

C.Write a she script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source

D.Use Apache Hive to write a Dataproc job that streams the data into BigQuery in CSV format

Other Version: 2177Google.Professional-Data-Engineer.v2025-09-04.q126; 2075Google.Professional-Data-Engineer.v2025-03-18.q108; 3811Google.Professional-Data-Engineer.v2024-12-09.q327; 3622Google.Professional-Data-Engineer.v2024-02-15.q202; 4144Google.Professional-Data-Engineer.v2023-09-14.q233; 5325Google.Professional-Data-Engineer.v2022-07-07.q155; 7723Google.Professional-Data-Engineer.v2022-02-11.q268; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

Latest Upload: 160EC-COUNCIL.312-38.v2026-10-22.q321; 121WGU.Health-Fitness-and-Wellness.v2026-10-21.q14; 144ISACA.COBIT-Design-and-Implementation.v2026-10-21.q57; 148NACE.NACE-CIP2-001.v2026-10-21.q36; 192Cisco.400-007.v2026-10-21.q176; 171F5.301a.v2026-10-21.q97; 154Oracle.1z0-1195-26.v2026-10-19.q18; 152Salesforce.Salesforce-Slack-Administrator.v2026-10-19.q126; 196Salesforce.JS-Dev-101.v2026-10-19.q106; 256PaloAltoNetworks.SSE-Engineer.v2026-10-17.q44

Question 176

Question 177

Question 178

Question 179

Question 180

Download PDF File