Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
What happens when the following query is executed to process customers' requests to be forgotten?
DELETE FROM customers
WHERE customer_id IN
(SELECT customer_id FROM delete_requests)
```_
DELETE FROM customers
WHERE customer_id IN
(SELECT customer_id FROM delete_requests)
```_
A
The identified records will be removed from the customers table, and their associated data files will be permanently deleted from the table directory.
B
The identified records will be removed from both the customers and delete_requests tables, and their associated data files will be permanently deleted from the tables' directories._
C
The identified records will be removed from the customers table, but they will remain accessible in the table history until a VACUUM command is executed.
D
The identified records will be removed from both the customers and delete_requests tables, but they will remain accessible in the table history until VACUUM commands are executed._
E
The identified records will be removed from the customers table, but they will remain accessible in the table history until the status of the requests in the delete_requests table is updated._