
Ultimate access to all questions.
In a data engineering project, you are tasked with validating email addresses stored in a 'user_email' column of a dataset to ensure none contain the '@' symbol, as part of a data quality check. The dataset is large and stored in a Delta Lake table. Considering the need for efficiency and accuracy in Spark SQL, which of the following queries would you use to correctly identify all rows where the 'user_email' column does not contain the '@' symbol? Choose the best option.
A
SELECT * FROM dataset WHERE user_email NOT LIKE '%@%'*_
B
SELECT * FROM dataset WHERE user_email NOT CONTAINS '@'*_
C
SELECT * FROM dataset EXCEPT SELECT * FROM dataset WHERE user_email LIKE '@%'_
D
SELECT * FROM dataset WHERE POSITION('@' IN user_email) = 0*_