Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Certified Data Engineer Associate Exam - Topic 3 Question 49 Discussion

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?
C) DELETE FROM my_table WHERE age > 25;
A) SELECT * FROM my_table WHERE age > 25;
B) UPDATE my_table WHERE age > 25;
D) UPDATE my_table WHERE age <= 25;
E) DELETE FROM my_table WHERE age <= 25;

Databricks Certified Data Engineer Associate Exam - Topic 3 Question 49 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam
Question #: 49
Topic #: 3
[All Databricks Certified Data Engineer Associate Questions]

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

Show Suggested Answer Hide Answer
Suggested Answer: C

: The DELETE command in Delta Lake allows you to remove data that matches a predicate from a Delta table. This command will delete all the rows where the value in the column age is greater than 25 from the existing Delta table my_table and save the updated table. The other options are either incorrect or do not achieve the desired result. Option A will only select the rows that match the predicate, but not delete them. Option B will update the rows that match the predicate, but not delete them. Option D will update the rows that do not match the predicate, but not delete them. Option E will delete the rows that do not match the predicate, which is the opposite of what we want.Reference:Table deletes, updates, and merges --- Delta Lake Documentation


by Robt at Apr 30, 2025, 07:17 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Larue
7 months ago
Wait, can you really delete like that?
upvoted 0 times
...
Svetlana
7 months ago
Definitely C, no doubt about it.
upvoted 0 times
...
Shay
7 months ago
C is the correct answer!
upvoted 0 times
...
Trina
7 months ago
I think A is a better choice, though.
upvoted 0 times
...
Julian
7 months ago
B doesn't even make sense for this question!
upvoted 0 times
...
Sunshine
8 months ago
I feel like option A is just selecting data, not actually removing anything. So, it can't be right, right?
upvoted 0 times
...
Madonna
8 months ago
I practiced a similar question, and I believe the correct answer is C as well. The others don't seem to fit the requirement of removing rows.
upvoted 0 times
...
Emerson
8 months ago
I'm not entirely sure, but I remember something about DELETE being used for removing specific rows based on a condition.
upvoted 0 times
...
Lottie
8 months ago
I think option C is the right choice because it uses DELETE, which is meant for removing rows.
upvoted 0 times
...
Queenie
9 months ago
I'm a bit unsure about this one. The SELECT statement in option A doesn't seem to actually update the table, it just retrieves the rows. And option E with DELETE WHERE age <= 25 is the opposite of what we want. I'm going to go with C as the best choice.
upvoted 0 times
...
Veronique
9 months ago
I think option D might also work - UPDATE my_table WHERE age <= 25. That would keep the rows where age is less than or equal to 25 and effectively remove the ones over 25. But C seems more straightforward to me.
upvoted 0 times
...
Belen
9 months ago
I'm leaning towards option C as well. The DELETE statement seems like the most direct way to remove the rows we don't want and update the table. I just want to double-check that it will save the changes to the Delta table.
upvoted 0 times
...
Mammie
9 months ago
Hmm, I'm a bit confused. Wouldn't the UPDATE statement in option B also work to remove the rows where age is greater than 25? I'm not sure if that's the best approach though.
upvoted 0 times
...
Emelda
9 months ago
This looks like a straightforward SQL question. I think the answer is C - DELETE FROM my_table WHERE age > 25. That will remove the rows where the age is greater than 25 and save the updated table.
upvoted 0 times
...
Torie
1 year ago
I think C is the correct answer because DELETE removes rows from the table.
upvoted 0 times
...
Crista
1 year ago
C is the winner! I'm just glad we don't have to deal with those old folks anymore. Time to keep the table young and vibrant!
upvoted 0 times
Selene
1 year ago
User 3: Agreed, time to keep the table fresh!
upvoted 0 times
...
Ciara
1 year ago
User 2: Yeah, let's get rid of those old rows!
upvoted 0 times
...
Tiera
1 year ago
User 2: Good choice! Let's keep the table fresh and updated.
upvoted 0 times
...
Cory
1 year ago
User 1: C
upvoted 0 times
...
Leonie
1 year ago
User 1: C) DELETE FROM my_table WHERE age > 25;
upvoted 0 times
...
...
German
1 year ago
I'm not sure, but I think it might be D.
upvoted 0 times
...
Filiberto
1 year ago
I disagree, I believe the answer is E.
upvoted 0 times
...
Torie
1 year ago
I think the correct answer is C.
upvoted 0 times
...
Princess
1 year ago
Hmm, I'm torn between B and C. But I think C is the safer bet since it's a direct delete operation.
upvoted 0 times
...
Portia
1 year ago
I'm going with C as well. Deleting the rows is the most straightforward way to update the table.
upvoted 0 times
Elliot
1 year ago
C) DELETE FROM my_table WHERE age > 25;
upvoted 0 times
...
Jose
1 year ago
B) UPDATE my_table WHERE age > 25;
upvoted 0 times
...
Pura
1 year ago
A) SELECT * FROM my_table WHERE age > 25;
upvoted 0 times
...
...
Monroe
1 year ago
Option C is the correct answer. It will delete the rows where the age is greater than 25 from the existing Delta table my_table.
upvoted 0 times
Nana
1 year ago
That makes sense. It will remove the rows we don't need.
upvoted 0 times
...
Chanel
1 year ago
Yes, you're right. Option C will delete the rows where age is greater than 25.
upvoted 0 times
...
Kasandra
1 year ago
I think option C is the correct answer.
upvoted 0 times
...
...

Save Cancel