LFC Unity Catalog & Data Governance 3

Question 1

What is the key difference between a managed table and an external table in Unity Catalog?

Accepted Answer

Unity Catalog controls the lifecycle and storage of managed tables; external tables use user-specified storage

Answer

For managed tables Unity Catalog controls the data location and deletes the underlying files when the table is dropped, while external tables point to user-managed storage.

Question 2

A Unity Catalog admin needs to configure access to an S3 bucket for external tables. Which two objects must be created?

Accepted Answer

Storage credential and external location

Answer

A storage credential (IAM role or service principal) and an external location (path + credential binding) are both required to access external cloud storage in Unity Catalog.

Question 3

Which statement about Unity Catalog's row-level security is correct?

Accepted Answer

It is implemented using dynamic views that filter rows based on the current user or group

Answer

Row-level security in Unity Catalog is implemented by creating dynamic views that use current_user() or IS_MEMBER() functions to filter rows.

Question 4

In Unity Catalog, which built-in function is used within a dynamic view to return the email address of the currently logged-in user?

Accepted Answer

current_user()

Answer

The current_user() function in Unity Catalog dynamic views returns the email of the authenticated user making the query.

Question 5

A data steward applies a column mask to a PII column in Unity Catalog. What happens when a user without the 'unmask' privilege queries that column?

Accepted Answer

The masking function returns a substituted or redacted value

Answer

Column masking applies a masking function that returns a transformed (e.g., redacted or tokenized) value rather than blocking access entirely.

(LFC) Lakehouse Fundamentals Certification Practice Test

(LFC) Lakehouse Fundamentals Certification Practice Test

LFC Unity Catalog & Data Governance 3