Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
The following code snippet is intended to create a view named shares_view with two columns: price (integer) and quantity (integer). The price column should only be visible to users who are members of the auditor group but not the compliance group. Which of the following options correctly completes the code?
CREATE VIEW shares_view AS
SELECT
_______________________________________
quantity
FROM shares;