🔥 40% Off Crucial Exams Memberships — Deal ends today!

3 hours, 1 minute remaining!

GCP Professional Data Engineer Practice Question

Your company's data platform team must provide a self-service environment where data engineers across multiple projects can discover, profile, and govern files stored in Cloud Storage and tables in BigQuery. The solution should automatically scan new and existing assets to harvest technical metadata, generate data profiles that include statistics such as null counts and cardinality, and surface the assets through a unified catalog that supports fine-grained access controls. The team wants to minimize custom code and avoid deploying third-party software. Which design best satisfies these requirements?

  • Create Dataplex lakes and governed zones that reference the Cloud Storage buckets and BigQuery datasets, enable automated discovery, data profiling, and quality scans in each zone, and use the Dataplex catalog for cross-project search and access control.

  • Use Cloud Asset Inventory to index storage objects and datasets, and schedule BigQuery Data Transfer Service jobs to load audit logs that analysts can query for metadata and quality metrics.

  • Centralize all data by copying it into a single BigQuery dataset with BigQuery Omni, then rely on INFORMATION_SCHEMA views and custom Cloud Composer DAGs to generate profiling reports.

  • Register every bucket and dataset in standalone Data Catalog entry groups and trigger Cloud Functions that launch Dataflow jobs to calculate statistics and update metadata tables.

GCP Professional Data Engineer
Designing data processing systems
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot