Spring Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 5 Topic 1 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 5 Topic 1 Discussion

Professional-Data-Engineer Exam Topic 1 Question 5 Discussion:
Question #: 5
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.

Deploy a centralized Cloud SQL database to store metadata extracted from BigQuery and Cloud Storage using custom scripts.

Integrate the database with Looker Studio for data discovery and visualization.

Implement a custom policy engine using Cloud Run functions triggered by changes in IAM policies to enforce consistent security across projects.


B.

Create a Looker Studio dashboard on BigQuery INFORMATION_SCHEMA views to visualize and monitor data quality.

Manage security using IAM policies at the project level, supplemented by BigQuery authorized views for granular access control.


C.

Export metadata out of Dataplex Universal Catalog by running a metadata export job.

Implement Dataproc Metastore to manage table schemas and Apache Hive metastore for metadata discovery.

Manage security using a combination of BigQuery row-level security and Cloud Storage policies.


D.

Use Dataplex to organize the BigQuery datasets and Cloud Storage buckets into lakes and zones.

Use Dataplex for automated metadata discovery, centralized security policy management, data profiling, and data quality tasks.


Get Premium Professional-Data-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.