CDS Monitoring & Reporting Tools 3

Question 1

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

Accepted Answer

Column-level security or field-level permissions

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

Column names in reports no longer match source table column names

Answer

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

(CDS) Certified Data Steward Practice Test