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.
Your enterprise stores highly sensitive customer transactional data in a centralized BigQuery dataset (raw_transactions). An external partner organization needs to query aggregated daily transaction metrics without gaining direct access to the underlying sensitive tables containing personally identifiable information (PII).
You must design a secure data sharing architecture that satisfies the following requirements:
raw_transactions dataset.Which solution should you implement?
autofs on Compute Engine instances to mount raw table exports and share access with the partner via Cloud Load Balancing.This approach exports tabular data to file systems and mounts shared file directories across Linux virtual machines using autofs and Network File System (NFS), routed through internal load balancers.
autofs) introduces unmanaged infrastructure overhead for what should be a native cloud-sharing mechanism.autofs is an operating system daemon designed for mounting file systems on Linux servers, typically used in SAP or HPC architectures, not for modern BigQuery data sharing.You were configuring a high-availability shared file system for enterprise SAP NetWeaver application servers using central NFS mounts.
raw_transactions. Authorize the view to access raw_transactions, grant the partner roles/bigquery.dataViewer on the new dataset, and enable BigQuery Data Access audit logs.An authorized view in BigQuery is a logical SQL view that allows specific users or groups to query aggregated or filtered data from a source dataset without granting those users direct access to the underlying source tables. By authorizing the view itself to access the source dataset, BigQuery executes queries against the view using the view's elevated dataset authorization rather than the end-user's permissions.
raw_transactions, users only need the roles/bigquery.dataViewer role on the dataset containing the view.DATA_READ logs) in Cloud Audit Logs ensures every query run against the authorized view is captured with detailed metadata, timestamps, and caller identities.roles/bigquery.dataViewer and Cloud Logging.This pattern separates consumer presentation from protected underlying storage while maintaining complete regulatory auditing and strict data isolation.
roles/bigquery.dataEditor on the raw_transactions dataset and create a standard view inside raw_transactions that aggregates the metrics.Granting the roles/bigquery.dataEditor role provides extensive read and write capabilities across all tables and models within the designated BigQuery dataset, allowing the grantee to modify, create, and inspect data assets.
roles/bigquery.dataEditor directly on raw_transactions allows the external partner to inspect, query, modify, and delete the underlying sensitive transactional data and PII directly, completely bypassing the aggregated view.dataEditor) on production tables.roles/bigquery.dataEditor includes data manipulation permissions (updateData, tables.delete, tables.update).The external partner were an internal data engineering team responsible for updating, modifying, and maintaining table schemas and ETL pipelines within the dataset.
roles/bigquery.admin role on the project and configure a Cloud Storage transfer service to dump aggregated tables into a public bucket.Assigning roles/bigquery.admin gives full administrative access over all BigQuery resources in the project, while configuring a transfer to a public Cloud Storage bucket exposes aggregated data publicly to the internet.
roles/bigquery.admin allows the partner full access to delete datasets, manage capacity commitments, read all sensitive underlying tables, and alter IAM policies across the entire project.roles/bigquery.admin contains administrative permissions such as bigquery.capacityCommitments.delete and unrestricted dataset management.You needed an internal project administrator to configure capacity reservations and manage infrastructure for all BigQuery workloads across the organization.
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