PrepPilotPractise free

Data Quality & Governance interview questions

Tests, observability, lineage, PII and governance

17 questions · expect · updated November 2026

Practise these as flashcards. One or two lines each; the ones you miss come back first.

Start free

Core questions

What are the main dimensions of data quality?

The main dimensions are accuracy, completeness, consistency, timeliness, uniqueness, and validity. Each dimension checks a different aspect of whether the data is reliable and fit for purpose.

How would you check for duplicate records in a database table?

I would run a query to count duplicate values in the key column, or use a dbt uniqueness test to automatically flag duplicates during pipeline runs.

What is PII and why must it be protected?

PII stands for Personally Identifiable Information, such as names, emails, or addresses. It must be protected to comply with privacy laws like GDPR and to prevent misuse or data breaches.

What is a data catalog?

A data catalog is a searchable repository of metadata about datasets, including schema, descriptions, owners, and lineage. It helps users discover and understand data assets.

Intermediate questions

How do dbt tests help maintain data quality?

dbt tests automate checks like uniqueness, null values, and referential integrity at the model level. They run during builds and can block deployments if tests fail, ensuring issues are caught early.

Describe how you would monitor data freshness in a pipeline.

I would track the timestamp of the latest data load and set up alerts if data is not updated within expected windows. This ensures downstream users always get timely data and can catch delays quickly.

What is schema drift and how do you handle it?

Schema drift is when the structure of source data changes unexpectedly, like columns being added or removed. I handle it by monitoring schema versions, alerting on changes, and coordinating with upstream teams to update transformations as needed.

How do you mask PII in a production database?

I use techniques like hashing, encryption, or partial masking to hide sensitive fields. For example, I might store only the last four digits of a phone number, or encrypt emails so only authorized users can access them.

Explain the purpose of a data contract.

A data contract defines the schema, quality, and delivery expectations between producers and consumers. It prevents breaking changes and clarifies responsibilities, making data pipelines more reliable.

How does Great Expectations differ from dbt tests?

Great Expectations focuses on granular, row-level and statistical validations, while dbt tests are mostly schema-level checks. Great Expectations can run on raw data and supports custom expectations, making it suitable for more complex quality checks.

How would you respond to a data quality incident?

I would first alert stakeholders, triage the issue, and rollback if needed. Then, I'd investigate the root cause, add new tests or monitoring, and document the incident to prevent recurrence.

How do you monitor column value distributions and why is it important?

I track statistics like mean, median, min, max, and histograms for key columns. Monitoring distributions helps catch silent errors, such as data skew or outliers, that basic tests might miss.

What steps do you take after discovering bad data in production?

See the answer in the app, free

Senior questions

How do you ensure compliance with GDPR in your data pipelines?

See the answer in the app, free

Describe a scenario where data lineage helped resolve a production issue.

See the answer in the app, free

How do you design observability for a large-scale data platform?

See the answer in the app, free

What are the trade-offs between strict data contracts and flexible schemas?

See the answer in the app, free

More Data Engineering topics