Data Governance Questions
Practice questions for Data Governance topic in Databricks Certified Data Engineer Professional. 14 questions covering this domain.
A user needs to query the table `main.sales.orders` in Unity Catalog. An admin has granted `SELECT` on `main.sales.orders` to the user, but the query ...
Where does Unity Catalog automatically store column-level data lineage records that track read and write events on columns?
When a Unity Catalog managed table is dropped using `DROP TABLE`, what happens to the underlying data files?
A company migrates from a legacy Hive metastore to Unity Catalog. In the legacy setup, tables are organized in Hive databases (e.g., `sales_db`). In U...
A company wants to tag all columns containing PII data in Unity Catalog with a tag `pii_type = 'email'` for automated discovery and compliance reporti...
A data governance team wants to ensure that all data engineers in the `de_team` group can query tables in `main.analytics` but can only write to table...
In Unity Catalog, which object type is used to govern access to non-tabular files stored in cloud object storage — such as raw CSV files, images, and ...
A data governance team queries `system.access.table_lineage` to find all tables that read from `main.bronze.raw_events`. Which SQL query correctly ide...
A streaming table was created by a Lakeflow Spark Declarative Pipeline, and ownership needs to move to a service principal. What is the documented way...
Which Unity Catalog object provides governed path-based access to files in cloud storage under paths like `/Volumes/catalog/schema/volume/`?
A user has the `MANAGE` privilege on a Unity Catalog table and checks `INFORMATION_SCHEMA` to review grants. Why might the results look incomplete?
A data engineering team wants governed path-based access to raw files under `/Volumes/main/raw/landing/`. Which Unity Catalog object provides that int...
A service principal must become the owner of a streaming table created by a Lakeflow Spark Declarative Pipeline. What is the documented approach?
A user has the `MANAGE` privilege on a Unity Catalog table and inspects `INFORMATION_SCHEMA` to review grants. Why might the results appear incomplete...
Sign in to see all 14 questions
Create a free account to browse all questions — completely free during our launch phase.