Reddit

A data engineer is tasked with restricting access to the name column in a dynamic view definition to only the compliance team. The original view is defined as:

CREATE VIEW policy_view AS
SELECT name, policy_id, age
FROM policy

CREATE VIEW policy_view AS
SELECT name, policy_id, age
FROM policy

Which SQL query correctly implements this access restriction?

Real Exam

CREATE OR REPLACE VIEW policy_view AS
SELECT
  CASE 
    WHEN is_member('compliance') THEN name
    ELSE ''
  END AS name,
  policy_id,
  age
FROM policy;
```_

CREATE OR REPLACE VIEW policy_view AS
SELECT
  CASE 
    WHEN is_member('compliance') THEN name
    ELSE ''
  END AS name,
  policy_id,
  age
FROM policy;
```_

72.9%

CREATE VIEW policy_view AS
SELECT
CASE WHEN
member = 'compliance' THEN name
ELSE ''
END AS name,
policy_id,
age
FROM policy

CREATE VIEW policy_view AS
SELECT
CASE WHEN
member = 'compliance' THEN name
ELSE ''
END AS name,
policy_id,
age
FROM policy

16.9%

CREATE VIEW policy_view AS
SELECT name(IF 'compliance' in member), policy_id, age
FROM policy

CREATE VIEW policy_view AS
SELECT name(IF 'compliance' in member), policy_id, age
FROM policy

6.8%

CREATE VIEW policy_view("name": "compliance") AS
SELECT name, policy_id, age
FROM policy

CREATE VIEW policy_view("name": "compliance") AS
SELECT name, policy_id, age
FROM policy

3.4%

Databricks Certified Data Engineer - Professional

Get started today

Comments