Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam
Go to Exam
Question 149

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 auditing group executes the following query:

SELECT * FROM user_ltv_no_minors

Which statement describes the results returned by this query?

    Correct Answer: A

    The view definition includes a condition that filters records where the user's age must be greater than or equal to 18 for users who are not members of the 'auditing' group. Therefore, only records with an age of 18 or older will be included in the view for non-auditing users. This condition is correctly described in option A, which states that all columns will be displayed normally for records with an age greater than 17 (equivalent to age >= 18), and records not meeting this condition (age < 18) will be omitted.

Discussion
Isio05Option: A

Surely, it's an A

hpkrOption: A

option A is correct

BrianNguyen95Option: A

Greater than 17

FreyrOption: A

Correct Answer: A (>17) qual to (>=18). So, all records above 17 years will get in result and other records will be omitted.

imatheushenriqueOption: A

A. All columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted. Because the condition of age>=18 only is respected in option A.

MDWPartnersOption: A

Nope, A greater than 18 is 19. D is incorrect.