McAfee Secured

Google Professional Data Engineer Bundle

Exam Code: Professional Data Engineer

Exam Name Professional Data Engineer on Google Cloud Platform

Certification Provider: Google

Corresponding Certification: Professional Data Engineer

Google Professional Data Engineer Bundle $44.99

Pass Google Professional Data Engineer with Real Questions From Testking

Download Web's Best Professional Data Engineer Exam Preparation Materials Today

  • Questions & Answers

    Professional Data Engineer Questions & Answers

    349 Questions & Answers

    Questions & Answers Testing Engine software allows you to practice questions and answers in real Professional Data Engineer exam environment.

  • Professional Data Engineer Video Course

    Professional Data Engineer Video Course

    201 Video Lectures

    Professional Data Engineer Video Course is developed by Google Professionals to help you pass Professional Data Engineer exam.

    Description

    This course will improve your knowledge and skills required to pass Professional Data Engineer on Google Cloud Platform exam.
  • Study Guide

    Professional Data Engineer Study Guide

    543 PDF Pages

    Study Guide will give you a practical experience regarding the subject and provide an academic background. Professional Data Engineer Study Guide is available in PDF format.

Professional Data Engineer on Google Cloud Platform (Professional Data Engineer) Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    349 Questions

    $124.99
  • Professional Data Engineer Video Course

    Video Course

    201 Video Lectures

    $39.99
  • Study Guide

    Study Guide

    543 PDF Pages

    $29.99

Google Professional Data Engineer Practice Test 2

Question 10

An external auditor needs aggregates over a private BigQuery fact table but should not receive direct reads of individual payment rows. What underlying data-system principle is most relevant to this case?

  1. BigQuery job execution permission and source-data access are independent checks that can apply in different projects.
  2. An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table.
  3. Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.
  4. Row policies filter table rows per granted identity while broad dataset IAM alone cannot separate country records.

Explanation

Correct Answer

B:

An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table. The scenario therefore calls for this specific correction: Expose a restricted authorized view containing the approved aggregates rather than granting table-wide data access. The confirming test is: Query as the audit identity and verify the view works while direct base-table access remains denied.

Other Answers

A:

BigQuery job execution permission and source-data access are independent checks that can apply in different projects. The proposed statement applies to A partner gets permission to run BigQuery jobs in one project but a query fails because its data table is in a separately governed project. The necessary explanation for the present evidence is instead: An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table.

C:

Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. That is a valid distinction for another scenario (A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key.), but the described case turns on: An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table.

D:

Row policies filter table rows per granted identity while broad dataset IAM alone cannot separate country records. The proposed statement applies to A fraud analytics team must let regional investigators read transactions only for their assigned country without duplicating the shared BigQuery table. The necessary explanation for the present evidence is instead: An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table.

Question 11

An external auditor needs aggregates over a private BigQuery fact table but should not receive direct reads of individual payment rows. What measurable check would reveal whether this specific failure was actually fixed?

  1. Exercise an encrypted table operation using the service agent and verify authorized use and audit records.
  2. Query as the audit identity and verify the view works while direct base-table access remains denied.
  3. Test as two investigator identities and confirm each sees only its permitted country's known sample rows.
  4. Run the cross-project query with a least-privilege identity and confirm a direct unauthorized dataset remains blocked.

Explanation

Correct Answer

B:

Query as the audit identity and verify the view works while direct base-table access remains denied. The check tests the corrected behavior, not merely a configuration label, because An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table.

Other Answers

A:

Exercise an encrypted table operation using the service agent and verify authorized use and audit records. This is useful for a different case: A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. It would not prove this workload met its requirement; the decisive check is: Query as the audit identity and verify the view works while direct base-table access remains denied.

C:

Test as two investigator identities and confirm each sees only its permitted country's known sample rows. That test may be appropriate to the distinct failure (A fraud analytics team must let regional investigators read transactions only for their assigned country without duplicating the shared BigQuery table.), not the current defect. The evidence needed here is: Query as the audit identity and verify the view works while direct base-table access remains denied.

D:

Run the cross-project query with a least-privilege identity and confirm a direct unauthorized dataset remains blocked. This is useful for a different case: A partner gets permission to run BigQuery jobs in one project but a query fails because its data table is in a separately governed project. It would not prove this workload met its requirement; the decisive check is: Query as the audit identity and verify the view works while direct base-table access remains denied.

