What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table
A . 3
B . 2 (Correct)
C . 1
D . 0
E . NULL
Answer: B
Explanation:
The answer is 2,
Count (DISTINCT *) removes rows with any column with a NULL value
Latest Databricks Certified Data Engineer Professional Dumps Valid Version with 278 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund