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 42 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 42
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 marketing group executes the following query:

SELECT * FROM email_ltv -
Which statement describes the results returned by this query?

  • A. Three columns will be returned, but one column will be named "REDACTED" and contain only null values.
  • B. Only the email and ltv columns will be returned; the email column will contain all null values.
  • C. The email and ltv columns will be returned with the values in user_ltv.
  • D. The email.age, and ltv columns will be returned with the values in user_ltv.
  • E. Only the email and ltv columns will be returned; the email column will contain the string "REDACTED" in each row.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
AndreFR
3 months ago
Selected Answer: E
A, D incorrect because 2 columns email & ltv are returned. B incorrect because email will not always contain null values (unless email is null) The user is not a member of “marketing”, so 3 is the correct answer. If the user were a member of "marketing” group, correct answer would have been C
upvoted 1 times
...
Isio05
5 months, 2 weeks ago
Selected Answer: E
E, only email column is selected and is not allowed to be viewed by the user
upvoted 1 times
...
alexvno
1 year ago
Selected Answer: E
sure E
upvoted 2 times
...
ismoshkov
1 year ago
Selected Answer: E
E is correct
upvoted 2 times
...
chokthewa
1 year, 1 month ago
E is correct.
upvoted 1 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 ...