Databricks Data Engineer Associate · Free practice question 8 of 12
SHOW GRANTS on Unity Catalog objects
An auditor at Parnell Bank wants to see which users and groups hold privileges on the Unity Catalog table risk.gold.exposures. Which statement lists them?
- A.SHOW GRANTS ON TABLE risk.gold.exposures
- B.SHOW TABLES IN risk.gold
- C.SELECT * FROM risk.gold.exposures WITH GRANTS
- D.DESCRIBE HISTORY risk.gold.exposures
Show answer and explanation
Correct answer: A. SHOW GRANTS ON TABLE risk.gold.exposures
Why: SHOW GRANTS ON a securable lists the principals and the privileges they hold on it. SHOW TABLES lists the tables in a schema, WITH GRANTS is not valid query syntax, and DESCRIBE HISTORY lists the table's write operations rather than its permissions.
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
- Transferring object ownership
- Compute policies for cluster governance
- ALTER TABLE ADD COLUMNS on Delta
- Spark lazy evaluation transformations vs actions