🔥 40% Off Crucial Exams Memberships — Deal ends today!

1 hour, 51 minutes remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

Your company has a 20-TB BigQuery dataset updated hourly. Three partners in different Google Cloud organizations need SQL access for dashboards, but the data must remain in your project. Each partner must pay its own query costs. Security policy prohibits granting dataset-level IAM roles to external principals; instead, access must be provided through a service built for cross-organization sharing. You also need to revoke access instantly without data copies or export jobs. Which design satisfies these constraints?

  • Grant the partners BigQuery Data Viewer roles on the dataset and instruct them to run cross-project queries using the fully qualified table name.

  • Schedule a daily export of the dataset to Cloud Storage and give partners ACL access so they can create external tables that query the exported files.

  • Create a private data exchange in Analytics Hub, publish the BigQuery dataset as a listing, and have each partner subscribe, which creates a linked dataset they can query in their own projects.

  • Use BigQuery Data Transfer Service to replicate the dataset into each partner's project on an hourly schedule.

GCP Professional Data Engineer
Preparing and using data for analysis
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.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot