Certified Data Engineer Professional Exam

Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam

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 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?

Three columns will be returned, but one column will be named "REDACTED" and contain only null values.

Only the email and ltv columns will be returned; the email column will contain all null values.

The email and ltv columns will be returned with the values in user_ltv.

The email.age, and ltv columns will be returned with the values in user_ltv.

Only the email and ltv columns will be returned; the email column will contain the string "REDACTED" in each row.

Correct Answer: E

The view definition uses a case statement to check if the user is a member of the 'marketing' group. If they are a member, it returns the actual email; otherwise, it returns 'REDACTED'. Since the analyst is not a member of the marketing group, querying the view will return the email column with the value 'REDACTED' for each row. Therefore, the query will return the email and ltv columns, with the email column containing the string 'REDACTED' in each row.

Discussion

alexvnoOption: E

sure E

ismoshkovOption: E

E is correct

Isio05Option: E

E, only email column is selected and is not allowed to be viewed by the user

chokthewaOption: E

E is correct.