SOL-C01 Question #23: Real Exam Question with Answer & Explanation

Question

You have two tables, `employees' and `departments'. The `employees' table contains employee information, including 'employee_id' and The `departments' table contains department information, including and department_name'. You want to create a view that combines data from both tables, showing employee name and their respective department name. Which of the following approaches are valid when creating this view using Snowflake?

Options

• ACreate a view using a standard 'JOIN' clause to combine the tables based on 'department_id'.
• BCreate a materialized view using a standard 'JOIN' clause, and ensure the view is automatically
• CCreate a secure view using a standard 'JOIN' clause to combine the tables, hiding the base table
• DCreate two separate views, one for 'employees' and one for 'departments', and then use a third
• ECreate a view using a 'LATERAL FLATTEN' function to join the tables based on 'department_id'.

Explanation

Options A and C are valid. A standard view (Option A) is a simple and effective way to combine data from multiple tables. A secure view (Option C) provides an extra layer of security by hiding the underlying table structures. Option B is not optimal because Materialized views are designed for improving query performance with pre-computed result sets, not to hide base table structures. Option D is incorrect; UNION is used to combine rows, not columns. Option E is incorrect; LATERAL FLATTEN is used for semi-structured data and is not applicable here.

No community discussion yet for this question.