Trang chủ Professional Data Engineer 325 / 343
Quay lại bộ đề
Question #325 Topic 1
Your company has data assets across multiple Cloud Storage buckets and BigQuery datasets containing raw and processed data. The requirement is to establish a unified data governance framework that allows for centralized metadata discovery, data quality monitoring, and consistent security policy application across these various data stores without physically moving or duplicating the data. You need to implement a solution to achieve this federated governance. What should you do?
A
1. Export metadata out of Dataplex Universal Catalog by running a metadata export job.2. Implement Dataproc Metastore to manage table schemas and Apache Hive metastore for metadata discovery.3. Manage security using a combination of BigQuery row-level security and Cloud Storage policies.
B
1. Use Dataplex to organize the BigQuery datasets and Cloud Storage buckets into lakes and zones.2. Use Dataplex for automated metadata discovery, centralized security policy management, data profiling, and data quality tasks.
C
1. Deploy a centralized Cloud SQL database to store metadata extracted from BigQuery and Cloud Storage using custom scripts.2. Integrate the database with Looker Studio for data discovery and visualization.3. Implement a custom policy engine using Cloud Run functions triggered by changes in IAM policies to enforce consistent security across projects.
D
1. Create a Looker Studio dashboard on BigQuery INFORMATION_SCHEMA views to visualize and monitor data quality.2. Manage security using IAM policies at the project level, supplemented by BigQuery authorized views for granular access control.