Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Professional 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?

Show Answer
Correct Answer: AD

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

6 comments
Sign in to comment
BrianNguyen95Option: A
Jun 8, 2024

Greater than 17

hpkrOption: A
Jun 12, 2024

option A is correct

Isio05Option: A
Jun 14, 2024

Surely, it's an A

MDWPartnersOption: A
May 29, 2024

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

imatheushenriqueOption: A
Jun 1, 2024

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.

FreyrOption: A
Jun 1, 2024

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