Discuss Databricks Databricks Certified Data Analyst Associate Exam Topic 6 Question 7

A data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.

Which of the following approaches can the analyst use to complete the task?

AEdit the Owner field in the table page by removing their own account

BEdit the Owner field in the table page by selecting All Users

CEdit the Owner field in the table page by selecting the new owner's account

DEdit the Owner field in the table page by selecting the Admins group

EEdit the Owner field in the table page by removing all access

Suggested Answer: C

The Owner field in the table page shows the current owner of the table and allows the owner to change it to another user or group. To change the ownership of the table, the owner can click on the Owner field and select the new owner from the drop-down list.This will transfer the ownership of the table to the selected user or group and remove the previous owner from the list of table access control entries1. The other options are incorrect because:

A)Removing the owner's account from the Owner field will not change the ownership of the table, but will make the table ownerless2.

B)Selecting All Users from the Owner field will not change the ownership of the table, but will grant all users access to the table3.

D)Selecting the Admins group from the Owner field will not change the ownership of the table, but will grant the Admins group access to the table3.

E)Removing all access from the Owner field will not change the ownership of the table, but will revoke all access to the table4.Reference:

1: Change table ownership

2: Ownerless tables

3: Table access control

4: Revoke access to a table

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

20 comments · newest first

Xochitl 10 months ago

E doesn't make sense at all, why remove all access?

Pearly 11 months ago

No way D is correct, admins shouldn't own everything!

Marya 11 months ago

Wait, can you really just select "All Users"? That seems risky!

Clemencia 11 months ago

I think A could work too, but not sure if it's the best option.

Nicholle 11 months ago

Definitely C, that's the right way to change ownership!

Rhea 12 months ago

I feel like D could be a possibility too, but it doesn't sound like it would actually change ownership to a specific user. I’m leaning towards C as well.

Ilona 12 months ago

I practiced a similar question, and I think you definitely can't just remove your own account without assigning it to someone else. So, C seems right again.

Raymon 12 months ago

I'm not entirely sure, but I remember something about not being able to select "All Users" for ownership. That feels like a trap option.

Louann 1 year ago

I think the right choice might be C, where you select the new owner's account. That seems to make the most sense for changing ownership.

Melda 1 year ago

I'm a bit confused by the wording of the question. I'll need to re-read it a few times to make sure I'm not missing any important details.

Leonora 1 year ago

Okay, I got this. The key is to edit the Owner field and select the new owner, not remove the current owner or give access to all users.

Oretha 1 year ago

Hmm, I'm not sure about this one. I'll need to carefully read through the options to make sure I understand the question fully before answering.

Lorriane 1 year ago

This seems straightforward - I think the answer is to edit the Owner field and select the new owner's account.

My 1 year ago

Easy peasy! The answer is clearly option C - edit the Owner field and select the new owner's account. Can't wait to move on to the next question.

Maia 1 year ago

I'm pretty confident that the correct answer is D. Maintaining the integrity of the messages is critical to prevent unauthorized changes that could disrupt the system.

Ceola 1 year ago

Hmm, I'm not totally sure about this one. I know NETCONF is used for configuration management, but I can't remember if RESTCONF is one of the options. I'll have to think this through carefully.

Marci 1 year ago

I think the key here is to focus on the CAN-SPAM Act requirements. The email needs to have transactional content first, before any commercial content, and the subject line should be non-promotional.

Charolette 1 year ago

Wait, I think the age limit is actually 10 years old. That sounds right, but I'll double-check my notes just to be sure.

Stephane 2 years ago

I agree with Serina. Selecting the new owner's account seems like the right approach.

Serina 2 years ago

I think the analyst can use option C to change the owner to the new user.

Databricks Certified Data Analyst Associate Exam - Topic 6 Question 7 Discussion