Data Governance & Quality Questions
Practice questions for Data Governance & Quality topic in Databricks Certified Data Engineer Associate. 22 questions covering this domain.
What happens when a Unity Catalog managed table is dropped with `DROP TABLE`?
A data engineer needs to grant a group of analysts `SELECT` access to all tables in a schema named `analytics` in the `prod` catalog. They also need t...
A data engineer needs to register an existing Parquet dataset stored in an Azure Data Lake Storage Gen2 path as a queryable table in Unity Catalog wit...
In Unity Catalog, what is the three-level namespace used to reference a table?
A data engineer discovers that sensitive PII data in a `customers` table is visible to all analysts in their workspace because a previous admin grante...
A data engineer needs to audit which users have been granted privileges on a specific Delta table `prod.sales.orders` in Unity Catalog. Which SQL comm...
In Unity Catalog, what is the purpose of a volume?
A data engineer needs to insert, update, and delete rows in a Unity Catalog table. They already have `SELECT` on the table. Which additional privilege...
A data engineer creates a Delta table in Unity Catalog and wants to add a NOT NULL constraint to the `order_id` column after the table has been create...
A data engineer needs to give a service principal `etl_pipeline_sp` write access to ingest data into a managed volume `landing_vol` in schema `ingesti...
A data engineering team has a Unity Catalog table `prod.finance.transactions` containing sensitive customer data. The security team requires that: (1)...
A Unity Catalog metastore admin wants to understand the full lineage of a Delta table: which upstream tables it reads from and which downstream tables...
A data engineer sets up a Delta table with a CHECK constraint: `ALTER TABLE orders ADD CONSTRAINT positive_amount CHECK (amount > 0)`. Later, a data p...
A data steward opens a lineage graph for a table in Workspace B, but the upstream notebook that created the data was run in Workspace A. What should t...
What is the standard Unity Catalog namespace used to reference a table or volume?
A user wants to add a governed tag to a Unity Catalog table. Which privileges are required at minimum?
What does the `BROWSE` privilege on a catalog allow a user to do?
A company has two Databricks workspaces attached to the same Unity Catalog metastore. They want users in Workspace B to access tables owned in Workspa...
Two workspaces are attached to the same Unity Catalog metastore. A steward opens the lineage graph in Workspace B for a table produced by a notebook r...
What is the standard Unity Catalog namespace used to reference governed data objects such as tables and volumes?
Sign in to see all 22 questions
Create a free account to browse all questions — completely free during our launch phase.