Question 480 Regional sales representatives should see only their assigned territory records from a shared governed table. What governance control most directly addresses row visibility? A row filter on the protected table based on authorized context One global SELECT grant with no filter Only a column comment on territory Apply a column mask to the territory field while returning all rows Explanation Correct Answer A:Row filters can restrict visible records at query time according to implemented policy logic. Incorrect Answers B:Broad unfiltered access would not enforce regional record restrictions. C:Comments document a field but do not filter the data returned. D:Column masking can hide or transform a field, but does not restrict which territory records the query returns.
Question 481 A developer wants to implement a row filter that matches each caller to approved regions. What key design feature must the policy correctly incorporate? A hardcoded allow-all condition An unrelated warehouse shutdown setting A trustworthy identity-to-region mapping used by the filter function An arbitrary region selected in a dashboard text box Explanation Correct Answer C:The data visibility boundary depends on the actual authenticated principal and permitted regions, not a free-form session label. Incorrect Answers A:An always-true predicate defeats the policy's restriction. B:Compute termination does not determine row-level authorization. D:A user-controlled input cannot independently authorize records outside the user's scope.
Question 482 A governance team defines a reusable access policy that should apply consistently to all columns labeled with a particular governed classification tag. Which approach is relevant? Independent manual edits to notebook print statements Renaming each sensitive column without controls Attribute-based access control policies using governed tags, where supported A scheduled JOBS retry for every query Explanation Correct Answer C:ABAC can attach policy logic to governed data attributes so centrally applied rules extend to tagged assets. Incorrect Answers A:Notebook print logic can be bypassed by other readers and is not central access governance. B:Names alone do not enforce data access policy. D:Retries do not apply classification-based access policies.
Question 483 A column is newly tagged as confidential, and an applicable account-wide ABAC policy uses that governed tag. What should the team validate? Assume the confidential tag changes SQL column values without an applicable policy That subsequent applicable reads enforce the expected mask or filter behavior That all catalog users receive ownership privileges Check only that a classification tag appears in the catalog UI Explanation Correct Answer B:The effective policy and tag match should be confirmed by testing principals with distinct permissions. Incorrect Answers A:Classification metadata alone does not enforce masking; the relevant ABAC policy must actually apply and be tested. C:Tag-based restrictions should not be replaced with broader ownership. D:Tag visibility is not evidence that the governed masking/filtering decision is enforced for affected reads.
Question 484 A team creates a free-text data classification note, but its security plan depends on centrally enforced tag-based ABAC. What should be corrected? Use governed tags and validate their policy associations Skip the policy test because the word confidential appears Grant broad SELECT to compensate for uncertainty Assume all descriptive comments are access policies Explanation Correct Answer A:A governed classification control requires the tag type and policy enforcement supported by the governance platform. Incorrect Answers B:An ordinary label is not proof that any row or column restriction is active. C:Broader access makes classification requirements harder to satisfy. D:Metadata descriptions alone do not enforce authorization.
Question 485 A sensitive payroll table uses a row filter, but a user opens a direct SQL editor instead of the original reporting notebook. What outcome should an enforced table policy provide? The same applicable row restriction regardless of the querying interface Automatic conversion of the row filter to a notebook comment Unconditional global table ownership Unfiltered records because the query editor is different Explanation Correct Answer A:Data-layer governance must apply when permitted clients query the table, not only in one application's code path. Incorrect Answers B:A comment is not a live data filter. C:Ownership is not necessary to obtain filtered read access. D:Changing clients should not bypass an enforced data-layer row policy.
Question 486 A security architect wants temporary contractor access to selected tables, with automatic revocation at the end of a project. What is the proper operational control? Group-based scoped grants with a managed, time-bounded membership lifecycle Publicly accessible external storage paths Permanent metastore administrator access Hardcoded shared service-principal tokens distributed by email Explanation Correct Answer A:Granting relevant group privileges and expiring identity membership can enforce least privilege without permanent direct exceptions. Incorrect Answers B:Public paths violate the premise of selected governed access. C:Long-lived global administration far exceeds limited contractor table access. D:Shared credentials undermine accountability and revocation.
Question 487 An operations team wants to learn who queried a sensitive Delta table during a suspected access incident. What evidence source is appropriate? Relevant Databricks audit and query history evidence with authorized retention Only file compression ratios Check current table grants without reviewing the historical query-access records Only table row counts before and after the incident Explanation Correct Answer A:Governance audit data and query records can help identify principal activity within supported collection scope. Incorrect Answers B:Compression statistics do not establish access identities. C:Current grants show potential access but not which user actually queried the table during the incident window. D:Row counts do not reliably identify who read the table.
Question 488 A security team needs evidence of a grant change that permitted broader table reads. Which audit event class should be investigated? Review only current table privileges without examining the historical grant and audit trail Review only SQL warehouse utilization during the suspected exposure Privilege or ownership change records on the affected securable Inspect only current table data and infer the history of its access grants Explanation Correct Answer C:Grant and ownership events reveal governance modifications that may explain the new access. Incorrect Answers A:Current grants can differ from the permissions in force when data exposure happened and cannot show which grant event broadened access. B:Compute usage cannot establish which principal changed a catalog grant or when access widened. D:Data content alone does not reveal the earlier authorization change or actor captured by governance audit records.
Question 489 A security administrator sees that a former contractor still has effective table access through a nested group after their direct grant was revoked. What is the right next action? Reconcile effective group memberships and inherited privileges before declaring revocation complete Delete all catalogs to guarantee no data is accessible Assume removing one direct grant always removes all access Revoke the direct grant again without investigating inherited group access Explanation Correct Answer A:Effective access is the combined result of direct and group grants; removing one explicit permission may be insufficient. Incorrect Answers B:Global deletion is inappropriate for a targeted entitlement error. C:The principal may still inherit permissions from group membership. D:A duplicate direct revoke cannot remove authorization still received through effective group membership.
Question 490 A data owner wants to delegate permission management for one table without giving an analyst control over entire catalogs. What scope should be considered? Warehouse auto-termination settings The table's supported MANAGE/ownership grant boundary, subject to governance policy Account-wide administrator role for the analyst Every table in all other workspaces Explanation Correct Answer B:Local governance delegation should be restricted to the relevant securable rather than broad metastore administration. Incorrect Answers A:Compute lifecycle settings do not delegate data privileges. C:Account administration is not necessary for managing a single table. D:Unrelated objects should remain outside the delegation.