Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
The data engineering team has created a dynamic view defined as follows: CREATE VIEW students_vw AS SELECT * FROM students WHERE CASE WHEN is_member('instructors') THEN TRUE ELSE is_active IS FALSE END. What results can be expected when querying this view?
The data engineering team has created a dynamic view defined as follows: CREATE VIEW students_vw AS SELECT * FROM students WHERE CASE WHEN is_member('instructors') THEN TRUE ELSE is_active IS FALSE END. What results can be expected when querying this view?
Real Exam
Explanation:
The dynamic view is designed to grant full access to the underlying data only to members of the 'instructors' group, as the WHERE condition evaluates to TRUE for every record for them. Non-members are restricted to viewing only records of students who are inactive (is_active IS FALSE). This approach leverages dynamic view functions to implement row-level security based on group membership. Reference: Databricks Documentation on Table ACLs.