Question 510 A regulated environment wants to show that a sensitive table has not been queried by unauthorized groups during an audit window. What evidence approach is most defensible? Infer authorization from table size Correlate effective grants with retained audit/query events and known logging coverage Review only scheduled dashboard query jobs, omitting ad-hoc SQL and notebook access events Clear all logs after the review to reduce cost Explanation Correct Answer B:Access review requires both authorization state and observed activity evidence, with explicit logging limitations. Incorrect Answers A:Storage size does not reveal the principals who ran queries. C:A lack of scheduled queries cannot prove no unauthorized table read happened; query/audit events and effective grants must be considered. D:Deleting audit evidence weakens traceability and cannot prove compliant access.
Question 511 An incident responder sees a SELECT grant added by an owner just before an unexpected data export. What should be correlated to identify exposure? Only the target table's row-count delta Use only the latest table owner listing without historical events and query attribution Review only the present SELECT grants and ignore the historical grant and query events Grant event, export query history, executing identity and target data objects Explanation Correct Answer D:A coherent access incident timeline links authorization changes to actual data movement by principals. Incorrect Answers A:Exports can read data without modifying the table row count. B:Current ownership cannot establish who granted access or which identity executed the export at the relevant time. C:Current permissions cannot show which identity exported data after the earlier grant or when the exposure occurred.
Question 512 An organization runs workspaces in different business units under one metastore. A platform owner wants a consistent masking policy without embedding conditions in every notebook. What architectural principle applies? Centralize policy at governed data assets rather than user notebook code Rename sensitive columns in each workspace Place identical Python if statements in all notebooks Apply per-notebook SQL CASE redaction without a centrally governed policy Explanation Correct Answer A:Data-layer enforcement helps ensure that approved identities encounter the same applicable masking controls across clients. Incorrect Answers B:Naming conventions do not guarantee mask enforcement. C:Copying application logic is easier to bypass through other query paths. D:Notebook-specific transformations can be bypassed through other query paths; central policy belongs on governed assets.
Question 513 A privacy analyst has a contractual reason to read anonymized trends but must not see individual employee records. Which governed dataset design fits? A restricted aggregate dataset with policies preventing access to individual source rows Full raw table SELECT with a verbal promise not to inspect rows Global schema ownership to allow queries An unencrypted CSV attached to an email Explanation Correct Answer A:Data minimization is better enforced by curated aggregates and source permissions than by relying on consumer restraint. Incorrect Answers B:Direct unrestricted access conflicts with the specified privacy boundary. C:Ownership grants unnecessary administrative powers. D:Uncontrolled extracts increase exposure and are not governed analytics access.
Question 514 A data steward requests that analysts be able to inspect table quality descriptions but not mutate classification tags. Which responsibility should be separated? Creating dashboards from SQL queries Reading metadata from permission to change governed classification metadata Declaring every analyst a metastore admin Use schema comments as the sole source of information about SQL warehouse query execution Explanation Correct Answer B:Governed tag modifications should be limited to authorized custodians rather than every catalog browser. Incorrect Answers A:Dashboard creation does not necessarily require governance tag administration. C:Metastore administration is much broader than observing descriptions. D:Comments are static documentation; query history and audit events are needed to establish who queried the data.
Question 515 An organization marks data as confidential using a governed tag, but a downstream copy is written into an untagged new table. What risk should the pipeline owner assess? Whether classification and policy coverage were preserved for the derived object Assume classification tags automatically enforce row filters and masking on all derived copies That SELECT becomes unnecessary for downstream queries That enabling retries will attach governed tags Explanation Correct Answer A:A newly created asset may need its own governance classification and access rules; upstream tags cannot be assumed to follow every copy. Incorrect Answers B:Classification metadata alone does not guarantee that separate downstream securables inherit the intended policy expression. C:Copying data does not eliminate table read authorization. D:Workflow retries do not implement metadata propagation and policy review.
Question 516 A table with personal data is read through a service principal that has unmasked access, and the output is written to a broadly accessible downstream table. What is the core governance issue? Downstream data exposure may exceed the source policy despite an authorized service principal Query performance becomes universally slow because of unmasking The output is automatically as restricted as the source in all circumstances Job owners must always use personal administrator credentials Explanation Correct Answer A:Governance must account for resulting materialized data and who can read it, not only the source query principal. Incorrect Answers B:Mask state alone does not establish universal performance behavior. C:A new materialized object has its own classification and grants that must be checked. D:Personal credentials would worsen accountability and privilege scope.
Question 517 A data engineering group can read a volume directory but gets denied when attempting to overwrite a checkpoint file. Which distinction explains the error? Table SELECT authorizes all volume writes READ VOLUME does not itself grant WRITE VOLUME Changing the file extension enables the missing privilege Notebook workspace edit permission authorizes all storage writes Explanation Correct Answer B:The separate volume privileges differentiate file consumption from modification. Incorrect Answers A:Table privileges do not replace volume modification access. C:Filename format does not resolve authorization. D:Notebook code editing is not a blanket Unity Catalog data-path grant.
Question 518 An engineer is asked to prove that a service principal has only the minimum required data privileges for a production job. Which review is most complete? Review only the notebook owner and infer the principal’s effective UC privileges Inspect only cluster membership rather than effective catalog grants Inspect effective direct/group grants, job run identity, source reads, and target writes List catalog names without examining effective group grants and the job execution identity Explanation Correct Answer C:Least privilege depends on the actual identity and every data operation the job performs, including inherited grants. Incorrect Answers A:Notebook ownership is different from table/volume privilege inheritance and cannot establish least privilege to governed assets. B:Compute access is a separate control and does not prove the principal’s effective object privileges are minimal. D:A catalog inventory cannot establish least privilege; actual source read and target write grants must be evaluated for the runtime principal.
Question 519 A developer accidentally publishes a full secret value in a notebook output and wants governance to prevent a recurrence. Which preventive design is appropriate? Use managed secret retrieval and avoid printing or logging credential values Delete the visible output cell but leave the leaked credential active Grant access to all analysts so sharing is not a problem Copy the secret into more notebook cells for availability Explanation Correct Answer A:Credentials should be obtained through approved secret management and kept out of visible output and logs. Incorrect Answers B:Removing one rendered copy cannot revoke an exposed secret or prevent its use by someone who already obtained it. C:Expanding access does not mitigate credential disclosure. D:More copies increase the likelihood of inadvertent exposure.
Question 520 A scheduled pipeline uses a bearer token stored in plain text inside a committed Git file. What is the corrective action? Delete the committed source file but leave the exposed bearer token active Ignore the token because the repository is private Put the same token into an even more widely shared notebook Revoke and rotate the exposed token and move credential delivery into approved secret management Explanation Correct Answer D:Treat committed credentials as compromised and prevent future storage in source control. Incorrect Answers A:Removing a file from the current branch does not revoke a credential that may already be copied into repository history. B:Private repositories can still be copied, accessed or later misconfigured; plaintext secrets remain at risk. C:Further distribution increases exposure rather than correcting it.