Databricks Exam Databricks Certified Data Engineer Professional Topic 3 Question 35 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Professional exam

Question #: 35
Topic #: 3

[All Databricks Certified Data Engineer Professional Questions]

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?

AThe connection to the external table will fail; the string 'redacted' will be printed.

BAn interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the encoded password will be saved to DBFS.

CAn interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the password will be printed in plain text.

DThe connection to the external table will succeed; the string value of password will be printed in plain text.

EThe connection to the external table will succeed; the string 'redacted' will be printed.

Show Suggested Answer

Suggested Answer: E

This is the correct answer because the code is using the dbutils.secrets.get method to retrieve the password from the secrets module and store it in a variable. The secrets module allows users to securely store and access sensitive information such as passwords, tokens, or API keys. The connection to the external table will succeed because the password variable will contain the actual password value. However, when printing the password variable, the string ''redacted'' will be displayed instead of the plain text password, as a security measure to prevent exposing sensitive information in notebooks. Verified Reference: [Databricks Certified Data Engineer Professional], under ''Security & Governance'' section; Databricks Documentation, under ''Secrets'' section.

by Nickole at Jun 15, 2025, 02:40 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Engineer Professional Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Telma

2 days ago

This question seems similar to one we practiced where the secrets were involved. I think the connection should succeed if the password is correct.

upvoted 0 times

...

Domonique

8 days ago

I remember something about the secrets module, but I'm not sure if it will prompt for the password or just fail.

upvoted 0 times

...

Myrtie

13 days ago

This seems straightforward enough. I'll review the code and options, and then make my best guess based on my understanding of the secrets module.

upvoted 0 times

...

Kayleigh

19 days ago

I'm a bit confused by the options here. I'll need to make sure I fully grasp the expected behavior of the secrets module before I can confidently select an answer.

upvoted 0 times

...

Vi

24 days ago

Okay, I think I've got a handle on this. The key is understanding how the secrets module is supposed to interact with the password variable.

upvoted 0 times

...

Nobuko

29 days ago

Hmm, the use of the secrets module is interesting. I'll need to think through how it's supposed to work and what the expected behavior is.

upvoted 0 times

...

Linn

1 month ago

This looks like a tricky one. I'll need to carefully read through the code and options to understand what's happening with the secrets module.

upvoted 0 times

...

Melissa

4 months ago

I'm not sure, but I think it might be D.

upvoted 0 times

...

Darrin

4 months ago

I disagree, I believe the answer is C.

upvoted 0 times

...

Nydia

4 months ago

I think the correct answer is B.

upvoted 0 times

...

Johana

5 months ago

Option E is the way to go. The secrets module will 'redact' the password, so it won't be visible in the output. Security is important, but why can't they just make it easy for us, you know?

upvoted 0 times

Leanora

4 months ago

Yeah, I think it's better to have the password redacted for security reasons. It's a small inconvenience for a big security benefit.

upvoted 0 times

...

Alayna

4 months ago

I agree, option E seems like the safest choice. It's better to prioritize security over convenience.

upvoted 0 times

...

Margret

5 months ago

Haha, option C is hilarious! An 'interactive input box' to enter the password? That's like something out of a bad sitcom. I'm going with option A.

upvoted 0 times

...

Lindsey

5 months ago

I'm not sure about this one. It seems like the code is trying to access the password from the secrets module, but I'm not sure what will happen. Maybe option B or C is the right answer?

upvoted 0 times

Shala

3 months ago

I see your point, option C could also be a possibility. It's a tough choice between B and C.

upvoted 0 times

...

Judy

3 months ago

I'm not so sure about option B. I think option C might be the right answer. The password could be printed in plain text if the right password is provided.

upvoted 0 times

...

Ceola

3 months ago

I agree, option B seems like the most logical choice. The code is probably designed to prompt for the password and save it to DBFS if correct.

upvoted 0 times

...

Refugia

4 months ago

I think option B is the correct answer. An interactive input box will appear in the notebook and if the right password is provided, the connection will succeed.

upvoted 0 times

...