Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam

Exam Certified Data Engineer Professional topic 1 question 98 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 98
Topic #: 1
[All Certified Data Engineer Professional Questions]

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?

  • 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.
  • 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.
  • 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.
  • D. All records from all columns will be displayed with the values in user_ltv.
  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
dmov
Highly Voted 10 months, 3 weeks ago
Selected Answer: A
Definitely A. It's greater than or equal to
upvoted 7 times
...
c00ccb7
Most Recent 4 months, 2 weeks ago
Selected Answer: 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.
upvoted 1 times
...
Tamele001
8 months, 3 weeks ago
Option E
upvoted 1 times
Freyr
6 months ago
Incorrect because the condition specified is age >= 18, not age > 18. So, the answer is A.
upvoted 2 times
...
...
divingbell17
10 months, 4 weeks ago
Selected Answer: A
A is correct. "greater than 17" is the equivalent to "equal or greater than 18"
upvoted 4 times
...
sodere
11 months, 1 week ago
Selected Answer: E
18 not 17.
upvoted 1 times
sodere
11 months, 1 week ago
A is right.
upvoted 3 times
...
vctrhugo
9 months, 3 weeks ago
>= 18 (greather than 17)
upvoted 3 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...