A data steward is applying tags to Unity Catalog securable objects to improve data discoverability. Which of the following statements about Unity Catalog tags is CORRECT?
Answer & explanation
Correct answer: B
WHY B: Each catalog created in Unity Catalog includes an INFORMATION_SCHEMA. Its tag views (INFORMATION_SCHEMA.TABLE_TAGS, INFORMATION_SCHEMA.COLUMN_TAGS, INFORMATION_SCHEMA.SCHEMA_TAGS, INFORMATION_SCHEMA.CATALOG_TAGS, and INFORMATION_SCHEMA.VOLUME_TAGS) let tags be retrieved programmatically with SQL. This is a primary mechanism for auditing, reporting, and automating governance based on metadata.
WHY NOT A: Tag inheritance in Unity Catalog applies when evaluating ABAC (attribute-based access control) policies. Tags do NOT inherit for browsing or metadata display: a tag on a catalog does not appear as a tag on its schemas or tables. The implicit inheritance is a policy-evaluation mechanism.
WHY NOT C: To apply a tag to a table, a user must own the object OR have the APPLY TAG privilege on the object AND USE SCHEMA on the parent schema AND USE CATALOG on the parent catalog. A non-owner therefore needs the three privileges together, not APPLY TAG by itself.
WHY NOT D: Tag keys are CASE-SENSITIVE in Unity Catalog. The keys 'PII' and 'pii' are two distinct tag keys and can both exist on the same object. This is an explicit constraint documented in the tags reference.
WHY NOT E: A single table can have a maximum of 1,000 column tags in total across its columns (not 10). In addition, each individual securable object (table, column, etc.) can have at most 50 tags assigned to it.