Question 12

An external auditor needs aggregates over a private BigQuery fact table but should not receive direct reads of individual payment rows. What durable design guardrail should the team institute?

  1. Document and test cross-project execution and read grants as separate contract requirements.
  2. Version row policy definitions with country assignments and run automated cross-country access regression tests.
  3. Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys.
  4. Keep view SQL and authorized-dataset bindings in reviewable source with tests for unintended detail leakage.

Explanation

Correct Answer

D:

Keep view SQL and authorized-dataset bindings in reviewable source with tests for unintended detail leakage. It protects the actual requirement instead of only today's fix; the mechanism to control is: An authorized view delegates controlled access to a query result without requiring a consumer to read the underlying source table.

Other Answers

A:

Document and test cross-project execution and read grants as separate contract requirements. It is a reasonable safeguard for a different situation: A partner gets permission to run BigQuery jobs in one project but a query fails because its data table is in a separately governed project. However, it does not enforce the contract required here. The specific prevention is: Keep view SQL and authorized-dataset bindings in reviewable source with tests for unintended detail leakage.

B:

Version row policy definitions with country assignments and run automated cross-country access regression tests. That policy addresses the mechanism Row policies filter table rows per granted identity while broad dataset IAM alone cannot separate country records. The present scenario instead needs the ongoing rule: Keep view SQL and authorized-dataset bindings in reviewable source with tests for unintended detail leakage.

C:

Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys. This control protects against the separate condition: A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. It leaves the present risk insufficiently controlled; use: Keep view SQL and authorized-dataset bindings in reviewable source with tests for unintended detail leakage.

Question 13

A multinational retailer stores identifiable EU customer data and proposes to place raw exports in a US multi-region bucket without residency review. Which implementation directly addresses the stated requirement without introducing an unrelated dependency?

  1. Configure supported data masking policies for protected columns and grant masked readers the approved masked projection.
  2. Extend the authorized data perimeter design to the relevant storage and data services and test allowed access paths.
  3. Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload.
  4. Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction.

Explanation

Correct Answer

D:

BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely. The selected action directly addresses the identified defect: Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction. A meaningful acceptance check is: Inspect actual dataset and bucket locations plus attempted export destinations against the residency policy.

Other Answers

A:

Configure supported data masking policies for protected columns and grant masked readers the approved masked projection. Dynamic data masking provides policy-governed transformed values while raw-value permissions remain restricted. That is relevant to a different case: A regulated BigQuery dataset contains analyst-visible columns that should display partially masked values instead of causing every ordinary report to fail. It does not establish the control missing here, so choose: Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction.

B:

Extend the authorized data perimeter design to the relevant storage and data services and test allowed access paths. That action fits a different situation: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. Its own premise is: A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource. In the present case, BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely. The needed correction is: Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction.

C:

Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload. This would target another data-engineering constraint (A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key.) rather than the observed failure. Here BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely. The focused solution is: Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction.

Question 14

A multinational retailer stores identifiable EU customer data and proposes to place raw exports in a US multi-region bucket without residency review. What underlying data-system principle is most relevant to this case?

  1. A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource.
  2. BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely.
  3. Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.
  4. Dynamic data masking provides policy-governed transformed values while raw-value permissions remain restricted.

Explanation

Correct Answer

B:

BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely. This explains the observed behavior rather than a symptom in a different data flow. Apply: Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction.

Other Answers

A:

A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource. This explains a different case: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. It is not the cause in the question: BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely.

C:

Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. The proposed statement applies to A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. The necessary explanation for the present evidence is instead: BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely.

D:

Dynamic data masking provides policy-governed transformed values while raw-value permissions remain restricted. This explains a different case: A regulated BigQuery dataset contains analyst-visible columns that should display partially masked values instead of causing every ordinary report to fail. It is not the cause in the question: BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely.

Question 15

A multinational retailer stores identifiable EU customer data and proposes to place raw exports in a US multi-region bucket without residency review. What measurable check would reveal whether this specific failure was actually fixed?

  1. Compare a masked reader's output with a privileged reader and confirm the raw value is never displayed to the former.
  2. Exercise an encrypted table operation using the service agent and verify authorized use and audit records.
  3. Inspect actual dataset and bucket locations plus attempted export destinations against the residency policy.
  4. Attempt an unapproved cross-perimeter bucket copy and verify blocking while approved pipeline traffic remains functional.

