Question 140
Teams grant broad storage IAM access to every analyst even though they only need governed managed tables. What is the MOST appropriate targeted remediation?
Explanation
Correct Answer
Use Unity Catalog table grants rather than distributing raw managed-storage credentials. This is the most directly relevant remediation because direct object storage credentials bypass table-level governance boundaries. A concrete acceptance check is: Authorized analysts read the managed table without direct bucket access. To reduce recurrence: Audit storage credential access separately from table grants.
Incorrect Answers
File layout cannot provide strong skipping when workloads read every row and column. Here the important technical distinction is that direct object storage credentials bypass table-level governance boundaries.
Poor size estimates can lead to an unnecessarily expensive physical plan. That consideration does not remove the current constraint: direct object storage credentials bypass table-level governance boundaries.
Manual ZORDER assumptions may conflict with a liquid-clustered table's maintenance model. In this situation, direct object storage credentials bypass table-level governance boundaries.