Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Professional Exam - Question 6


The security team is exploring whether or not the Databricks secrets module can be leveraged for connecting to an external database.

After testing the code with all Python variables being defined with strings, they upload the password to the secrets module and configure the correct permissions for the currently active user. They then modify their code to the following (leaving all other variables unchanged).

Which statement describes what will happen when the above code is executed?

Show Answer
Correct Answer: AE

When using Databricks secrets with the `dbutils.secrets.get` method, the library handles secrets in a secure manner by redacting the output to avoid unintentional exposure. Therefore, when `print(password)` is executed, it will print the string 'REDACTED'. Since the connection details and permissions were configured correctly, the connection to the external table should succeed. Thus, the statement describing the result will be that the connection to the external table will succeed and the string 'REDACTED' will be printed.

Discussion

9 comments
Sign in to comment
Brian9Option: E
Aug 14, 2023

https://learn.microsoft.com/en-us/azure/databricks/security/secrets/redaction Option E - which is selected answer seems correct.

sturcuOption: E
Oct 11, 2023

Correct: https://docs.databricks.com/en/external-data/jdbc.html

kz_dataOption: E
Dec 21, 2023

Correct answer E

ATLTennisOption: E
Jan 6, 2024

E is correct

Jay_98_11Option: E
Jan 13, 2024

E is correct

8605246Option: E
Aug 6, 2023

This option is correct, although the password won't be printed out, the connection will still succeed.

AziLaOption: E
Jan 21, 2024

correct ans is E

PrashantTiwariOption: E
Feb 8, 2024

E is correct

imatheushenriqueOption: E
Jun 5, 2024

E. The connection to the external table will succeed; the string "REDACTED" will be printed.