professional-cloud-data-engineer
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Last updated
An enterprise data architecture team is configuring BigQuery Analytics Hub to publish core multi-terabyte datasets to multiple internal and external subscriber projects. The leadership team requires a clear financial governance model and audit strategy that meets the following criteria:
Which architecture and monitoring configuration aligns with BigQuery Analytics Hub best practices and financial governance models?
The publisher configures authorized views and exports table snapshots to subscriber Cloud Storage buckets via scheduled queries, absorbing all query compute and export storage costs, and monitoring subscriber access through Pub/Sub audit logs.
The publisher creates physical table replicas in each subscriber project using continuous streaming ingestion, incurring streaming ingestion fees and subscriber-side storage charges, while querying INFORMATION_SCHEMA.TABLE_STORAGE in the publisher project to monitor subscriber query execution.
The publisher hosts and pays for the BigQuery storage in the source project and publishes listings via Analytics Hub; subscribers create linked datasets in their respective projects and pay for their own query compute (on-demand or BigQuery Editions slot reservations). The publisher monitors table access and data access patterns using Cloud Audit Logs in the publisher project, while subscribers analyze query execution performance and slot consumption using their own project's INFORMATION_SCHEMA.JOBS_BY_* views.
The publisher requires all subscribers to run queries against the source dataset using the publisher project's reservation slot pool via Shared VPC, rebilling subscribers using Cloud Billing exports, and tracking query plans using Cloud Trace API traces.
The publisher configures authorized views and exports table snapshots to subscriber Cloud Storage buckets via scheduled queries, absorbing all query compute and export storage costs, and monitoring subscriber access through Pub/Sub audit logs.
The publisher creates physical table replicas in each subscriber project using continuous streaming ingestion, incurring streaming ingestion fees and subscriber-side storage charges, while querying INFORMATION_SCHEMA.TABLE_STORAGE in the publisher project to monitor subscriber query execution.
The publisher hosts and pays for the BigQuery storage in the source project and publishes listings via Analytics Hub; subscribers create linked datasets in their respective projects and pay for their own query compute (on-demand or BigQuery Editions slot reservations). The publisher monitors table access and data access patterns using Cloud Audit Logs in the publisher project, while subscribers analyze query execution performance and slot consumption using their own project's INFORMATION_SCHEMA.JOBS_BY_* views.
BigQuery Analytics Hub is a fully managed data-sharing service that allows organizations to securely exchange datasets, views, and machine learning models across organizational boundaries without copying or moving the underlying storage.
INFORMATION_SCHEMA.JOBS_BY_PROJECT and INFORMATION_SCHEMA.JOBS_BY_USER views.This architecture directly implements Google Cloud's native in-place data-sharing model. It satisfies all cost-allocation requirements out of the box while providing robust auditability via Cloud Logging and INFORMATION_SCHEMA.
The publisher requires all subscribers to run queries against the source dataset using the publisher project's reservation slot pool via Shared VPC, rebilling subscribers using Cloud Billing exports, and tracking query plans using Cloud Trace API traces.