Databricks-GenAI-Assoc Governance — All Questions With Answers

GRANT USAGE ON CATALOG main TO `finance_team`;
GRANT SELECT ON TABLE main.sales.data TO `finance_team`;
GRANT SELECT ON TABLE main.sales.summary TO `finance_team`;
-- User attempts to join the two tables in a query:
SELECT * FROM main.sales.data d JOIN main.sales.summary s ON d.id = s.id;

CREATE TABLE main.finance.reports AS SELECT * FROM raw_data;
GRANT SELECT ON TABLE main.finance.reports TO `analyst_group`;
-- Later, a user drops the table and re-creates it.
-- The analyst group can no longer query the table.

GRANT SELECT ON TABLE main.sales.data TO `analyst_group`;
GRANT SELECT ON TABLE main.sales.data TO `manager_group`;
REVOKE SELECT ON TABLE main.sales.data FROM `analyst_group`;