Explanation

Correct Answer

C:

Inspect actual dataset and bucket locations plus attempted export destinations against the residency policy. This validates the intended result after implementing: Choose approved EU storage and BigQuery dataset locations and prohibit raw-data moves outside the allowed jurisdiction. The relevant causal principle is: BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely.

Other Answers

A:

Compare a masked reader's output with a privileged reader and confirm the raw value is never displayed to the former. This test addresses a different case: A regulated BigQuery dataset contains analyst-visible columns that should display partially masked values instead of causing every ordinary report to fail. It does not validate the scenario in the question, where acceptance requires: Inspect actual dataset and bucket locations plus attempted export destinations against the residency policy.

B:

Exercise an encrypted table operation using the service agent and verify authorized use and audit records. That test may be appropriate to the distinct failure (A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key.), not the current defect. The evidence needed here is: Inspect actual dataset and bucket locations plus attempted export destinations against the residency policy.

D:

Attempt an unapproved cross-perimeter bucket copy and verify blocking while approved pipeline traffic remains functional. This test addresses a different case: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. It does not validate the scenario in the question, where acceptance requires: Inspect actual dataset and bucket locations plus attempted export destinations against the residency policy.

Question 16

A multinational retailer stores identifiable EU customer data and proposes to place raw exports in a US multi-region bucket without residency review. What durable design guardrail should the team institute?

  1. Recheck masking policy bindings and sample outputs when column schemas or identity groups change.
  2. Review protected resource membership and service-perimeter ingress/egress policies when new stages are added.
  3. Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys.
  4. Enforce organization location constraints and automated deployment checks for regulated data resources.

Explanation

Correct Answer

D:

Enforce organization location constraints and automated deployment checks for regulated data resources. The safeguard addresses recurrence of the same root issue: BigQuery and Cloud Storage resource location choices affect data residency; a dashboard's region does not relocate stored records safely.

Other Answers

A:

Recheck masking policy bindings and sample outputs when column schemas or identity groups change. That policy addresses the mechanism Dynamic data masking provides policy-governed transformed values while raw-value permissions remain restricted. The present scenario instead needs the ongoing rule: Enforce organization location constraints and automated deployment checks for regulated data resources.

B:

Review protected resource membership and service-perimeter ingress/egress policies when new stages are added. This control protects against the separate condition: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. It leaves the present risk insufficiently controlled; use: Enforce organization location constraints and automated deployment checks for regulated data resources.

C:

Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys. It is a reasonable safeguard for a different situation: A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. However, it does not enforce the contract required here. The specific prevention is: Enforce organization location constraints and automated deployment checks for regulated data resources.

Question 17

A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. Which implementation directly addresses the stated requirement without introducing an unrelated dependency?

  1. Separate development and production projects and grant environment-specific least-privilege IAM and service accounts.
  2. Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload.
  3. Replace long-lived exported keys with an approved workload identity mechanism and narrowly scoped service-account impersonation.
  4. Extend the authorized data perimeter design to the relevant storage and data services and test allowed access paths.

Explanation

Correct Answer

B:

Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload. This is the appropriate intervention because Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. Validate by performing this targeted check: Exercise an encrypted table operation using the service agent and verify authorized use and audit records.

Other Answers

A:

Separate development and production projects and grant environment-specific least-privilege IAM and service accounts. That action fits a different situation: A bank's development environment accidentally has write permission on its production BigQuery financial datasets through a shared project-level role. Its own premise is: Project-wide grants span resources in that project; shared high-privilege identities erase environment isolation. In the present case, Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. The needed correction is: Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload.

C:

Replace long-lived exported keys with an approved workload identity mechanism and narrowly scoped service-account impersonation. Portable credential files create persistent exposure even when a job's data permissions are otherwise limited. That is relevant to a different case: A contractor's scheduled Dataflow job uses a downloadable service-account JSON key that is copied into developer workstations. It does not establish the control missing here, so choose: Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload.

D:

Extend the authorized data perimeter design to the relevant storage and data services and test allowed access paths. That action fits a different situation: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. Its own premise is: A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource. In the present case, Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. The needed correction is: Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload.

Question 18

