Question 550 A cross-account data recipient has been deactivated, but copies previously exported to the recipient's own storage may remain. What must the provider not claim? Revocation can stop subsequent governed data reads Revocation automatically deletes all historical extracts already copied elsewhere Sharing should follow least privilege Recipient status can be tracked and audited Explanation Correct Answer B:Revoking future access does not necessarily reach previously materialized copies under a recipient's control. Incorrect Answers A:A provider can disable recipient authorization for future access through supported sharing controls. C:A narrow share remains preferable to distributing broad provider credentials. D:Sharing governance can include recipient lifecycle tracking.
Question 551 A pipeline requires reading a governed table, writing a curated table and storing temporary files in a governed volume. What permissions should its effective principal have? Grant WRITE VOLUME and assume it also authorizes reading the source table and writing the target table Table SELECT and MODIFY on appropriate objects plus relevant volume WRITE and ancestor usage Metastore administration on all catalogs Only SELECT on source table for all operations Explanation Correct Answer B:These are distinct securables that must each be authorized according to the pipeline's actual actions. Incorrect Answers A:Volume privileges differ from SELECT on source tables and MODIFY on destination tables; each operation needs its specific grants. C:Global privilege is unnecessary for these scoped data operations. D:Input read access does not cover target writes or volume file creation.
Question 552 A new catalog is created, but some analysts can access its schemas while others cannot despite a broadly shared table SELECT grant. What should be checked? The schema display order in the browser Only the largest data file size Effective inherited usage grants and any catalog-workspace bindings Only notebook language settings Explanation Correct Answer C:Table SELECT can coexist with missing parent usage or workspace restrictions, producing different outcomes. Incorrect Answers A:UI ordering does not explain which principals may access it. B:Table size is not an authorization boundary. D:SQL or Python choice does not supply missing catalog traversal grants.
Question 553 A team wants to let an application read a table from a new job workspace while preserving a restriction against direct employee use in another workspace. What should be evaluated? Grant broad SELECT in the source catalog but omit workspace binding for the new consumer workspace Only the cloud object storage storage class Only the name of the application notebook Workspace binding for the catalog and the job principal's own access grants Explanation Correct Answer D:Both workspace membership of the catalog and the executing identity must permit the intended read. Incorrect Answers A:Table grants alone cannot bypass intended catalog workspace boundaries; both binding and principal privileges apply. B:Storage classes alone do not encode the catalog workspace access boundary. C:Notebook names do not enforce cross-workspace read permissions.
Question 554 A consumer using a SQL warehouse sees access denied on a shared view, while the provider's owner can query it. What should be verified rather than assuming the view is broken? The consumer's own effective share/view permissions and execution context The view title length Only cluster event timestamps Only the provider owner's notebook syntax Explanation Correct Answer A:Owner success does not establish recipient privileges; the failing identity must be evaluated directly. Incorrect Answers B:Object name length is not normally the cause of an explicit permission denial. C:Provisioning events do not establish view grants. D:Owner query success is not proof of consumer authorization.
Question 555 A row-filtered table is materialized into a new output by a high-privilege service identity. What is the appropriate data review? Assume the service identity sees the same rows as a restricted analyst despite having broader access Assume every new output inherits the original row filter by name Check which rows the service identity could read and who can access the resulting output Only change the query execution language Explanation Correct Answer C:Materialization may create a dataset with new access scope; policy evaluation must include the service principal and target permissions. Incorrect Answers A:A privileged materialization may include records outside the analyst’s row-filter view and must be reviewed under the materializing identity. B:A new table has its own data, grants and policies that cannot be assumed from the source. D:SQL/Python selection alone does not enforce output row restrictions.
Question 556 An engineer schedules a nightly access review and needs to detect privilege creep across a catalog. Which comparison is useful? Compare only explicit grants on one table and ignore inherited groups Compare Delta file counts without checking identities Compare only CPU metrics between nights Compare effective current grants and group membership with an approved least-privilege baseline Explanation Correct Answer D:Privilege drift is an authorization-state difference, not a compute utilization problem. Incorrect Answers A:Privilege creep may be inherited through parent securables or group membership, so direct-table grants are incomplete evidence. B:File count changes do not reveal who is authorized to read or modify assets. C:CPU utilization cannot identify unintended new SELECT or MODIFY grants.
Question 557 A user requests a temporary elevated data privilege for an incident investigation. How should the owner prevent the exception becoming permanent? Document scope and expiry, grant narrowly, and verify revocation after the case Grant public access to the table for the investigation Share a permanent service-account password with the user Grant metastore administrator forever to avoid follow-up Explanation Correct Answer A:Time-bounded access with an auditable lifecycle maintains least privilege around exceptional incidents. Incorrect Answers B:Public SELECT exceeds the identified temporary user scope. C:Shared credentials undermine traceability and revocation. D:A permanent broad role conflicts with temporary emergency needs.
Question 558 An analyst asks to export a restricted table to a public object-storage bucket for convenience. What should the data owner require? Public read ACL because exports are not governed Automatic exemption from auditing after export Only a different CSV delimiter An approved destination with equivalent access controls, auditability, and data minimization Explanation Correct Answer D:An export can escape catalog access controls, so destination governance must satisfy the same sensitive-data obligations. Incorrect Answers A:An exported dataset remains subject to confidentiality requirements. B:Audit requirements do not disappear because records leave a Databricks table. C:File formatting does not establish security at the destination.
Question 559 A regulated group requires a documented source-to-target lineage for a Spark job that also reads a third-party external API. The catalog lineage graph shows only table-to-table edges. What should the team do? Delete the source API logs Augment supported catalog lineage with external system provenance evidence Claim the graph proves no external APIs were involved Grant all analysts metastore administration Explanation Correct Answer B:Not every external API dependency is necessarily captured in table lineage; a complete compliance record may need supplementary evidence. Incorrect Answers A:Removing external evidence would make provenance less complete. C:Absence from recorded lineage is not reliable evidence that a dependency did not exist. D:Access elevation does not add missing provenance records.
Question 560 A table's column-level lineage shows a confidential input transformed into a derived metric. What should a steward evaluate before downgrading the metric classification? Only whether the SQL query ran quickly Only whether the derived table is smaller Whether the derivation can reveal sensitive information and what downstream consumers can access Only whether its column name avoids the word confidential Explanation Correct Answer C:A derived metric may remain sensitive depending on granularity, transformations and reidentification risks. Incorrect Answers A:Compute performance is not an information-disclosure assessment. B:Row count or storage size does not prove privacy of a derived value. D:Renaming a column does not establish safe declassification.