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
Mob_nav_barsMENU

Databricks Exam Databricks Certified Data Engineer Associate 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, 08: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:

Submit Cancel
Emerson
2 days 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 days ago
I think option C is the right choice because it uses DELETE, which is meant for removing rows.
upvoted 0 times
...
Queenie
13 days 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
19 days 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
24 days 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
30 days 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
1 month 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
5 months ago
I think C is the correct answer because DELETE removes rows from the table.
upvoted 0 times
...
Crista
5 months 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
4 months ago
User 3: Agreed, time to keep the table fresh!
upvoted 0 times
...
Ciara
4 months ago
User 2: Yeah, let's get rid of those old rows!
upvoted 0 times
...
Tiera
5 months ago
User 2: Good choice! Let's keep the table fresh and updated.
upvoted 0 times
...
Cory
5 months ago
User 1: C
upvoted 0 times
...
Leonie
5 months ago
User 1: C) DELETE FROM my_table WHERE age > 25;
upvoted 0 times
...
...
German
6 months ago
I'm not sure, but I think it might be D.
upvoted 0 times
...
Filiberto
6 months ago
I disagree, I believe the answer is E.
upvoted 0 times
...
Torie
6 months ago
I think the correct answer is C.
upvoted 0 times
...
Princess
6 months 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
6 months ago
I'm going with C as well. Deleting the rows is the most straightforward way to update the table.
upvoted 0 times
Elliot
5 months ago
C) DELETE FROM my_table WHERE age > 25;
upvoted 0 times
...
Jose
5 months ago
B) UPDATE my_table WHERE age > 25;
upvoted 0 times
...
Pura
5 months ago
A) SELECT * FROM my_table WHERE age > 25;
upvoted 0 times
...
...
Monroe
6 months 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
6 months ago
That makes sense. It will remove the rows we don't need.
upvoted 0 times
...
Chanel
6 months ago
Yes, you're right. Option C will delete the rows where age is greater than 25.
upvoted 0 times
...
Kasandra
6 months ago
I think option C is the correct answer.
upvoted 0 times
...
...

Save Cancel