A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. What underlying data-system principle is most relevant to this case?

  1. Portable credential files create persistent exposure even when a job's data permissions are otherwise limited.
  2. Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.
  3. A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource.
  4. Project-wide grants span resources in that project; shared high-privilege identities erase environment isolation.

Explanation

Correct Answer

B:

Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. The operational evidence is distinct from unrelated source or sink issues; the proposed repair is: Grant the authorized BigQuery service agent the narrow Cloud KMS key permissions required for the selected CMEK workload.

Other Answers

A:

Portable credential files create persistent exposure even when a job's data permissions are otherwise limited. That is a valid distinction for another scenario (A contractor's scheduled Dataflow job uses a downloadable service-account JSON key that is copied into developer workstations.), but the described case turns on: Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.

C:

A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource. This explains a different case: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. It is not the cause in the question: Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.

D:

Project-wide grants span resources in that project; shared high-privilege identities erase environment isolation. That is a valid distinction for another scenario (A bank's development environment accidentally has write permission on its production BigQuery financial datasets through a shared project-level role.), but the described case turns on: Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.

Question 19

A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. What measurable check would reveal whether this specific failure was actually fixed?

  1. Exercise an encrypted table operation using the service agent and verify authorized use and audit records.
  2. Confirm the pipeline authenticates without a JSON key and that revoked identities cannot assume the service account.
  3. Attempt an unapproved cross-perimeter bucket copy and verify blocking while approved pipeline traffic remains functional.
  4. Attempt a development-principal write to production and verify denial while its development job still succeeds.

Explanation

Correct Answer

A:

Exercise an encrypted table operation using the service agent and verify authorized use and audit records. This exercises the actual failure: Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant. It is more decisive than checking only job completion or service status.

Other Answers

B:

Confirm the pipeline authenticates without a JSON key and that revoked identities cannot assume the service account. This is useful for a different case: A contractor's scheduled Dataflow job uses a downloadable service-account JSON key that is copied into developer workstations. It would not prove this workload met its requirement; the decisive check is: Exercise an encrypted table operation using the service agent and verify authorized use and audit records.

C:

Attempt an unapproved cross-perimeter bucket copy and verify blocking while approved pipeline traffic remains functional. This test addresses a different case: An ingestion service stores customer data in an unrestricted staging bucket; a VPC Service Controls perimeter exists only around BigQuery. It does not validate the scenario in the question, where acceptance requires: Exercise an encrypted table operation using the service agent and verify authorized use and audit records.

D:

Attempt a development-principal write to production and verify denial while its development job still succeeds. That test may be appropriate to the distinct failure (A bank's development environment accidentally has write permission on its production BigQuery financial datasets through a shared project-level role.), not the current defect. The evidence needed here is: Exercise an encrypted table operation using the service agent and verify authorized use and audit records.

Question 20

A payment warehouse uses customer-managed encryption keys; its project grants analysts BigQuery access but the service identity cannot use the selected KMS key. What durable design guardrail should the team institute?

  1. Audit workload credential usage and prevent service-account key creation where approved keyless identities suffice.
  2. Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys.
  3. Review protected resource membership and service-perimeter ingress/egress policies when new stages are added.
  4. Require environment boundary checks and privilege reviews before applying infrastructure changes.

Explanation

Correct Answer

B:

Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys. This is durable because it verifies the condition over future changes: Resource-data IAM and cryptographic key-use IAM are separate controls, so table readers cannot repair a missing service-agent key grant.

Other Answers

A:

Audit workload credential usage and prevent service-account key creation where approved keyless identities suffice. This control protects against the separate condition: A contractor's scheduled Dataflow job uses a downloadable service-account JSON key that is copied into developer workstations. It leaves the present risk insufficiently controlled; use: Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys.

C:

Review protected resource membership and service-perimeter ingress/egress policies when new stages are added. That policy addresses the mechanism A BigQuery perimeter does not necessarily protect an external copy in an unprotected Cloud Storage resource. The present scenario instead needs the ongoing rule: Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys.

D:

Require environment boundary checks and privilege reviews before applying infrastructure changes. This control protects against the separate condition: A bank's development environment accidentally has write permission on its production BigQuery financial datasets through a shared project-level role. It leaves the present risk insufficiently controlled; use: Monitor key access, rotation and permissions for datasets bound to customer-managed encryption keys.