Databricks Data Engineer Associate · Free practice question 9 of 12
Transferring object ownership
The owner of the Unity Catalog table ops.gold.kpis at Tarrant Foods is leaving the company, and the team wants the group platform_admins to become the table's owner. Which statement does this?
- A.GRANT OWNERSHIP ON TABLE ops.gold.kpis TO `platform_admins`
- B.ALTER TABLE ops.gold.kpis OWNER TO `platform_admins`
- C.GRANT ALL PRIVILEGES ON TABLE ops.gold.kpis TO `platform_admins`
- D.ALTER TABLE ops.gold.kpis SET TBLPROPERTIES ('owner' = 'platform_admins')
Show answer and explanation
Correct answer: B. ALTER TABLE ops.gold.kpis OWNER TO `platform_admins`
Why: In Unity Catalog, ownership of an object is transferred with ALTER ... OWNER TO followed by the new principal, which can be a group. GRANT OWNERSHIP is not Databricks SQL syntax, ALL PRIVILEGES grants privileges without changing the owner, and ownership is not controlled by a table property.
More free Databricks Data Engineer Associate questions
- Delta shallow vs deep clone
- Auto Loader schema hints
- Reading notebook task parameters
- collect_set vs collect_list aggregation
- Triggered vs continuous pipeline mode
- Job maximum concurrent runs
- Job task timeout setting
- SHOW GRANTS on Unity Catalog objects
- Compute policies for cluster governance
- ALTER TABLE ADD COLUMNS on Delta
- Spark lazy evaluation transformations vs actions