Databricks Exam Databricks-Certified-Professional-Data-Engineer Topic 1 Question 1 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam

Question #: 1
Topic #: 1

[All Databricks-Certified-Professional-Data-Engineer Questions]

A table named user_ltv is being used to create a view that will be used by data analysis 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:

An analyze who is not a member of the auditing group executing the following query:

Which result will be returned by this query?

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

BAll columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted.

CAll age values less than 18 will be returned as null values all other columns will be returned with the values in user_ltv.

DAll records from all columns will be displayed with the values in user_ltv.

Show Suggested Answer

Suggested Answer: A

Given the CASE statement in the view definition, the result set for a user not in the auditing group would be constrained by the ELSE condition, which filters out records based on age. Therefore, the view will return all columns normally for records with an age greater than 18, as users who are not in the auditing group will not satisfy the is_member('auditing') condition. Records not meeting the age > 18 condition will not be displayed.

by Daren at Mar 15, 2024, 10:18 AM

Limited Time Offer

25%

6 months ago

I think the answer is A.

upvoted 0 times

...