Question 100
Cedar City Utilities processes metering systems and billing applications with a defined data freshness objective. The investigation finds: Analysts copy a confidential base table for every consumer even though each audience only needs a read-only projection. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
Consumers query the approved projection without receiving direct unauthorized access to restricted base columns. The observation provides evidence that the proposed fix (Create an appropriately secured Unity Catalog view over the governed source data.) addressed the reported issue (Analysts copy a confidential base table for every consumer even though each audience only needs a read-only projection.) for Cedar City Utilities and its metering systems and billing applications. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
An authorized job reads the governed volume path while an unrelated principal is denied. This is suitable evidence for another condition (A team stores unstructured model files in an unmanaged notebook workspace folder instead of an access-controlled governed location.) after a different response (Create an appropriate Unity Catalog volume for non-tabular files with scoped access.). For Cedar City Utilities, it does not prove the required result: Consumers query the approved projection without receiving direct unauthorized access to restricted base columns.
The external table is queryable by approved users and storage access follows the governed location configuration. This is suitable evidence for another condition (A data engineer registers an external table over cloud storage that has no approved external location or storage credential.) after a different response (Create and use the supported Unity Catalog storage credential and external location governance path.). For Cedar City Utilities, it does not prove the required result: Consumers query the approved projection without receiving direct unauthorized access to restricted base columns.
A refresh produces the expected aggregate values and dashboards read the persisted result within the freshness SLA. This is suitable evidence for another condition (An expensive, frequently repeated aggregation is recalculated for every dashboard even though materialized results are acceptable.) after a different response (Evaluate a Unity Catalog materialized view with refresh behavior matched to freshness requirements.). For Cedar City Utilities, it does not prove the required result: Consumers query the approved projection without receiving direct unauthorized access to restricted base columns.