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.
A multinational financial services enterprise wants to share curated market analytics datasets with external corporate partners using BigQuery sharing (Analytics Hub).
The enterprise has established the following technical and governance requirements:
How should the data engineer configure the Analytics Hub environment?
BigQuery Analytics Hub allows organizations to publish and subscribe to shared datasets across organization and project boundaries without data replication. An Analytics Hub listing packages a shared dataset and exposes it via a data exchange, enabling subscribers to provision read-only linked datasets.
roles/analyticshub.viewer to allAuthenticatedUsers, the enterprise keeps the broader exchange secured while making individual listings discoverable to authenticated Google Cloud accounts.job_principal_subject field of the INFORMATION_SCHEMA.SHARED_DATASET_USAGE view.INFORMATION_SCHEMA views.This solution leverages native Analytics Hub discovery permissions and built-in subscriber logging without requiring custom log ingestion pipelines or compromising the privacy of the primary data exchange.
This option creates a private data exchange with a public listing, but proposes using Google Cloud Datastream to capture and replicate subscriber query audit logs.
INFORMATION_SCHEMA.SHARED_DATASET_USAGE without any extra pipelines.The enterprise needed near-real-time CDC replication from external transactional databases into BigQuery before sharing the tables through Analytics Hub.
This configuration applies standard IAM roles (roles/bigquery.dataViewer) directly to the underlying BigQuery dataset for allAuthenticatedUsers and uses VPC Service Controls egress rules to control network perimeter interactions.
allAuthenticatedUsers direct access to a core BigQuery dataset circumvents Analytics Hub subscription governance and does not enable listing-level Subscriber Email Logging.INFORMATION_SCHEMA.SHARED_DATASET_USAGE records with logged principal subjects.The goal was to provide open direct querying across specific VPC Service Controls perimeter boundaries without utilizing the Analytics Hub data exchange discovery framework.
This approach attempts to host private listings inside a publicly discoverable Analytics Hub data exchange while relying on standard Cloud Audit Logs Data Read log streams on the publisher's BigQuery dataset.
INFORMATION_SCHEMA.SHARED_DATASET_USAGE view.The organization intended for the entire exchange and all its listings to be open to the public catalog and did not require immutable listing-level principal tracking.
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