Question 320
A developer grants SELECT at the schema level and is surprised that newly created tables are queryable. Which test result would demonstrate that the intended data contract is met?
Explanation
Correct Answer
A newly created restricted table is not visible to the general analyst role. This is the most directly relevant verification because schema-level grants can propagate to child objects under the Unity Catalog model. A concrete acceptance check is: A newly created restricted table is not visible to the general analyst role. To reduce recurrence: Review inherited grants before applying schema-wide access.
Incorrect Answers
A table name and schema alone cannot establish operational trust for consumers. The reported failure instead depends on this fact: schema-level grants can propagate to child objects under the Unity Catalog model.
Incorrect metadata labels can drive unsafe discovery or ABAC behavior. That consideration does not remove the current constraint: schema-level grants can propagate to child objects under the Unity Catalog model.
Recorded data lineage exposes dependencies beyond a single source repository. In this situation, schema-level grants can propagate to child objects under the Unity Catalog model.