Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this 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?

    Correct Answer: A

    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
Jay_98_11Option: E

E is correct

ATLTennisOption: E

E is correct

kz_dataOption: E

Correct answer E

sturcuOption: E

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

Brian9Option: E

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

imatheushenriqueOption: E

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

PrashantTiwariOption: E

E is correct

AziLaOption: E

correct ans is E

8605246Option: E

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