LFC Data Management 3

Question 1

Which file format is the default storage format for Delta Lake tables?

Accepted Answer

Parquet

Answer

Delta Lake stores data as Parquet files and adds a transaction log layer on top to provide ACID guarantees.

Question 2

A business analyst needs read access to a specific table in Unity Catalog but should not see other tables in the same schema. What is the recommended approach?

Accepted Answer

Grant SELECT on just that specific table

Answer

Unity Catalog supports fine-grained privilege grants at the table level, so you can grant SELECT on a single table without exposing the whole schema.

Question 3

What is the role of 'data quality rules' in a medallion architecture?

Accepted Answer

They enforce checks that data must pass before advancing to the next layer

Answer

Data quality rules (constraints, expectations) validate correctness, completeness, and conformity, acting as gates between Bronze, Silver, and Gold layers.

Question 4

Which Delta Lake command consolidates many small Parquet files into fewer, larger files to improve query performance?

Accepted Answer

OPTIMIZE

Answer

OPTIMIZE compacts small files into larger, more efficient Parquet files, reducing the overhead of reading thousands of tiny fragments.

Question 5

In the context of lakehouse data management, what does PII stand for and why is it significant?

Accepted Answer

Personally Identifiable Information — subject to privacy regulations requiring controlled access

Answer

PII (Personally Identifiable Information) includes data that can identify an individual; regulations like GDPR and CCPA mandate strict access controls and retention policies.

(LFC) Lakehouse Fundamentals Certification Practice Test

(LFC) Lakehouse Fundamentals Certification Practice Test

LFC Data Management 3