Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can row-level security be correctly implemented in Databricks using dynamic views?
A
CREATE VIEW restricted_address AS SELECT cost, address FROM employees WHERE cost>=25000;
B
CREATE VIEW restricted_address AS SELECT cost, address FROM employees WHERE is_member(‘analyst‘) or address like %AUS%;
C
CREATE VIEW restricted_address AS SELECT cost CASE WHEN is_account_group_member(‘analyst‘) THEN address ELSE ‘RESTRICTED‘ END AS address FROM employees;
D
CREATE VIEW restricted_address AS SELECT cost CASE WHEN is_member(‘analyst‘) THEN address ELSE ‘RESTRICTED‘ END AS address FROM employees;
E
All of the above options signify row-level security in Databricks.
