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

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

Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets.
Which statement describes a limitation of Databricks Secrets?

  • A. Because the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display the value in plain text.
  • B. Account administrators can see all secrets in plain text by logging on to the Databricks Accounts console.
  • C. Secrets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.
  • D. Iterating through a stored secret and printing each character will display secret contents in plain text.
  • E. The Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
fe3b2fc
3 months ago
Selected Answer: D
value = dbutils.secrets.get(scope="myScope", key="myKey") for char in value: print(char, end=" ") Out: y o u r _ v a l u e
upvoted 3 times
...
coercion
6 months, 1 week ago
Selected Answer: E
Only through REST API or CLI you can fetch the secret if you have valid token
upvoted 1 times
...
Er5
7 months, 2 weeks ago
E: https://docs.databricks.com/api/azure/workspace/secrets/listsecrets GET /api/2.0/secrets/list won’t list secrets in plain text. D: if print it without iterating it in a for loop the output is kind of encrypted where it is showing [REDACTED]. But, if I do it as shown in the screenshot, I'm able to see the value of the secret key. https://community.databricks.com/t5/data-engineering/how-to-avoid-databricks-secret-scope-from-exposing-the-value-of/td-p/12254 https://docs.databricks.com/en/security/secrets/redaction.html Secret redaction for notebook cell output applies only to literals. The secret redaction functionality does not prevent deliberate and arbitrary transformations of a secret literal.
upvoted 2 times
...
Lucario95
9 months ago
Selected Answer: E
Both D and E seems correct. They are poorly written thought because for D just printing the characters (not separated by spaces, newlines or something) would not work, while E if launched inside databricks workspace would not work neither.
upvoted 2 times
...
PrashantTiwari
9 months, 2 weeks ago
D is correct
upvoted 2 times
...
guillesd
9 months, 3 weeks ago
Selected Answer: D
D is for sure correct (tried it several times on a Databricks environment).
upvoted 2 times
guillesd
9 months, 3 weeks ago
Regarding E, it can list secrets (with scopes) but I am not sure it can list secret contents.
upvoted 1 times
...
...
DAN_H
9 months, 3 weeks ago
Selected Answer: D
D is correct
upvoted 3 times
...
spaceexplorer
10 months ago
Selected Answer: D
D is correct
upvoted 2 times
...
Def21
10 months ago
Selected Answer: E
At least E is a correct answer. B: You can't see secrets in Admin console. Only via REST API, CLI etc. C: Secrets are. not stored in Hive Metastore. D: I am not sure if iterating through secret character by character would work? E: This is at least correct. Using this.
upvoted 1 times
...
ranith
10 months, 2 weeks ago
B and E both seems to be correct: https://community.databricks.com/t5/data-engineering/how-to-avoid-databricks-secret-scope-from-exposing-the-value-of/td-p/12254/page/2
upvoted 1 times
...
Jay_98_11
10 months, 2 weeks ago
Selected Answer: D
For sure it's D
upvoted 2 times
...
hkay
11 months ago
Answer is E: /api/2.0/secrets/get { "key": "string", "value": "string" } The REST API can potentially expose secrets in plain text if a user with appropriate permissions (including access to both secrets/list and secrets/get) uses a personal access token.
upvoted 3 times
...
Patito
11 months ago
Selected Answer: D
Iterating through the secrets provides a way to see the secret's password.
upvoted 2 times
...
Enduresoul
1 year ago
D is correct, see https://community.databricks.com/t5/data-engineering/how-to-avoid-databricks-secret-scope-from-exposing-the-value-of/td-p/12254/page/2
upvoted 1 times
hkay
11 months ago
you didn't read the entire document, they are also using the get api to print the secret.
upvoted 1 times
...
...
aragorn_brego
1 year ago
Selected Answer: E
While Databricks Secrets are designed to secure sensitive information such as passwords and tokens, one limitation is that if a user's personal access token is compromised, and that token has the necessary permissions, the REST API could potentially be used to retrieve secrets. This means that the security of secrets is also dependent on the security of personal access tokens and the permissions assigned to them.
upvoted 3 times
...
AzureDE2522
1 year ago
E is the correct answer because it describes a limitation of Databricks Secrets. Databricks Secrets is a module that provides tools to store sensitive credentials and avoid accidentally displaying them in plain text. Databricks Secrets allows creating secret scopes, which are collections of secrets that can be accessed by users or groups. Databricks Secrets also allows creating and managing secrets using the Databricks CLI or the Databricks REST API. However, a limitation of Databricks Secrets is that the Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials. Therefore, users should still be careful with which credentials are stored in Databricks Secrets and which users have access to using these secrets.
upvoted 2 times
...
Hannah_13
1 year ago
Answer is D based on Udemy practice test
upvoted 2 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 ...