Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are working with a large dataset stored in a Delta Lake table named 'user_data'. The table contains duplicate entries that need to be removed. Write a Spark SQL query to create a new table 'unique_user_data' that contains only the distinct rows from 'user_data'.
A
CREATE TABLE unique_user_data AS SELECT DISTINCT * FROM user_data*_
B
CREATE TABLE unique_user_data AS SELECT * FROM user_data GROUP BY *_
C
CREATE TABLE unique_user_data AS SELECT DISTINCT * FROM user_data WHERE NOT NULL*_
D
CREATE TABLE unique_user_data AS SELECT * FROM user_data UNION SELECT * FROM user_data