A financial services firm runs batch ETL pipelines that move data from Cloud Storage to BigQuery. The data quality team needs to trace a specific row in a BigQuery table back to the exact source file and the transformation job that produced it. What should you implement?

Include a `source_file` and `job_id` column in the BigQuery table during the ETL load.

Use Cloud Data Fusion to track row-level lineage automatically.

Enable BigQuery audit logs and query them for the load job details.

Add a lineage tag to the BigQuery table using Dataplex and attach it to the pipeline job.

A data platform team uses Dataplex to manage data assets across BigQuery and Cloud Storage. They need to understand the full data flow from source to final reports, including transformations applied by Dataflow jobs. The compliance team requires that this lineage be available for audit. What should you implement?

Create a custom metadata table in BigQuery to track lineage.

Enable Dataplex lineage and ensure Dataflow jobs are registered with Dataplex.

Use Cloud Data Fusion to track lineage.

Use BigQuery audit logs to reconstruct lineage manually.

A company stores raw IoT sensor data in Cloud Storage and uses BigQuery for analytics. The security team requires that data analysts can query the data but cannot access the `device_id` column. The data engineering team also needs to track which analyst queried the data for audit purposes. What should you do?

Apply a policy tag to `device_id` and use BigQuery audit logs to track analyst queries.

Grant analysts access to the underlying table and rely on IAM conditions.

Use Dataplex to mask `device_id` and enable Cloud Logging for Dataplex.

Create a BigQuery view that excludes `device_id` and grant analysts access to the view.

A data governance team needs to enforce that all BigQuery tables in a project have a `data_owner` tag and a `retention_period` tag. They want to automatically apply these tags to new tables as they are created. What should you do?

Use BigQuery's default table settings to apply tags.

Create a Cloud Function that triggers on BigQuery table creation and applies the tags via the Dataplex API.

Manually apply the tags to each new table.

Use Dataplex to create a tag template and apply it to the project.

Google CloudProfessional Data Engineer

Domain 3Objective 4

3.4 Designing for a Data Platform PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 3)

Part of the Storing the data domain, which accounts for ~20% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~10–16 in this domain), expect 3–4 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

6concepts

~20%of the exam

Questions 11–15

11foundation · easy
A data engineering team manages data across multiple Google Cloud projects and storage systems, including BigQuery datasets, Cloud Storage buckets, and Bigtable instances. They need a single place to discover, manage, and govern these distributed data assets. Which Google Cloud service is designed for this purpose?
Select an answer first
12application · medium
A financial services firm runs batch ETL pipelines that move data from Cloud Storage to BigQuery. The data quality team needs to trace a specific row in a BigQuery table back to the exact source file and the transformation job that produced it. What should you implement?
Select an answer first
13expert · hard
A data platform team uses Dataplex to manage data assets across BigQuery and Cloud Storage. They need to understand the full data flow from source to final reports, including transformations applied by Dataflow jobs. The compliance team requires that this lineage be available for audit. What should you implement?
Select an answer first
14expert · hard
A company stores raw IoT sensor data in Cloud Storage and uses BigQuery for analytics. The security team requires that data analysts can query the data but cannot access the `device_id` column. The data engineering team also needs to track which analyst queried the data for audit purposes. What should you do?
Select an answer first
15application · medium
A data governance team needs to enforce that all BigQuery tables in a project have a `data_owner` tag and a `retention_period` tag. They want to automatically apply these tags to new tables as they are created. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

3.4 Designing for a Data Platform PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 3)

Questions 11–15

A financial services firm runs batch ETL pipelines that move data from Cloud Storage to BigQuery. The data quality team needs to trace a specific row in a BigQuery table back to the exact source file and the transformation job that produced it. What should you implement?

A data governance team needs to enforce that all BigQuery tables in a project have a `data_owner` tag and a `retention_period` tag. They want to automatically apply these tags to new tables as they are created. What should you do?

Keep studying — Storing the data