Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
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?
This approach uses scheduled queries to extract data snapshots into Cloud Storage buckets owned by each subscriber, relying on export jobs rather than direct in-place dataset sharing.
pubsub.googleapis.com), not BigQuery query execution or dataset table access.Subscribers did not use BigQuery and required flat Parquet/CSV file delivery directly into object storage buckets.
This approach replicates table data continuously into each subscriber project using BigQuery Storage Write API streaming pipelines and attempts to monitor query performance via storage metadata views.
INFORMATION_SCHEMA.TABLE_STORAGE only provides storage consumption metrics (such as physical and logical bytes stored, fail-safe storage, and time travel bytes). It contains no data on query execution, slot utilization, or query latency.Subscribers required completely isolated, disconnected local copies of data with real-time continuous ingestion outside Analytics Hub.
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.
This configuration forces all subscribers to execute their analytical queries inside the publisher's project boundaries, consuming the publisher's BigQuery reservation slots and routing traffic over Shared VPC.
INFORMATION_SCHEMA.JOBS_BY_* and Cloud Logging.An organization wanted centralized compute pooling under a single administrative billing umbrella and did not allow subscriber projects to own BigQuery compute resources.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated