GCP Professional Data Engineer Practice Question

Your company's retail analytics platform uses a Cloud Storage bucket for raw files, a Dataflow streaming pipeline, and several BigQuery datasets. Developers currently deploy experimental code and run ad-hoc queries in the same production project, which has resulted in accidental table deletions and exposure of customer PII. You must redesign the environment so that:

  • Production data cannot be modified from development workflows.
  • Developers can still run realistic tests without accessing PII.
  • Ongoing administration effort is minimized. Which approach best meets these requirements?
  • Retain a single project but create separate BigQuery datasets for dev and prod; apply row-level security to hide PII and grant developers the BigQuery DataOwner role on both datasets for flexibility.

  • Create separate Google Cloud projects for development and production, run each Dataflow job with its own service account, grant developers BigQuery DataViewer on an authorized view that exposes only de-identified production data, and give them broader permissions only in the development project.

  • Keep everything in the production project and use separate VPC networks for dev and prod pipelines; enable Cloud Storage object versioning to recover from accidental deletions while leaving current BigQuery permissions unchanged.

  • Export full production tables nightly to Cloud Storage, load them into a development dataset in the same project, and encrypt them with CMEK instead of changing IAM boundaries.

GCP Professional Data Engineer
Designing data processing systems
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot