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 financial services organization is building a decentralized data mesh architecture on Google Cloud. Multiple domain teams need to expose curated analytical data products to downstream business analysts across the enterprise.
The enterprise architecture board has defined the following technical and regulatory constraints:
Which technical requirement and access pattern should the data engineering team implement to satisfy these business objectives?
Cloud Key Management Service (Cloud KMS) provides encryption key management to secure data at rest or to enable field-level/column-level encryption when paired with database and processing engines.
roles/bigquery.dataViewer on the base dataset gives them direct access to read all unencrypted columns and view metadata in the underlying tables, violating the least-privilege requirement.This approach would be appropriate if you needed envelope encryption with customer-managed cryptographic keys to protect sensitive at-rest storage volumes against external compliance risks.
A BigQuery Authorized View is a virtual table that allows users to query data from a restricted underlying dataset without having direct read access to that source dataset.
This pattern would be appropriate if an organization had a single, rarely modified view to share with a specific third-party entity without needing continuous deployment automation or dataset-wide inheritance.
BigQuery Authorized Datasets allow data product owners to authorize an entire dataset containing multiple views or user-defined functions (UDFs) to access source data stored in a separate, restricted dataset. This enables domain teams to publish virtual consumption interfaces without granting consumers direct access to raw, underlying data.
roles/bigquery.dataViewer) only on the consumption dataset containing the views. When analysts execute queries against these views, the authorization is evaluated via the dataset-level authorization grant, allowing access to the underlying base tables without exposing the underlying base tables directly.Using Authorized Datasets combined with Terraform modules provides the exact abstraction layer required for decentralized data product consumption interfaces while keeping management overhead low and maintaining rigorous access boundaries.
Exporting data to Cloud Storage and running Dataflow batch transformations creates a decoupled Extract-Transform-Load (ETL) pipeline that physically replicates data into separate destination datasets or files.
This solution would be appropriate if complex, multi-stage heavy transformations required intensive external Java or Python processing engines before loading data into a long-term historical archive.
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