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.
Question 491 A team tries to create a catalog but holds CREATE TABLE on a schema only. Why does the command fail? Delta transaction version history blocks catalog creation Grant CREATE TABLE on another schema and retry CREATE CATALOG Catalog creation uses a higher-level authorization than creating tables in an existing schema CREATE TABLE implies all account-wide creation rights Explanation Correct Answer C:CREATE TABLE does not entitle the principal to create a new catalog namespace. Incorrect Answers A:Delta table history is unrelated to metastore catalog creation privileges. B:Table creation privileges on an existing schema do not provide the metastore-level authority required to create a new catalog. D:Schema-local object rights do not grant unlimited catalog administration.
Question 492 A team creates a new schema in an authorized catalog. Which prerequisite privilege should be investigated rather than simply requesting ownership of the metastore? WRITE VOLUME in another schema The scoped permission to create schemas under the intended catalog MODIFY on a table in a sibling schema SELECT on one table in a different catalog Explanation Correct Answer B:Schema creation can be delegated at its containing catalog; metastore ownership is unnecessarily broad. Incorrect Answers A:Volume file writes do not create catalog namespaces. C:A table modification grant is not the permission to create schemas. D:Reading unrelated data is not an authorization to create a new schema.
Question 493 A data steward wants read-only access to metadata but not rows from a sensitive table. What is the governance distinction to preserve? Make the steward owner of all table data Use table discovery permissions to indirectly grant broad read access to sensitive rows Grant SELECT automatically whenever an object is discoverable Metadata visibility permissions must be separated from SELECT on the table data Explanation Correct Answer D:Object discovery should not be equated with authorization to retrieve sensitive records. Incorrect Answers A:Ownership is broader than metadata discovery. B:Metadata visibility can be granted independently of SELECT; adding data access would violate the requested read-only metadata posture. C:Granting SELECT would expose rows beyond the intended metadata-only scope.
Question 494 A platform administrator registers a read-only cloud path as an external location. Why is granting broad cloud IAM write permission an inappropriate shortcut? Unity Catalog does not use cloud storage credentials It exceeds the requested storage access and can bypass intended least-privilege boundaries Every external table requires access to the full bucket with write Cloud IAM policy has no effect on the data plane Explanation Correct Answer B:The underlying cloud credential and Unity Catalog privileges should both align to the permitted operations. Incorrect Answers A:External locations explicitly reference storage credentials, so cloud permissions are relevant. C:Storage permissions should be limited to necessary paths and actions. D:Cloud credential scopes can determine which storage operations are possible.
Question 495 A warehouse query fails under a principal who has SELECT on a table but no `USE CATALOG` permission. A teammate proposes using a different SQL syntax. What is the actual correction? Grant the required parent catalog usage or update effective principal access Grant SELECT again on the table but leave the parent catalog usage grant missing Grant USE SCHEMA on the parent schema but omit USE CATALOG Rerun the query with a two-part table name but do not change the principal’s catalog privileges Explanation Correct Answer A:Syntax changes cannot override a catalog usage check; the correct grant chain is needed. Incorrect Answers B:Table SELECT is necessary for data reads but does not substitute for USE CATALOG in the governed namespace hierarchy. C:The principal needs the relevant catalog and schema usage chain; schema-only usage does not bypass a denied catalog. D:A shorter name still resolves through a catalog; changing syntax cannot authorize catalog access that was denied to the principal.
Question 496 An engineer needs to share a dataset with a partner outside the Databricks account without copying static CSV attachments by email. Which governed capability should be evaluated? Granting the partner account administrator access Sending an entire metastore backup to the partner Delta Sharing with appropriately scoped shares and recipients Embedding cloud root credentials in an email Explanation Correct Answer C:Delta Sharing can expose governed datasets to approved recipients through a controlled sharing model. Incorrect Answers A:An external consumer does not require control of the provider account. B:A full metastore copy violates the requested scope and least privilege. D:Raw cloud administrator credentials expose unrelated data and bypass governance.
Question 497 A provider creates a Delta Sharing share but the external recipient should see only one approved table. What should the provider verify? The partner receives account-wide metastore credentials The share contains every table in the provider catalog All analysts can change recipient identities without controls The share includes only the approved object and recipient permissions are scoped Explanation Correct Answer D:Share membership and recipient assignments determine the actual data exposed through the governed exchange. Incorrect Answers A:Recipient-specific sharing is intended to avoid privileged administrative credentials. B:Including unrelated tables exceeds the agreed scope. C:Uncontrolled recipient administration would undermine external sharing governance.
Question 498 A source table contains customer identifiers and contact details, but the sharing agreement permits only aggregated revenue by region. Which release design meets the constraint? Export the raw table to an unprotected public bucket Share the raw source and ask the partner not to query PII Publish a governed aggregate view or materialized output with only approved measures Grant SELECT on the entire raw catalog Explanation Correct Answer C:A constrained published dataset avoids exposing detailed personal records not covered by the sharing agreement. Incorrect Answers A:Public storage would defeat the sharing controls and data minimization. B:Voluntary restrictions do not enforce the explicit data-minimization requirement. D:Broad catalog read access exceeds the approved aggregate scope.
Question 499 A team needs to revoke an external partner's access to newly shared datasets after contract expiry. What should the owner act upon? The recipient and share authorization in the governed sharing configuration Only the source Delta file names Remove one table SELECT grant while leaving the recipient's sharing access active Every unrelated internal table owner Explanation Correct Answer A:Revocation should target the specific partner entitlement rather than relying on copies being forgotten. Incorrect Answers B:Renaming source files is not a governed recipient revocation strategy. C:Partner access to shared datasets is governed through the share/recipient configuration; unrelated local grants may not revoke sharing. D:Other internal assets need not be modified to revoke this recipient.
Question 500 A share recipient asks which datasets are available to them, but the provider wants no exposure to administrative catalogs. Which access model is suitable? Ownership of all provider notebooks Recipient-scoped Delta Sharing discovery of the approved shared objects Unrestricted access to provider cloud storage credentials Full metastore account admin rights for the recipient Explanation Correct Answer B:Recipients can discover only the datasets the provider makes available through the sharing arrangement. Incorrect Answers A:Notebook ownership does not represent the right level of shared dataset access. C:Cloud root-style credentials bypass the curated share boundary. D:Broad administration exceeds the recipient's data consumption role.