AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: A table named user_ltv is being used to databricks video

Question 1 Be Honest
« Back   Next data-engineer-professional Certification Question »
Answer

Full Certification Question

A table named user_ltv is being used to create a view that will be used by data analysts on various teams. Users in the workspace are configured into groups, which are used for setting up data access using ACLs. The user_ltv table has the following schema: email STRING, age INT, ltv INT The following view definition is executed: CREATE VIEW email_ltv AS SELECT CASE WHEN is_member ( 'marketing' ) THEN email ELSE 'REDACTED' END AS email , ltv FROM user_ltv ; An analyst who is not a member of the marketing group executes the following query: SELECT * FROM email_ltv Which statement describes the results returned by this query?