Monitoring & Reporting Tools Flashcards

Which feature of a BI reporting tool most directly helps a data steward enforce column-level data access controls?

Answer: Column-level security or field-level permissions

Column-level security restricts visibility of specific fields based on user roles, protecting sensitive attributes like PII or financials.

What is the primary purpose of a data quality scorecard in a monitoring program?

Answer: To provide a consolidated view of data quality dimensions across critical datasets

A data quality scorecard aggregates metrics across dimensions like completeness, accuracy, and timeliness into a single governance view.

When configuring a monitoring rule for null values, which threshold strategy is most appropriate for a mandatory identifier field?

Answer: Set a zero-tolerance threshold — any null triggers an alert

Mandatory identifier fields must never be null, so zero-tolerance thresholds are required to catch any violation immediately.

A data steward is asked to implement report versioning. What governance benefit does this provide?

Answer: Ability to audit what metrics stakeholders viewed at a specific point in time

Report versioning allows organizations to reconstruct exactly what was reported to stakeholders at any historical moment, supporting audit trails.

Which indicator signals that a reporting tool's metadata is out of sync with the actual data warehouse schema?

Answer: Column names in reports no longer match source table column names

Mismatched column names between the reporting layer and source schema indicate that metadata has not been refreshed after a schema change.

What does 'data freshness' mean in the context of monitoring dashboards?

Answer: How recently the data underlying the dashboard was updated

Data freshness measures the time elapsed since the data was last refreshed, indicating whether the dashboard reflects current reality.

A data steward discovers that two business units use different definitions for 'active customer' in their separate reports. Which governance action resolves this?

Answer: Establish a canonical business glossary definition and align both reports to it

A canonical business glossary provides an agreed-upon definition that eliminates conflicting interpretations across reports.