CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #42: Real Exam Question with Answer & Explanation

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?

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

Explanation

The code creates a view called email_ltv that selects the email and ltv columns from a table called user_ltv, which has the following schema: email STRING, age INT, ltv INT. The code also uses the CASE WHEN expression to replace the email values with the string "REDACTED" if the user is not a member of the marketing group. The user who executes the query is not a member of the marketing group, so they will only see the email and ltv columns, and the email column will contain the string "REDACTED" in each row.

No community discussion yet for this question.