Question 27

You manage a Unity Catalog catalog named `sales_prod` that backs a self-service analytics environment. Business analysts complain that they cannot understand what the `gold.customer_churn` table and its `risk_score` column represent when they browse the lakehouse. You are asked to enrich the table so that descriptions surface in Catalog Explorer search results and in the workspace search bar, while ensuring that analysts who only have the `BROWSE` privilege (and not `USE CATALOG` or `USE SCHEMA`) can still read the descriptions. You run the following statements on a SQL warehouse: ```sql COMMENT ON TABLE sales_prod.gold.customer_churn IS 'Daily-refreshed churn predictions per customer, sourced from the ML pipeline.'; ALTER TABLE sales_prod.gold.customer_churn ALTER COLUMN risk_score COMMENT 'Model churn probability between 0.0 and 1.0; higher means greater churn risk.'; ``` Which statement correctly describes the outcome and the privilege requirements?

• AThe table comment is applied, but column comments must be set with `COMMENT ON COLUMN`; `ALTER TABLE ... ALTER COLUMN ... COMMENT` is invalid syntax, so the second statement fails.
• BBoth comments are applied; any user with the `BROWSE` privilege on the catalog can view them in Catalog Explorer and search, even without `USE CATALOG` or `USE SCHEMA`.
• CBoth comments are applied, but they are only visible to users who additionally hold `USE CATALOG` and `USE SCHEMA`; `BROWSE` alone does not expose comments.
• DThe comments are stored only in the Delta transaction log and are not indexed by workspace search; analysts must query `DESCRIBE EXTENDED` to read them.