Câu 95: Databricks Certified Data Engineer Professional

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 INTThe 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_minorsWhich statement describes the results returned by this query?

1. 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. — đáp án hiện tại
2. B. All age values less than 18 will be returned as null values, all other columns will be returned with the values in user_ltv.
3. C. All values for the age column will be returned as null values, all other columns will be returned with the values in user_ltv.
4. D. All records from all columns will be displayed with the values in user_ltv.
5. E. All columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.