Question 530 An analyst queries `main.finance.customer_view` but receives an error that the principal lacks USE SCHEMA. A teammate grants SELECT on a different table. What is the problem? Any table SELECT automatically grants USE SCHEMA across the catalog The missing parent schema usage remains unresolved The query needs a larger driver heap The customer view must be rewritten in Python Explanation Correct Answer B:Table-specific SELECT on an unrelated object cannot supply required schema traversal to the intended view. Incorrect Answers A:Table grants do not universally supply all ancestor privileges. C:Authorization denial is not explained by driver memory. D:Changing the query language cannot replace the missing parent usage privilege.
Question 531 An engineer wants to make a governed table readable from two approved workspaces but not the third workspace sharing the same metastore. What setting should they examine? The catalog's explicit workspace binding choices and access mode The row count of the protected table Only a third workspace's notebook count Grant SELECT to all account users without restricting catalog workspace bindings Explanation Correct Answer A:Binding eligible workspaces allows governance boundaries independent of user-facing table names. Incorrect Answers B:Table size has no bearing on which workspace may query it. C:Notebook counts do not enforce catalog restrictions. D:Broad principal grants can expose the table from the third workspace even though the requirement excludes that workspace.
Question 532 An organization must retain audit evidence even when an analyst deletes a notebook containing the original query text. What is the stronger evidence source? Storage compression configuration Centralized retained audit and query execution history where collection supports the event The analyst's recollection of the notebook contents Rely only on live notebook revision history without retained audit event records Explanation Correct Answer B:Independent operational records are more durable than relying solely on mutable user notebook source. Incorrect Answers A:Compression settings are unrelated to query attribution. C:Memories do not provide reliable independently retained evidence. D:A notebook’s current revisions are not a substitute for durable recorded access and administrative events when artifacts are deleted.
Question 533 The finance catalog must be discoverable to all employees, but payroll tables must only be selectable by a restricted group. What is the correct principle? Hide the catalog from all employees to satisfy discoverability Grant SELECT on all finance tables to every employee Separate catalog discovery or usage from table-level SELECT permissions Give everyone SELECT on the payroll tables but hide their names in catalog search Explanation Correct Answer C:Namespace visibility and table data access can be governed at different levels. Incorrect Answers A:This conflicts with the explicit catalog discovery requirement. B:That would reveal payroll data beyond the restricted group. D:Catalog visibility is not an authorization boundary; broad SELECT still permits data access when object identifiers are known.
Question 534 A platform owner wants a sensitive field masked in both SQL queries and notebooks with no app-side rewrite in each client. What must be tested? Inspect only the number of source files instead of testing actual row-mask enforcement Test only the data steward account that has a masking exemption Test the masked column only in one administrator-owned notebook session Policy enforcement for each supported query path and representative user identity Explanation Correct Answer D:Centralized data masking must be validated where different authorized clients access the same asset. Incorrect Answers A:File counts do not demonstrate that column masks are applied across SQL and supported notebook query paths. B:A privileged exemption account can see full values and cannot validate the expected masked result for ordinary readers. C:One privileged user may be exempt; representative nonprivileged identities and query paths must be tested for policy effectiveness.
Question 535 A project creates several schemas with different privileges, and one service principal unexpectedly reads data in a sibling schema. What should be investigated first? The warehouse autoscaling limit Inspect only the service principal's direct table grants in the sibling schema Only the unrelated schema's physical storage size Inherited catalog-wide grants and effective group membership Explanation Correct Answer D:A broader ancestor or group grant can confer read permissions beyond a direct schema-local assignment. Incorrect Answers A:Compute scale does not create sibling schema read authorization. B:Direct grants may appear restrictive while inherited catalog privileges or group membership still authorize unintended reads. C:Storage size does not explain unexpected permissions.
Question 536 A data steward wants to prove that a failed access attempt to a restricted catalog was blocked rather than omitted from monitoring. What evidence should be reviewed? Review only current permission listings without the denial event at the incident time Only the source table's Delta history Only the object storage bucket size Relevant access-denial audit events plus the effective privileges and binding at the attempt time Explanation Correct Answer D:An authorization denial should be corroborated with the identity, denied securable, permission state and supported logging evidence. Incorrect Answers A:Current grants can differ from the historical state and cannot prove an actual access-denied event was recorded. B:Delta commit history traces table changes but not every failed read attempt. C:Storage size does not show attempted catalog access or denials.
Question 537 A table owner wants to change its owner to the finance platform group so governance is not tied to one employee. What design concern is addressed? Automatically rewriting all queries Removing the need for object access controls Increasing query concurrency Continuity and accountable group ownership for the governed securable Explanation Correct Answer D:A group-controlled governance boundary can survive individual staff changes when the supported ownership transfer is properly authorized. Incorrect Answers A:Ownership administration does not transform SQL definitions. B:Owner changes do not eliminate other principals' access checks. C:Ownership has no direct relation to warehouse concurrency allocation.
Question 538 A team needs to allow development engineers to write to a sandbox schema while production remains strictly read only. What grant strategy fits? Scope creation and MODIFY to sandbox objects and SELECT to approved production objects Disable catalog permission evaluation during development Use one metastore admin login for all developers Grant MODIFY to every production table Explanation Correct Answer A:Separately scoped grants protect production write boundaries while supporting development iteration. Incorrect Answers B:Turning off enforcement is not an acceptable environment separation strategy. C:Shared privileged identity undermines isolation and accountability. D:Production write permission is unnecessary and breaches the read-only requirement.
Question 539 A migration creates a new production schema and copies sensitive tables, but the old schema had tailored grants. What must be reconciled before cutover? Copy data first and assume privileges and masking rules automatically follow the new tables New object ownership, table privileges, parent usage and applicable policies Only old and new table names Only file count equality Explanation Correct Answer B:New namespaces may have different effective access controls and should be verified before applications switch references. Incorrect Answers A:New securables can have different ownership, inheritance and explicit policies; permissions need reconciliation before cutover. C:Matching names does not guarantee equivalent authorization. D:File counts may be useful data validation but do not establish governance policy.
Question 540 A service account used for automated lakehouse jobs is accidentally granted CAN MANAGE on many workspaces but only needs to read an input table and update one target. What improvement follows least privilege? Increase the task retry count Keep the broad grant to avoid checking access Convert every source table to CSV Remove unrelated workspace administrative grants and retain only required task and data rights Explanation Correct Answer D:Job execution and data operations should not require broad workspace management authority. Incorrect Answers A:More retries do not mitigate excessive permissions. B:Unnecessary administrator access is a security risk even if the job runs correctly. C:Changing table format does not constrain the service identity.