Answer-first summary for fast verification
Answer: Only members of the instructors group will have access to all student records, regardless of their active status. Non-members will only see records of inactive students.
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](https://docs.databricks.com/data-governance/table-acls/object-privileges.html#dynamic-view-functions).
Author: LeetQuiz Editorial Team
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?
A
Only members of the instructors group will have access to all student records, regardless of their active status. Non-members will only see records of inactive students.
B
Members of the instructors group will only see active student records. Non-members will only see inactive student records.
C
Members of the instructors group will only see active student records. Non-members will see null values for inactive student records.
D
Only members of the instructors group will have access to all student records. Non-members will see 'REDACTED' values for inactive student records.
E
Only members of the instructors group will have access to all student records. Non-members will see null values for inactive student records.
No comments yet.