Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.