Question 460 An ETL service principal must append new records to one existing target table while analyst identities should remain read only. Which grant is pertinent to the ETL writer? CREATE CATALOG on the metastore MODIFY on the target table plus applicable traversal and read privileges Only USE SCHEMA on the parent MANAGE on every table in the catalog Explanation Correct Answer B:Data modification operations require table write authorization; the service account should receive it only for the intended target. Incorrect Answers A:Creating catalogs is not required to append to an existing table. C:Schema traversal does not independently permit inserting or updating rows. D:Catalog-wide administration is excessive for one pipeline writer.
Question 461 A project team needs permission to create new managed tables inside one existing schema, without rights to create catalogs or change metastore policy. What should be granted? CREATE TABLE on the intended schema with required usage MANAGE on all sibling schemas SELECT on a sample existing table only CREATE CATALOG on the metastore Explanation Correct Answer A:The creation privilege can be scoped to the schema where new managed tables are permitted. Incorrect Answers B:Administrative authority over other schemas is unnecessary. C:Reading one table does not authorize creating a new table. D:Metastore catalog creation is a wider administrative capability than schema-local table creation.
Question 462 Two departments need independent ownership and object namespaces while the organization uses a common Unity Catalog metastore. Which construct is appropriate? Disabling workspace authentication Separate catalogs with appropriately delegated administrators Separate notebook cell labels only Two identical table names in the same schema Explanation Correct Answer B:Catalog boundaries offer clear namespaces and delegated governance for department assets. Incorrect Answers A:Removing identity controls would undermine the requested separation. C:Code presentation labels do not create independent governed namespaces. D:The same schema cannot contain conflicting table names as an isolation model.
Question 463 A principal can run a job notebook but receives access denied when querying its production input table under Unity Catalog. What is the correct investigation? Delete the catalog and rebuild it Assume notebook run access grants all data permissions Change the task timeout to one hour Check the job run-as identity and the table privileges of that principal Explanation Correct Answer D:Job execution context and table authorization are distinct; the effective principal must have the necessary data grants. Incorrect Answers A:Deleting governed metadata would not fix missing identity grants safely. B:Execution of a notebook does not confer access to every catalog object the notebook references. C:An authorization error is not caused by an ordinary task duration limit.
Question 464 A production pipeline authenticates with a named engineer account. The engineer changes teams and access is revoked, causing failures. Which governance improvement is best? Use a designated service principal with scoped grants and managed credentials Give the engineer permanent global ownership Grant account admin to every engineer Copy passwords into every notebook cell Explanation Correct Answer A:Nonhuman workloads should use a stable accountable principal whose privileges are independent of personnel changes. Incorrect Answers B:Retaining unnecessary privileges for a departed team member is inappropriate. C:Broad global administration is not required for the pipeline. D:Hardcoding credentials distributes sensitive authentication material and creates rotation risk.
Question 465 An engineer wants to give analysts permission on every future table in one catalog but no ability to create or modify objects. What should the owner investigate? Give every analyst CREATE EXTERNAL LOCATION Make every analyst the metastore administrator Grant MODIFY on every existing table Appropriately scoped inherited or future-applicable SELECT permissions with usage Explanation Correct Answer D:Access can be managed at a containing schema or catalog boundary rather than manually adding redundant table grants, subject to the supported inheritance rules. Incorrect Answers A:External location creation concerns storage governance rather than reading current and future tables. B:Metastore administration is far broader than reading catalog data. C:Write permission would exceed the analysts' needs and does not establish read-only intent.
Question 466 An organization uses a shared Unity Catalog metastore, but a sensitive catalog must only be accessible from the regulated workspace. What governance capability should be considered? Rename the catalog to signal that its contents are regulated but leave privileges unchanged Granting all users SELECT then relying on policy documents Increasing the warehouse size in the regulated workspace Catalog workspace bindings in an isolation mode suited to the requirement Explanation Correct Answer D:Workspace binding can restrict which workspaces may access a catalog independently of object-level permissions. Incorrect Answers A:Naming communicates intent but does not enforce dataset access restrictions on regulated content. B:Broad access grants conflict with the required enforced workspace restriction. C:Compute size is not a control over other workspaces' catalog access.
Question 467 A catalog has a workspace restriction, and a user holds SELECT and usage grants but works in a workspace not included in the binding. Why is the query denied? The SELECT grant is necessarily malformed The table must first be optimized The workspace binding independently restricts catalog access Increase SQL warehouse capacity to bypass the workspace binding Explanation Correct Answer C:Object-level privileges do not override an incompatible catalog-to-workspace binding. Incorrect Answers A:The query may fail even with a valid object grant because workspace access is another enforced boundary. B:Delta file layout does not bypass workspace governance restrictions. D:Compute sizing does not override catalog workspace bindings even when the principal holds SELECT and namespace USAGE.
Question 468 An organization stores table data at a cloud path and wants its Unity Catalog metadata and data lifecycle to be controlled by the platform. Which ownership model generally fits? A managed Unity Catalog table in configured managed storage A local temporary view in a single notebook session A Git repository containing output parquet files An external table whose storage deletion is always guaranteed on DROP Explanation Correct Answer A:Managed table storage and lifecycle are handled under the catalog's managed table controls, unlike external location ownership arrangements. Incorrect Answers B:A session view does not provide durable managed table storage. C:A source repository is not the catalog-managed table lifecycle mechanism. D:External table metadata removal does not automatically imply ownership of the underlying files.
Question 469 A team has already organized files at an approved cloud storage path and needs them registered without having Unity Catalog take over their lifecycle. Which type of table fits? A managed table that always preserves files when dropped An external table referencing an approved governed storage location Create a managed table over the files and let Databricks own their storage lifecycle A temporary global view as the only persisted object Explanation Correct Answer B:External tables reference existing cloud files while maintaining a metadata boundary separate from physical data lifecycle. Incorrect Answers A:Managed and external ownership semantics differ and should not be treated interchangeably. C:Managed tables are not the correct mechanism when external file placement and lifecycle remain controlled outside Unity Catalog. D:A global temporary view does not register a durable governed external dataset.
Question 470 A data steward drops an external Unity Catalog table but another authorized system still needs its underlying files. What is the important expected distinction? The metastore must delete all catalogs in the account DROP TABLE is always the same as recursively deleting its cloud container Dropping external table metadata does not inherently delete external storage data A warehouse restart restores the dropped table definition automatically Explanation Correct Answer C:The external table registration and underlying cloud files have separable lifecycles. Incorrect Answers A:Removing one table does not require changing unrelated catalogs. B:Automatic deletion of external storage files is not the general external-table lifecycle contract. D:Compute restarts do not serve as authoritative metadata recovery.