CDS Monitoring & Reporting Tools 3 — Questions and Answers
Question 1: Which feature of a BI reporting tool most directly helps a data steward enforce column-level data access controls?
- Row-level security filters
- Column-level security or field-level permissions (Correct answer)
- Report scheduling capabilities
- Data export restrictions at the file level
Correct 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.
Question 2: What is the primary purpose of a data quality scorecard in a monitoring program?
- To rank database administrators by performance
- To provide a consolidated view of data quality dimensions across critical datasets (Correct answer)
- To automate remediation of data quality issues
- To replace manual data audits with automated approval workflows
Correct 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.
Question 3: When configuring a monitoring rule for null values, which threshold strategy is most appropriate for a mandatory identifier field?
- Allow up to 5% nulls as acceptable tolerance
- Set a zero-tolerance threshold — any null triggers an alert (Correct answer)
- Alert only when nulls exceed 25% of total records
- Monitor nulls weekly rather than in real time
Correct 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.
Question 4: A data steward is asked to implement report versioning. What governance benefit does this provide?
- Faster rendering of complex visualizations
- Ability to audit what metrics stakeholders viewed at a specific point in time (Correct answer)
- Automatic backup of raw source data
- Reduced licensing costs for the reporting platform
Correct 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.
Question 5: Which indicator signals that a reporting tool's metadata is out of sync with the actual data warehouse schema?
- Reports load slower than usual
- Column names in reports no longer match source table column names (Correct answer)
- Dashboard filters return no results
- Export files are larger than expected
Correct 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.
Question 6: What does 'data freshness' mean in the context of monitoring dashboards?
- The visual design modernity of the dashboard interface
- How recently the data underlying the dashboard was updated (Correct answer)
- The speed at which users can interact with report filters
- The rate at which new columns are added to source tables
Correct 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.
Question 7: A data steward discovers that two business units use different definitions for 'active customer' in their separate reports. Which governance action resolves this?
- Merge both reports into a single shared dashboard
- Establish a canonical business glossary definition and align both reports to it (Correct answer)
- Allow each unit to keep its own definition as a local standard
- Replace both definitions with a vendor-supplied default
Correct 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.
CDS Monitoring & Reporting Tools 3
Which feature of a BI reporting tool most directly helps a data steward enforce column-level data access controls?