LFC Security & Governance 2

Question 1

In Unity Catalog, which object represents the top-level container that is linked to a Databricks account and can be shared across multiple workspaces?

Accepted Answer

Metastore

Answer

The metastore is the top-level Unity Catalog object that is associated with a Databricks account region and shared across workspaces.

Question 2

Which Unity Catalog privilege allows a user to read data from a table but explicitly prevents them from viewing the table's column definitions?

Accepted Answer

SELECT

Answer

SELECT grants the ability to read rows from a table; however, BROWSE is required to view metadata without data access — SELECT alone does not hide column definitions.

Question 3

A data engineer wants to prevent a specific column containing Social Security Numbers from being visible to analysts while still letting them query other columns. Which Unity Catalog feature should they use?

Accepted Answer

Column masks

Answer

Column masks in Unity Catalog allow you to apply a masking function to a specific column so that sensitive values are hidden or transformed for unauthorized users.

Question 4

What does Unity Catalog's data lineage feature automatically track?

Accepted Answer

How data flows between tables, notebooks, and workflows

Answer

Unity Catalog automatically captures column-level and table-level lineage, showing how data moves and transforms across notebooks, jobs, and tables.

Question 5

In Databricks, which built-in role grants a user the ability to manage all objects within a specific catalog without being an account admin?

Accepted Answer

Catalog Admin

Answer

Catalog Admin is a Unity Catalog role that grants full management privileges over all objects (schemas, tables, volumes) within a specific catalog.

(LFC) Lakehouse Fundamentals Certification Practice Test

(LFC) Lakehouse Fundamentals Certification Practice Test

LFC Security & Governance 2