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

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 query returns all columns of the table for records where the age is 18 or older because of the condition 'age >= 18'. Therefore, records with an age value less than 18 will be omitted. This means that records will only be displayed normally if the age is greater than or equal to 18.

Discussion
dmovOption: A

Definitely A. It's greater than or equal to

divingbell17Option: A

A is correct. "greater than 17" is the equivalent to "equal or greater than 18"

c00ccb7Option: A

Because greater than 18 doesnt include 18 All columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.

Tamele001Option: E

Option E

Freyr

Incorrect because the condition specified is age >= 18, not age > 18. So, the answer is A.

sodereOption: E

18 not 17.

sodere

A is right.

vctrhugo

>= 18 (greather than 17)