CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #42
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…
The correct answer is E. Only the email and ltv columns will be returned; the email column will contain the string. The view email_ltv is defined with column-level security using a conditional expression tied to group membership-likely something like IF(is_account_group_member('marketing'), email, 'REDACTED') AS email. The view selects only email and ltv (age is excluded from the view…
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:
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?
Exhibit
Options
- AThree columns will be returned, but one column will be named "redacted" and contain only null
- BOnly the email and itv columns will be returned; the email column will contain all null values.
- CThe email and ltv columns will be returned with the values in user itv.
- DThe email, age. and ltv columns will be returned with the values in user ltv.
- EOnly the email and ltv columns will be returned; the email column will contain the string
How the community answered
(44 responses)- A5% (2)
- B9% (4)
- C2% (1)
- D2% (1)
- E82% (36)
Explanation
The view email_ltv is defined with column-level security using a conditional expression tied to group membership-likely something like IF(is_account_group_member('marketing'), email, 'REDACTED') AS email. The view selects only email and ltv (age is excluded from the view entirely). When a non-marketing analyst queries SELECT * FROM email_ltv, they see only two columns: ltv with its actual values, and email containing a redacted placeholder string (such as 'REDACTED') rather than real email addresses. The age column is never returned because it is not selected in the view definition. This pattern implements column-level data masking at the view layer without requiring separate physical tables for each audience.
Topics
Community Discussion
No community discussion yet for this question.