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