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

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

Question #: 1
Topic #: 1

[All Databricks Certified Data Engineer Professional 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%

Off

Get Premium Databricks Certified Data Engineer Professional Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Pauline

3 months ago

B sounds plausible too, but I lean towards C.

upvoted 0 times

...

Marshall

3 months ago

I agree, C is the right choice!

upvoted 0 times

...

Melvin

3 months ago

Wait, why would age < 18 return nulls? That seems odd.

upvoted 0 times

...

Novella

4 months ago

Definitely not D, that would be too open!

upvoted 0 times

...

Delisa

4 months ago

I think option C makes the most sense here.

upvoted 0 times

...

Detra

4 months ago

I believe the query should return all columns, but I’m unsure if it will show nulls for age or just omit those records entirely.

upvoted 0 times

...

Herschel

4 months ago

I feel like option C makes sense because of the null values, but I’m not completely confident about how the ACLs play into that.

upvoted 0 times

...

Frank

4 months ago

I think I practiced a similar question where age was a condition, but I can't recall if it was greater than 18 or 17.

upvoted 0 times

...

Pearlie

5 months ago

I remember something about ACLs affecting data visibility, but I'm not sure how that applies to age filtering here.

upvoted 0 times

...

Thora

5 months ago

I've got a strategy - I'll focus on understanding the access control logic first, then I can evaluate how the age condition and data masking would apply based on the user's permissions.

upvoted 0 times

...

Major

5 months ago

I'm a bit confused by the different options. I'll need to think through each one and consider how the age filter and data masking would work in this scenario.

upvoted 0 times

...

Valentin

5 months ago

Okay, the key here is that the user executing the query is not part of the auditing group. So I'll need to think about how the data access rules might impact the query results.

upvoted 0 times

...

Melinda

5 months ago

Hmm, this looks like a tricky one. I'll need to carefully read through the question and table schema to understand the access control and data masking requirements.

upvoted 0 times

...

Erin

5 months ago

This seems straightforward, but I want to double-check my understanding. The user isn't in the auditing group, so I'm guessing the age filter will be applied and any records not meeting the condition will be omitted.

upvoted 0 times

...

Nada

5 months ago

Okay, I've got this. Information and analysis evaluations are based on the appropriateness and effectiveness of the methods used to manage the data. That's option A, so I'll go with that.

upvoted 0 times

...

Tamekia

5 months ago

I remember practicing a similar question, and I think the UCS VIC 12xx adapter plays a key role in handling failover.

upvoted 0 times

...

Weldon

5 months ago

I remember studying fraudulent purchases, but I'm uncertain if it applies specifically to misappropriated assets that were originally bought by the company.

upvoted 0 times

...

Mammie

2 years ago

Hmm, that makes sense too. It's a tough one, I'm still not sure.

upvoted 0 times

...

Natalie

2 years ago

I see where you're coming from, Lorrie. But I think it's actually A) All columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.

upvoted 0 times

...

Lorrie

2 years ago

I disagree, I believe the correct answer is C) All age values less than 18 will be returned as null values all other columns will be returned with the values in user_ltv.

upvoted 0 times

...

Mammie

2 years ago

I think the answer is B) All columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted.

upvoted 0 times

...