A table named `user_ltv` is used to create a view for data analysts across teams. Workspace users are organized into groups for ACL-based data access. The `user_ltv` table has the schema: - `email` (STRING) - `age` (INT) - `ltv` (INT) The following view is defined: ```sql CREATE VIEW user_ltv_no_minors AS SELECT email, age, ltv FROM user_ltv WHERE CASE WHEN is_member("auditing") THEN TRUE ELSE age >= 18 END ``` An analyst who is **not** in the `auditing` group runs: ```sql SELECT * FROM user_ltv_no_minors ``` What results will this query return? | Databricks Certified Data Engineer - Professional Quiz

A table named user_ltv is used to create a view for data analysts across teams. Workspace users are organized into groups for ACL-based data access.

The user_ltv table has the schema:

email (STRING)
age (INT)
ltv (INT)

The following view is defined:

CREATE VIEW user_ltv_no_minors AS
SELECT email, age, ltv
FROM user_ltv
WHERE 
  CASE 
    WHEN is_member("auditing") THEN TRUE 
    ELSE age >= 18 
  END

An analyst who is not in the auditing group runs:

SELECT * FROM user_ltv_no_minors

What results will this query return?

Exam-Like

Powered ByGPT-5

Databricks Certified Data Engineer - Professional

Get started today

Databricks Certified Data Engineer - Professional

Get started today